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,380 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,785 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
258 reads
Blogs
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
The FinOps Lifecycle: From Budgeting to Reporting
By HeyMo0sh
Working in DevOps long enough teaches you two universal truths: That’s exactly why I...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers