Microsoft Update Catalog
In today’s world of database administrations, there are a plethora of tools and resources that can be available to utilize...
2019-01-25
380 reads
Blog Posts
Speaking at SQLBits 2019
Speaking at SQLBits 2019!
I’m proud to announce that I will be speaking at SQLBits on March 2nd 2019! It’s been a...
2019-01-25
172 reads
Speaking at SQLBits 2019
Speaking at SQLBits 2019!
I’m proud to announce that I will be speaking at SQLBits on March 2nd 2019! It’s been a goal of mine to speak at SQLBits for...
2019-01-25
4 reads
SQL FAILS with Andy Mallon, Erin Stellato, and Mr. Anonymous!
Watch this week’s video on YouTube.
While most of us strive to make as few mistakes as possible when it comes...
2019-01-25 (first published: 2019-01-15)
2,205 reads
SSDT: /p:AllowIncompatiblePlatform, what platforms are compatible?
Sometimes you don’t have the perfect development environment for SQL Server, sometimes you deploy to things like SQL Azure and...
2019-01-25
232 reads
SSDT: /p:AllowIncompatiblePlatform, what platforms are compatible?
Sometimes you don’t have the perfect development environment for SQL Server, sometimes you deploy to things like SQL Azure and want to test locally, for various reasons it is...
2019-01-25
12 reads
SSDT: /p:AllowIncompatiblePlatform, what platforms are compatible?
Sometimes you don't have the perfect development environment for SQL Server, sometimes you deploy to things like SQL Azure and want to test locally, for various reasons it is...
2019-01-25
9 reads
The Execution plan comparison feature (in SSMS)
Did you know that you can compare two execution plans in SQL Server Management?
It’s really cool. I use it a...
2019-01-25
1,001 reads
Azure SQL Database Roadmap
I do not usually link straight to other blog posts or technical papers but I really had to with this...
2019-01-24
309 reads
Extended Events: Detect Implicit Conversions that affect execution plans
Implicit Conversions – Introduction
In this blog post, I’ll explain and demonstrate how to use Extended Events to detect Implicit Conversions that...
2019-01-24 (first published: 2019-01-15)
2,864 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers