AdventureWorks2012 Bug on Azure
While I have production databases in Azure, I can’t exactly experiment with them at will. Further, while they mostly have...
2013-09-25
1,323 reads
The Scary DBA
Premium Database on Azure
One of the things that can make Windows Azure SQL Databases (WASD) attractive is the fact that they run inside...
2013-09-24
774 reads
PASS Votes and So Should You
To put it bluntly, you need to go cast a vote for Allen Kinsel for the PASS Board.
In his own...
2013-09-23
953 reads
Web Design & Azure
I’ve listened to tons of programmers and DBAs complain about the look of Windows Azure. But, I’m friends with several...
2013-09-20
629 reads
SQL Lighthouse
Red Gate is constantly experimenting with technology. Because of a long history working within the Microsoft space, a lot of...
2013-09-19
824 reads
Finding Ad Hoc Queries with Query Hash
I was presenting a session on how to read execution plans when I received a question: Do you have a...
2013-09-20 (first published: 2013-09-18)
3,390 reads
Great Idea: Tribal SQL
Writing books, even just a chapter, is not easy. Yet, people are desperate to do it for some reason. But,...
2013-09-17
845 reads
Why the Lazy Spool Is Bad
First thing, there are no bad operators, just bad parents, uh, I mean query writers, or database designers, or ORM...
2013-09-24 (first published: 2013-09-16)
3,582 reads
Are Foreign Keys Better Than Indexes?
When I first saw this question I thought to myself, “Self. Don’t you think that’s comparing apples to hammers? Yes,...
2013-09-13
954 reads
Microsoft Expands Data Centers… Again
Didn’t they just do this in the spring? Word is out that they’re expanding even more data centers. The cynical...
2013-09-12
678 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers