Query Memory Grants and Resource Semaphores in SQL Server
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-10-25 (first published: 2018-10-16)
3,895 reads
Blog Posts
Connecting to SQL Server 2017 using Visual Studio 2017 and getting “An incompatible SQL Server version detected”
This blog post details the error you may get when using Visual Studio 2017 and you get errors that you...
2018-10-24 (first published: 2018-10-13)
1,924 reads
Create a slipstream installer for SQL Server on Windows
Since the release of SQL Server 2008 Service Pack 1 in April 2009, it has been possible to install SQL...
2018-10-24
241 reads
Exceeding My Own Expectations in Life!
Wow! The last five years of my career have been amazing. I went from attending a SQLSaturday a couple of...
2018-10-24
247 reads
I’m in a book! Data Professionals at Work
A while back a friend of mine, Malathi Mahadevan (b/t), asked me if I’d like to do an interview for...
2018-10-24
235 reads
Using Extended Events to Capture Implicit Conversions
Using the appropriate data type to avoid conversions or implicit conversions is a fundamental approach to good T-SQL coding practices....
2018-10-24 (first published: 2018-10-15)
1,812 reads
Whirlwind Tour of Azure SQL Database
I have finally uploaded my Azure SQL Database presentation, apologies for the delay. I am already working on an improved...
2018-10-24
809 reads
DAX – Cumulative Total and Blank Handling
When developing DAX measure, you should be aware that Blank value behavior might be similarly insidious as NULL value in...
2018-10-23
426 reads
Setting Variables in Azure Data Factory Pipelines
(2018-Oct-15) Working with Azure Data Factory you always tend to compare its functionality with well established ETL packages in SSIS. Data...
2018-10-23 (first published: 2018-10-15)
13,942 reads
Slides and Scripts from IT/Dev Connections
If you attended either of my presentations for this past IT/Dev Connections, here are the promised slides and scripts.
As I...
2018-10-23
250 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
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...
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