5 Game Changers with SQL Server 2019
Microsoft made SQL Server 2019 Generally Available this week we want to share some videos and code examples of our favorite new features. Most of these will make your...
2019-11-05
113 reads
John Sterrett
5 Game Changers with SQL Server 2019
Microsoft made SQL Server 2019 Generally Available this week we want to share some videos and code examples of our favorite new features. Most of these will make your...
2019-11-05
2 reads
Join us for FryeDay!
Once again it is PASS Summit week in Seattle. This is the biggest event in the world for SQL Server...
2018-11-07
150 reads
Join us for FryeDay!
Once again it is PASS Summit week in Seattle. This is the biggest event in the world for SQL Server and Microsoft Data Professionals to gather to connect, share...
2018-11-07
5 reads
Best Hidden Feature in SQL Server 2019
With Microsoft’s Ignite conference this week a lot of new features are being advertised all over the internet. Most likely...
2018-09-26
574 reads
Best Hidden Feature in SQL Server 2019
With Microsoft’s Ignite conference this week a lot of new features are being advertised all over the internet. Most likely if you are following along you have heard of...
2018-09-26
62 reads
SQL Server Automatic Tuning in the Real-World
In SQL Server 2016 we saw Query Store. Query Store was a game changer to help database administrators identify troublesome...
2018-09-19 (first published: 2018-09-10)
2,945 reads
SQL Server Automatic Tuning in the Real-World
In SQL Server 2016 we saw Query Store. Query Store was a game changer to help database administrators identify troublesome queries. Query Store helps DBAs make those queries run...
2018-09-10
46 reads
Why We’re Organizing SQL Saturday in Wheeling, WV on April 28th
Some of my friends know I am a huge fan of the song “Havana” by Camila Cabello. They also know...
2018-03-29
1,512 reads
Why We’re Organizing SQL Saturday in Wheeling, WV on April 28th
Some of my friends know I am a huge fan of the song “Havana” by Camila Cabello. They also know I like to remix songs and if I was...
2018-03-29
3 reads
Blogs
A Conversation That Refused to End: What We Learned from Our First Event in Zurich
On May 8, 2025, we hosted our first official event in Switzerland at Prime...
A DevOps Workshop Tomorrow in Atlanta
By Steve Jones
Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so...
Stop Wasting Time Rebuilding Indexes Every Night
By Kevin3NF
Too many IT teams run index rebuild jobs on autopilot. Every night. Every index....
Forums
CAST(VARCHAR(n)) resolved performance issue?
Hi, I would love to hear if anyone can tell me why a CAST...
isnull, coalesce overhead
hi, one of our sister division's erp extract view is going thru at least...
is there an elegant way for agent notification to show failure if any step fails
hi our corp dw load sqlagent job goes to the next step on the...
Question of the Day
The Internals of Writing a Page
In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes?
See possible answers