Buried
Coming back after a week off, even a holiday week when traffic is relatively low, is no fun. I have...
2010-11-29
1,478 reads
Blog Posts
CDC Interoperability with Mirroring and Recovery
CDC Interoperability with Mirroring and Recovery
The following email came in to a discussion group last week asking several questions about...
2010-11-29
2,347 reads
Cleaning Up Blogs
I highly encourage people to blog. I know that not everyone is a writer, but I think that blogging helps...
2010-11-29
1,595 reads
Drumroll Please…
Defensive Db Programming Chapter 10
After dragging this review on for months now, it is finally time to bring this bad...
2010-11-29
1,382 reads
Drumroll Please…
Defensive Db Programming Chapter 10 After dragging this review on for months now, it is finally time to bring this bad boy home and wrap it up. I have...
2010-11-29
7 reads
Lock escalation : SQL Server 2008
Lock escalation is a event which occurs when SQL Server decides to upgrade a lock at a lower level hierarchy...
2010-11-29
1,328 reads
PASS Update #48
It’s the end of November and this will probably be my last update on PASS for the year as things...
2010-11-29
1,564 reads
TechEd 2011
TechEd will be in Atlanta next year, May 16-19, 2011 at the Georgia World Conference Center. I went this year...
2010-11-29
1,535 reads
Using DMVs to Find the Ports that SQL Server is Listening On
The other day I was asked to provide the port number that a SQL Server instance was listening on. As...
2010-11-29
3,336 reads
Determining An Enterprise Execution Policy Setting
Windows PowerShell has the concept of execution policy that determines in which cases script and configuration files are able to...
2010-11-28
2,362 reads
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers