DATEDIFF vs. DATEADD
Let’s talk about the DATEDIFF vs. DATEADD functions in SQL Server. Each one performs a different task. The former calculates...
2017-01-25
13,358 reads
Superman
SQL Server DBA Tips that Can Save Your Ass
On November 9th I presented a session in the PASS Database Administration Virtual Chapter. The title of the session was...
2016-12-12
381 reads
A Recap of PASS Summit 2016
Yes, it’s that time of the year again. It’s time for the annual PASS Summit. Just like every year, I...
2016-10-31
891 reads
Machine Learning – What is It Good For?
Machine Learning is a very powerful technology used in the field of predictive analytics. As far as I see it,...
2016-10-20
419 reads
Recap of My 24HOP Session – From XML to JSON
Yesterday I presented my session From XML to JSON as part of the 24 Hours of PASS online event. There...
2016-09-08
207 reads
Why Would I Want to Use JSON in SQL Server?
SQL Server 2016 offers built-in support for JSON, in a similar way to the support offered for XML since SQL...
2016-09-04
642 reads
Query Timeout of the Distribution Agent
Last week I got a call from one of our clients. They issued an ALTER TABLE command in order to...
2016-08-22
3,784 reads
SQL Server 2016 Cumulative Update 1
On July 25th Microsoft released the first cumulative update (#1) for SQL Server 2016. This is a good reason to...
2016-08-04
324 reads
Who the Hell is Going to Listen to SQL Server on the Radio
About 3 years ago Matan Yungman contacted me and said he has an interesting proposition. We met and talked about...
2016-07-21
282 reads
We Must Wait for SP1 before Upgrading to SQL Server 2016
This post is for T-SQL Tuesday, hosted by Michael Swart (blog | twitter). This month’s topic is all about SQL Server 2016
I’ve been...
2016-06-14
257 reads
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