The default filegroup, and why you should care.
You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index...
2018-02-19
587 reads
Dealing with stress
Anyone who knows me will know that I’m something of a stress head. I tend to worry about things and...
2018-02-19
386 reads
How to create System-versioned temporal tables? – New database feature of SQL Server 2016
Creating a System-Versioned Temporal Table – There are three ways to create a system-versioned temporal table with regards to how the...
2018-02-19
1,184 reads
Distributing SSH User Keys via PowerShell
Folks in the Linux world are used to moving SSH keys to and from systems enabling password-less authentication. Let’s take a minute to look at what it takes to...
2018-02-18
17 reads
Distributing SSH User Keys via PowerShell
Folks in the Linux world are used to moving SSH keys to and from systems enabling password-less authentication. Let’s take...
2018-03-02 (first published: 2018-02-18)
6,526 reads
New Pluralsight Course – LFCE: Linux Service Management – Advanced HTTP Services
My new course “LFCE: Linux Service Management – Advanced HTTP Services” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want...
2018-02-17
34 reads
New Pluralsight Course – LFCE: Linux Service Management – Advanced HTTP Services
My new course “LFCE: Linux Service Management – Advanced HTTP Services” in now available on Pluralsight here! If you want to learn about the...
2018-02-17
526 reads
SQL Server Error 3013: Restore Database is Terminating Abnormally
Overview of SQL Server Error 3013
One of the most frustrating situations that a user experiences while working with SQL Server...
2018-02-17
17,560 reads
CROSS JOIN for fun
My son, who wishes to be known as “Pigeon” for the duration of this blog, was mixing the names of Hogwarts...
2018-02-17
1,111 reads
dbatools and Orphaned Users
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2018-02-16
799 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers