Improving instead-of-insert cardinality estimates for inserted and deleted pseudotables in SQL 2014+
Tricky triggers
In my last entry I noted that the performance of "instead-of" triggers can be tricky.
One of the reasons for...
2017-11-07
568 reads
Blog Posts
PASS Summit 2017
Hello all!
This past week was PASS Summit 2017, a super crazy/awesome week! So many great things happened this week and...
2017-11-07
94 reads
Power BI Custom Visuals Class (Module 74 – Cylindrical Gauge MAQ Software)
In this module you will learn how to use the Cylindrical Gauge Custom Visual by MAQ Software. The Cylindrical Gauge...
2017-11-07 (first published: 2017-10-24)
1,599 reads
SQL Server Management Studio Reports
Today’s tip is a very basic functionality that comes with any SSMS (SQL Server Management studio), we are talking about...
2017-11-07
162 reads
Synchronous VS Asynchronous Statistics Updates
One of the things I’ve been able to implement to help with performance is changing from Update Statistics Synchronous to...
2017-11-07 (first published: 2017-10-25)
1,811 reads
Tuning Throughput from Azure Event Hub to Azure Stream Analytics
[read this post on Mr. Fox SQL blog]
Recently I had a requirement to load streaming JSON data to provide a...
2017-11-07
752 reads
Tuning Throughput from Azure Event Hub to Azure Stream Analytics
[read this post on Mr. Fox SQL blog] Recently I had a requirement to load streaming JSON data to provide a data feed for near real-time reporting. The solution streamed...
2017-11-07
8 reads
AWS – Move Data from HDFS to S3
In the big-data ecosystem, it is often necessary to move the data from Hadoop file system to external storage containers...
2017-11-06
352 reads
Azure SQL Database Compatibility Levels
Let’s start off with a quick overview of SQL Server versions and compatibility levels.
100 = SQL Server 2008 and Azure SQL...
2017-11-06
519 reads
DBA Definitions: FILLFACTOR
It was recently brought to my attention that not everyone knows everything. This was a shock. Everyone is born knowing...
2017-11-06
520 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Happy Holidays, Let's Do Nerdy Stuff
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers