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,911 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
396 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
902 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
433 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
213 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
656 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,909 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
341 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
294 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
268 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
SQL Server Audit Failures
Comments posted to this topic are about the item SQL Server Audit Failures
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers