by David Klee | Oct 17, 2020 | Cloud, Infrastructure, Video
Recording ongoing performance information is vital to have a running history of the system state in case issues arise. More importantly, having a running stream of performance information gives you a running history that you can refer to for generating an ongoing...
by David Klee | Aug 18, 2019 | Cloud, Database
We have a Client that recently expressed interest to make their SQL Servers more efficient so that they can establish a standardized scale-out model for their hosted software platform. The objective was to allow a certain number of ‘normal’ sized customers...
by David Klee | Jan 15, 2018 | Database
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 Klee | Aug 26, 2017 | Database, Video
The DBA Fundamentals group recently posted the video from my Linux for the SQL Server Administrator session. Check it...
by David Klee | Aug 8, 2017 | Database
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 Klee | Jul 24, 2017 | Database, Virtualization
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 Klee | May 30, 2017 | Database
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...
by David Klee | May 11, 2017 | Database
As you all have heard, Microsoft is supporting Linux as a supported operating system for the next version of SQL Server (recently announced to be version 2017). What?? Why?? Didn’t Steve Ballmer call Linux a “cancer” a while back? Times change....
by David Klee | May 8, 2017 | Database
Starting this week, I’m introducing a new series of blog posts for the SQL Server DBA on how to properly set up and administer a production SQL Server on the Linux operating system. As you know, Microsoft is shipping SQL Server 2017 (currently at CTP 2.0) with...
by David Klee | Nov 29, 2016 | Database, Virtualization
VMware’s latest release of the vSphere virtualization suite, version 6.5, changes how they handle vNUMA presentation to a virtual machine, and there’s a high likelihood that it will break your virtualized SQL Server vNUMA configuration and lead to...
Recent Comments