The RGE
I first heard this little acronym from Grant Fritchey (b | t). He used it when talking about backups and restores,...
2016-06-24 (first published: 2016-06-17)
1,812 reads
Return Max or Min Value of a Group of Columns as a Single Column
Recently, I needed a query to identify tables that developers had create as point-in-time backups of tables that were never...
2016-06-17
792 reads
Upcoming Course – LFCE: Advanced Linux Networking
I’m pleased to announce that I’m working on a new course for Pluralsight.
The course is titled LFCE: Advanced Linux Networking.
This course targets IT professionals that design and maintain Linux...
2016-06-17
15 reads
Upcoming Course – LFCE: Advanced Linux Networking
I’m pleased to announce that I’m working on a new course for Pluralsight.
The course is titled LFCE: Advanced Linux Networking.
This...
2016-06-17
788 reads
Why is creating excel sheets from SSIS so hard ?
If there is one process that should be simpler than it is out of the box, it is creating Excel...
2016-06-17
1,462 reads
SQL Server Indexing Book Giveaway – Week 3
In past two weeks’ posts (1, 2) I talked about how I’ve got a few copies of Expert Performance Indexing for SQL Server to give away. This is a book that I...
2016-06-17
24 reads
SQL Server Indexing Book Giveaway – Week 3
In past two weeks’ posts (1, 2) I talked about how I’ve got a few copies of Expert Performance Indexing for...
2016-06-17
729 reads
Connect to SQL Azure database from SSMS
In this article I'll show you how to connect to SQL Azure database instance and create a simple database. First you have...
2016-06-17
350 reads
SSMS Tools Pack - A Handy Tool for generating CRUD
So I've had this tool around for a while, but never found much usage out of it to be honest....
2016-06-17
2,946 reads
Selective Logging with the UPDATE() Function
Triggers can be very useful when you want to log changes to your data, but what if you’re only interested...
2016-06-22 (first published: 2016-06-16)
2,393 reads
Blogs
SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library
I built a free library of runnable SQL Server demos. Each reproduces a real...
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...
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