Handling Type II Dimension with the MERGE Statement
Microsoft attempted to make our lives easier with the Slowly Changing Dimension task in SSIS. However, as we all know...
2010-11-17
2,021 reads
Dynamically Backing Up All User Databases in SQL Server
I recently had a request from a client to come up with a routine to do a full compressed database...
2010-11-16
1,428 reads
SQL Server Team-Based Development
The new book is available in a free download from Red Gate. I had a lot of fun working on...
2010-11-16
1,173 reads
PASS Summit Report 2: Seattle Again?
There is always a lot of talk about the fact that we have been in Seattle several years in a...
2010-11-16
1,173 reads
The SQL Server MCM Training Has Changed
One thing that stuck out for me at the PASS Summit was the changes announced for the SQL Server Microsoft...
2010-11-16
2,451 reads
SQL Server 2008 Service Pack 2 Cumulative Update 1
Microsoft has released SQL Server 2008 Service Pack 2 Cumulative Update 1, which is Build 4266. I count 67 fixes...
2010-11-16
1,012 reads
The World’s Largest
Each year, the Georgia Bulldogs and the Florida Gators meet on the college grid iron in what’s called the world’s...
2010-11-16
535 reads
PASSMN Meeting Today
Check us out today by either traveling down to Bloomington or jumping in and joining us online. Today Minnesota’s SQL...
2010-11-16
768 reads
PASS Update #47–Election Review Committee
As always, this represents my own views, I’m speaking only for me and not the entire PASS Board.
Early last week...
2010-11-16
682 reads
What's New In Denali for SSRS
I was so excited when I found out that Denali was released last week. Like it was Christmas time, I...
2010-11-16
484 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
MERGE in a nested TRY/CATCH won't roll back
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers