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,315 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
761 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
946 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
626 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
820 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,303 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
841 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,576 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
892 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
677 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers