PASS Summit 2012 session videos online
All PASS Summit 2012 recordings are now available for free to all PASS members (201 of them!). To view, log on...
2014-03-27
806 reads
Tally Tables in T-SQL
The Tally (or Numbers) table is one of the most useful constructs in intermediate-level SQL. Have you ever written a...
2014-03-27
57,142 reads
Quick Tip: Migrating a SQL Server Mirroring Witness server.
If you’re like me, you might be thinking “I want some more things to think about when I migrate between...
2014-03-27
674 reads
Two IDs, One database and a Magic Number (and maybe even an empty string)
TweetG’day,
I noticed something odd recently when looking at sys.dm_exec_requests. Specifically the system processes listed in that DMV – well at least...
2014-03-26
1,358 reads
SQL Scripts Manager
We have Down Tools Week multiple times per year at Red Gate. This allows various employees to spend a week...
2014-03-26
4,183 reads
Zap Business Intelligence Installation
This walkthrough helps you to install Zap Business Intelligence. Some of you may need help knowing where to download the...
2014-03-26
972 reads
Speaking at OPASS – April 2014
If my blog history is correct the last time I presented at oPASS was January 2012 – that seems like a...
2014-03-26
629 reads
SQL Saturday Oklahoma City precon: Becoming an Enterprise DBA
We’ll be at OKC this summer for their SQL Saturday on August 23, and we’re presenting our precon “Becoming an...
2014-03-26
617 reads
The Unusable User–Question Of The Day
My latest question The Unusable User is live today over at SQLServerCentral. It’s a three pointer, how is that for...
2014-03-26
694 reads
Collation: Expression
I had a recent run in with collation problems and it got me started reading. As I read I started...
2014-03-26
516 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
AI Is Improving Security
Comments posted to this topic are about the item AI Is Improving Security
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers