Database Mirroring Isn’t Going Anywhere
AlwaysOn Availability Groups is a great technology that centralizes the management of High Availability, Disaster Recovery and Scale-Out. However, in...
2015-09-24
1,329 reads
Blog Posts
Excel as a Database Professional
People ask me all the time how to become a DBA. This is a topic that so many colleagues of
mine...
2015-09-24
2,155 reads
HammerDB Performance Collection with SQL Server – Updated
A while back, my friend Mike Fal ( b | t ) released a PowerShell script that can sample the counter inside SQL...
2015-09-24 (first published: 2015-09-13)
2,409 reads
How to use SORT control in SSIS ? TIP #115
Dear Friends,
In the series ofLearn SSIS step by step this is the 5th post. Now from this post we are...
2015-09-24 (first published: 2015-09-12)
2,298 reads
I Was Once a Very Crappy Carpenter + SQL Bolts to Buzzwords
Tonight I spoke to Dr. Alkadi's CMPS 411 class, which was hijacked by the Hammond .NET User Group onsite at...
2015-09-24
669 reads
SQL Server Enterprise Edition Advanced Scanning
It is widely known that SQL Server Enterprise Edition contains a range of improvements, which under certain conditions allow you to perform operations in a more optimal way in...
2015-09-24
9 reads
SQL Server Enterprise Edition Advanced Scanning
It is widely known that SQL Server Enterprise Edition contains a range of improvements, which under certain conditions allow you...
2015-09-24
1,610 reads
SQL Server Enterprise Edition Advanced Scanning
It is widely known that SQL Server Enterprise Edition contains a range of improvements, which under certain conditions allow you to perform operations in a more optimal way in...
2015-09-24
9 reads
Why is my tSQLt test not running?
I wrote a test earlier and forgot one of the two cardinal rules about tSQLt so I was running my...
2015-09-24 (first published: 2015-09-10)
1,231 reads
“sql_handle” is not a recognized table hints option.
I’ve you’ve run a query similar to the following:
SELECT *
FROM sys.dm_exec_requests
CROSS APPLY sys.dm_exec_sql_text(sql_handle);And gotten an error similar to:
Msg 321, Level...
2015-09-23
1,037 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers