SQL SERVER : SQL Server Scheduler
While troubleshooting the performance issues of SQL server, you might have seen the sessions are in different state like SUSPENDED,RUNNING,RUNNABLE etc....
2012-07-12
8,734 reads
Blog Posts
SQL SERVER : The Scene Behind NOLOCK
I have heard many time people talking about the NOLOCK hint. Some of them says it improves the performance and...
2012-07-12 (first published: 2012-07-04)
6,747 reads
SQL Server DBA Tool Kit
Right next to my batarang and bat-zip-line-hook-shooter-gun on my utility belt is my SQL Server DBA Tool Kit, full of...
2012-07-12
1,069 reads
SQLSaturday #158 Event Update & Hotels - Where are you staying?
Well, we're just a few weeks away from the return of SQLSaturday to NYC as SQLSaturday#158, and it is sure...
2012-07-12
1,687 reads
SQLTreeo is suspended
Last few month I was really busy and had completely no time for SQLTreeo. This add-in was started being used by...
2012-07-12
825 reads
Stress Testing Stored Procedures with Free Tools
I currently have a presentation named Performance Tuning for Pirates. This presentation goes over using several free tools to help...
2012-07-12
1,413 reads
Understanding the CDC State Value
If you are using Change Data Capture (CDC) it can be very useful to look at the CDC State table...
2012-07-12
2,192 reads
Columbia Enterprise Developers Guild meeting tonight
If you're in or around the Midlands of South Carolina area, the Columbia Enterprise Developers Guild meets the 2nd Wednesday...
2012-07-11
953 reads
Decryption and CASTing
In my last encryption post I showed how to encrypt and decrypt data with a symmetric key. However there was...
2012-07-11 (first published: 2012-07-03)
3,406 reads
Different ways to move Sql Server file location
Different ways to move Sql Server file location For space issue on drive , performance load balancing or some other reasons,...
2012-07-11
1,022 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers