by David | Mar 1, 2018 | Cloud, Technology
You might have noticed that I’ve been pretty quiet as of late. We’re working on a super top secret internal project here at my company, and we’ve got the need to ingest a LOT of data around the clock for some analytics work. My preferred DBMS is, of...
by David | Jan 15, 2018 | SQL Server, Technology
Next in our SQL Server on Linux series is one important question. On Windows, if you’re about to run out of space, you get your VM admin / storage admin to expand one or more of your drives, and you go to Disk Management and expand the drive with no downtime....
by David | Aug 8, 2017 | Best Practices, SQL Server, Technology
One of the challenges with any SQL Server business continuity strategy is backing up your databases and logs on a frequent basis. With Windows, we’ve known how to accomplish this for years. But, with SQL Server on Linux, you can accomplish the same task with...
by David | Jul 27, 2017 | Best Practices, SQL Server, Technology
In the last blog post, we added additional drives to the SQL Server machine so that we can scale out our storage workload. Let’s move the tempdb objects to one of these new drives! By default, our tempdb files are in the system database folder at...
by David | Jul 24, 2017 | Best Practices, SQL Server, Technology
One of the biggest differences with managing SQL Server Linux is with drive presentation. With Windows, we’d all scream if we saw a SQL Server with just one drive (C:) and everything piled on it. The same goes for any other operating system, including Linux....
by David | May 30, 2017 | Best Practices, SQL Server, Technology
SQL Server administration, once installed and running, doesn’t vary too much based on your operating system, but the differences in the operating systems are pretty significant. To properly administer a production SQL Server on Linux, an administrator needs to...