Creating an SSIS project
Now that SSDT (SQL Server Data Tools) has been installed the next step is to create a project. First, open...
2017-08-30 (first published: 2017-08-16)
1,897 reads
SQL Server vs Oracle: How to replace NULL values
It’s Wednesday and that means another SQL/Oracle post. Today we’ll be discussing NULL Values, which can sometimes be a real...
2017-08-28 (first published: 2017-08-16)
9,447 reads
Attaching databases via a dockerfile
Last week I presented my session on SQL Server & Containers for the PASS Virtualization Group and during my prep I...
2017-08-28 (first published: 2017-08-16)
2,965 reads
SQLCLR vs. SQL Server 2017, Part 3: “CLR strict security” – Solution 2
Welcome back, everyone. In the previous post in this series, I explained how to work within the new SQLCLR security...
2017-08-16
720 reads
Ultrawide Monitor - Samsung CF971 - First impressions
As a developer, I’ve been a big fan of multiple monitors for a long time. I moved to a triple...
2017-08-15
264 reads
How to Eliminate Ugly Nested REPLACE() Functions
Watch this week's video on YouTube
How many times have you had to transform some column value and ended up stacking several nested SQL REPLACE() functions like this?
-- Input: Red,...
2017-08-15
17 reads
Planning a SQL Server Backup and Restore strategy in a multi-server environment using PowerShell and T-SQL
This post demonstrates one of the ways to gather an inventory of database backup information. The output of the script...
2017-08-15
448 reads
Automatic Sample Sizes for Statistics Updates
I mentioned in my previous post about manually updating statistics that you can specify whether they’re updated using a full...
2017-08-23 (first published: 2017-08-15)
1,499 reads
Bad Parameter Sniffing Decision Flow Chart
Lots of people are confused by how to deal with bad parameter sniffing when it occurs. In an effort to...
2017-08-15
210 reads
Bad Parameter Sniffing Decision Flow Chart
Lots of people are confused by how to deal with bad parameter sniffing when it occurs. In an effort to...
2017-08-24 (first published: 2017-08-15)
2,361 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