You don’t really need ORDER BY do you?
You see dozens of blog posts and articles about how the order of a result set is not guaranteed without...
2014-12-01 (first published: 2014-11-19)
9,658 reads
Blog Posts
Video articles
While thinking of ways to improve the way I can get SQL Server information across to those who follow my...
2014-11-30
961 reads
Giving away FREE Access to my SQL Server High Availability and Disaster Recovery Deep Dive Course – Round 2
Originally posted on - Microsoft technologies and what I do for fun -:
Last year, as part of launching my very first...
2014-11-29
1,144 reads
A look at the SQL Assessment Intelligence Pack in Operational Insights
Operational Insights is a service that has been added in preview to Azure. It enables you to collect, combine, correlate...
2014-11-28 (first published: 2014-11-24)
6,790 reads
Changing Delay Between Responses for SQL Alerts with Powershell
So you have read that you should have alerts for severity levels 16 to 24 and 823,824 and 825 on...
2014-11-28 (first published: 2014-11-18)
7,148 reads
Friday Followup For November 28, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-11-28
944 reads
Reblog: November 21 to November 27
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2014-11-28
1,025 reads
Setting up WebStorm to debug grunt with TypeScript
It’s possible to use the WebStorm editor to debug grunt tasks if you are using TypeScript and generating .map files. ...
2014-11-28
1,647 reads
Virtualization Virtual Chapter Webinar – Open Q&A
On December 10 at 11am CST I will be presenting the next PASSVirtualization Virtual Chapter monthly webinar, where you can ask...
2014-11-28
940 reads
Beware the defaults! (in windowing functions) – The Movie!
I was recently contacted by the fine gents of Webucator, an online training services provider. In order to promote their...
2014-11-27
1,068 reads
Blogs
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Forums
Multi-State Payroll Tax Issues 2026
Prepare for 2026 with this essential multi-state payroll tax issues 2026 webinar from Professionals...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers