Why SQL Server?
This Friday Steve Jones asks you how you got started working with SQL Server in your career? Let us know how you got started and why you stuck with it.
SQL Server Statistics Questions We Were Too Shy to Ask
If you need to optimise SQL Server performance, it pays to understand SQL Server Statistics. Grant Fritchey answers some frequently-asked questions about SQL Server Statistics: the ones we somehow feel silly asking in public, and think twice about doing so.
More Evolution, More Complexity
As SQL Server advances and evolves, Steve Jones thinks it gets more complex, not necessarily easier to administer.
Universal Product Codes: a Database Primer
An introduction to Universal Product Codes with code to help you use them in your database.
SSIS Basics: Using the Conditional Split
The Conditional Split can route data rows to different outputs depending on whatever criteria of the data that you wish. It works rather like the SWITCH block in a procedural language. Annette shows how to add a conditional split to your data flow.
Shred XML column using SSIS
This article describes a way using SSIS to shred a XML column from a source table into its respective columns in the destination table.
The Microsoft Sideshow
Microsoft hasn't performed well on the stock market across the last decade, but the company has changed. There are cries that the business has been mismanaged and today Steve Jones has a few comments.
Standardize SQL Server Installations with Configuration Files
If you have a requirement to install multiple SQL Server instances with the same settings, you most likely want to do it without following the numerous manual installation steps. The below tip will guide you through how to install a SQL Server instance with less effort.
Look Beyond the First Result
As computer systems become more complex and dynamic, it's possible that the results we see might not be what we expect. Steve Jones talks about a situation with Orbitz.
SQL Saturday #192 - Tampa
Come and join SQL Saturday Tampa in their new venue (HCC) now that they've outgrown K-Force!
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers