Protected: TSQL Tuesday 108 – Community Rituals
This post is password protected. You must visit the website and enter the password to continue reading.
Advertisements
2018-10-25
229 reads
Blog Posts
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,859 reads
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,921 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
231 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
245 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
226 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,805 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
803 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
419 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,925 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers