SQLBits XI recently announced
When I saw an email from SQLBits announcing SQLBits XI in East Midlands in my inbox this morning, it simply...
2012-11-14
829 reads
Art
Your online security is only as good as the weakest link
Over the weekend I received an email supposedly from Microsoft Live wanting me to verify my account and provided a...
2012-10-26 (first published: 2012-10-24)
1,661 reads
OVER() clause two simple ways on two different days
I’ve been aware of this clause in TSQL for a long time, but I’ve never really used it. Mainly because...
2012-09-26
1,081 reads
Suppressing namespace attributes in nested select statements when using FOR XML workaround
I was helping out on the forums the other day with a user who had stumbled across the quirk of...
2012-08-28
6,796 reads
Script to find orphaned/unreachable job steps within your SQL jobs
SQL jobs are great as the SQL agent job engine allows for very granular control over jobs that are created...
2012-08-23
2,598 reads
Using XQuery to transform multiple xml nodes to a single xml node with comma separated string value
Not another comma separated string blog post I hear you say! I know that this topic has probably been done...
2012-07-13
6,784 reads
Moving xml child elements to its parent using XQuery
I haven’t been able to do much XQuery development recently which is a shame as I love developing with the...
2012-07-09
4,536 reads
Unable to activate a Windows 2003 VM on Hyper-V behind a proxy
Ok, so this is not strictly a post about SQL itself (and it's about a fairly old OS), but I...
2012-06-25
2,719 reads
Shredding a simple xml structure to a single row flat table
I was helping out a user on the forums the other day where they were asking questions about shredding an...
2012-05-22 (first published: 2012-05-16)
5,375 reads
Command line to configure windows firewall for SQL server access
I regularly deploy SQL Server to new Windows Server 2008 hosts and one thing that I find quite a chore...
2012-05-10
3,857 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
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...
Half of All Engineers
Comments posted to this topic are about the item Half of All Engineers
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