ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login
    1. Topics
    2. Tags
    3. sql
    Log in to post
    • All categories
    • OksanaO

      SQL Server 2022 and a: New hybrid cloud capabilities.

      Watching Ignoring Scheduled Pinned Locked Moved Starwind starwind sql sql server azure azure arc hybrid cloud
      1
      0 Votes
      1 Posts
      278 Views
      No one has replied
    • WrCombsW

      SQL Server 2019

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion wrcombs sql sql server 2012
      8
      0 Votes
      8 Posts
      886 Views
      ITivan80I

      Yeah i know a former customer using SQL 2012 and he has since left. I have not tried SQL 2019 yet, i wish that i can work with that software.

    • OksanaO

      What Is OSquery and How to Use It on Ubuntu and Linux Mint

      Watching Ignoring Scheduled Pinned Locked Moved Starwind starwind linux mint linux ubuntu sql osequery
      1
      1 Votes
      1 Posts
      485 Views
      No one has replied
    • OksanaO

      Real-World Production Scenario: Squeezing all possible performance out of Microsoft SQL Server AGs (Availability Groups). Local NVMe Vs. RDMA-mapped (NVMe-oF) remote NVMe storage. Does the juice worth a squeeze?

      Watching Ignoring Scheduled Pinned Locked Moved Starwind starwind sql sql server nvme nvme-of availability groups
      1
      1 Votes
      1 Posts
      500 Views
      No one has replied
    • OksanaO

      How to Configure DBeaver on Linux

      Watching Ignoring Scheduled Pinned Locked Moved Starwind starwind sql mysql postgresql
      1
      2 Votes
      1 Posts
      385 Views
      No one has replied
    • OksanaO

      How to Use SQL Tools via AKS Pod to Manage SQL Databases

      Watching Ignoring Scheduled Pinned Locked Moved Starwind sql aks kubernetes
      1
      1 Votes
      1 Posts
      386 Views
      No one has replied
    • OksanaO

      How to Install Oracle Database 19c on Windows Server 2019

      Watching Ignoring Scheduled Pinned Locked Moved Starwind oracle db oracle sql k2
      2
      1 Votes
      2 Posts
      788 Views
      scottalanmillerS

      Sometimes I forget that Oracle is still offering a database product, lol.

    • scottalanmillerS

      ERROR 1366 When Important MySQL Database for WordPress

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion wordpress mysql mariadb sql database rdbms
      2
      1 Votes
      2 Posts
      633 Views
      M

      I've seen that a lot. When I import Drupal databases, I learnt to use its Backup and Migrate module instead, it works flawlessly. Downside is you need to do clean Drupal installation first, but that basically is just creating blank database and putting brick on enter key.

    • scottalanmillerS

      How to Rename a Column in SQLite Database

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion sqlite sqlite3 sql database
      10
      1 Votes
      10 Posts
      1k Views
      scottalanmillerS

      @Pete-S said in How to Rename a Column in SQLite Database:

      There used to be a lot of databases like SQLite. Often called database engines. dBase was probably one of the first.
      Later Microsoft Jet engine (aka Microsoft Access) became popular when Visual Basic ruled the world.
      Basically it's a one user database. You can have more than one user but it's done by multiple users accessing the same database file.

      Or by having an application on top that accessing the file and shares it out. That thing can be called a "database management system" or any application, really.

      All databases use database engines. MySQL, for example, isn't a database. It's a database management system. It uses one or more database engines to talk to the files on disk. MyISAM and InnoDB are two database engine options for the MySQL platform.

      At the end of the day, all databases work like SQlite. You can easily build your own database management system that uses SQlite as the engine and it could work just like MySQL or Oracle or SQL Server. Those are all single users to a file, under the hood. They just have the "multi-access" management built into an extra layer, instead of letting an application handle it.

      But for most things, you only access a database from a single app anyway, so that extra layer is often unnecessary as it is redundant. Just adds overhead.

    • OksanaO

      Building Apps in Ubuntu Using PostgreSQL

      Watching Ignoring Scheduled Pinned Locked Moved Starwind ubuntu postgresql sql ubuntu server django
      1
      1 Votes
      1 Posts
      486 Views
      No one has replied
    • OksanaO

      Microsoft SQL Server FILESTREAM – Giving a bit of structure to your unstructured data

      Watching Ignoring Scheduled Pinned Locked Moved Starwind sql sqlserver microsoft sql database
      1
      1 Votes
      1 Posts
      508 Views
      No one has replied
    • J

      Slow MS SQL Queries between Windows 10 VMs and MS SQL 2014 on same host

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion database rdbms ms sql server ms sql server 2016 sql windows 10 windows server 2016 hyper-v
      27
      2 Votes
      27 Posts
      3k Views
      J

      @pmoncho said in Slow MS SQL Queries between Windows 10 VMs and MS SQL 2014 on same host:

      @JasGot said in Slow MS SQL Queries between Windows 10 VMs and MS SQL 2014 on same host:

      Winner Winner, Chicken Dinner. It was MDTC and Windows Firewall. (Which is frustrating, because the firewall is turned off for the domain!)

      Good job at troubleshooting. I'm wondering what led you down this path versus something related to Networking, hard drives or software drivers?

      Remembered it from several years ago with another SQL based application. Don't know what made me think of it at 1:30am. But I'm ok with it!

    • OksanaO

      Migrate Windows-based vCenter to VCSA 6.7 U1 & ensure hardened safety right now

      Watching Ignoring Scheduled Pinned Locked Moved Starwind vmware vcenter sql vcsa
      1
      3 Votes
      1 Posts
      485 Views
      No one has replied
    • OksanaO

      Windows Site Migration Tool: Migrate your IIS websites at a fast clip

      Watching Ignoring Scheduled Pinned Locked Moved Starwind starwind microsoft sql azure
      3
      3 Votes
      3 Posts
      626 Views
      dbeatoD

      @dbeato said in Windows Site Migration Tool: Migrate your IIS websites at a fast clip:

      The new thing with Microsoft Azure is SiteCore, that is the new trend and people are already on that. Not sure but we might want to discuss that on ML one of this days. @scottalanmiller

      Overreaching of user information
      https://www.sitecore.com/products/sitecore-experience-platform

    • JaredBuschJ

      Looking for method to backup Azure SQL database to another location or service

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion azure sql backup backup and disaster recovery
      2
      4 Votes
      2 Posts
      692 Views
      matteo nunziatiM

      What account the sql account or the azure login?!

    • OksanaO

      How to back up your SQL Server databases to Azure without a hassle

      Watching Ignoring Scheduled Pinned Locked Moved Starwind sql server sql microsoft sql database azure azure backup
      1
      1 Votes
      1 Posts
      629 Views
      No one has replied
    • OksanaO

      Learn how to build a disaster recovery site with SQL Server AlwaysOn AGs

      Watching Ignoring Scheduled Pinned Locked Moved Starwind sql sqlserver microsoft
      1
      1 Votes
      1 Posts
      544 Views
      No one has replied
    • scottalanmillerS

      osTicket: Basic Ticket Report of All Tickets with Subject

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion osticket osticket 1.10 mysql sql mariadb report query
      7
      3 Votes
      7 Posts
      3k Views
      scottalanmillerS

      @bbigford said in osTicket: Basic Ticket Report of All Tickets with Subject:

      Since there is no inner or outter join specified, inner join is obviously being used where 'join' is specified (outter join having to be explicitly defined where an outter join is needed). How come you explicitly specify 'inner join' at the bottom when you could just use 'join' again as your inner join?

      Obviously join and inner join accomplish the same thing, just curious why one is not explicitly defined and the other is.

      I expanded on something done by someone from the osTicket team. it was some weird stylistic choice that they made and I just followed.

    • scottalanmillerS

      osTicket: How to Query a Ticket Subject for a Report

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion osticket osticket 1.10 mysql mariadb sql query report
      1
      3 Votes
      1 Posts
      1k Views
      No one has replied
    • OksanaO

      Getting a grasp of what Always On is and how it works

      Watching Ignoring Scheduled Pinned Locked Moved Starwind microsoft sqlserver sql highavailability ha disasterrecovery hadr
      1
      1 Votes
      1 Posts
      741 Views
      No one has replied
    • 1
    • 2
    • 1 / 2