Recently I migrated my home lab from a SuperMicro SYS-E300-8D to something a little beefier. There were ten virtual machines on the SuperMicro server, nine which were allocated 127 GB of thin-provisioned storage, and one…
Recently there was a thread on Twitter which established that a lot of IT people didn’t know the difference between virtual machines and containers. https://twitter.com/IanColdwater/status/1137737702227550208 I felt like this was a question I’d already answered,…
(This post was updated on 1 August 2022.) A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set cost threshold for parallelism to 50 Disable…
Some time ago we started a new series here, called Database Fundamentals. The very first post in that series asked what a database is. One of the major announcements at Ignite last month was that…
Last year I ran a series of posts about Database Fundamentals. Over the next few weeks, I will cover the basics of various date and time data types in SQL Server, when to use them,…