Holiday Review: Stuff I
For the last two years, I’ve participated in Sean’s InfoWorld Xmas Wish List, where we review a bunch of cool...
2010-11-24
572 reads
Blog Posts
How Do I Change SSRS Report Credentials with Powershell?
Today’s script took a long time to write. The concepts are fairly simple and the resulting script is quite trivial...
2010-11-24
7,111 reads
I'm a Midnight DBA
Well, not really. However when I was recently up in Seattle, Jen and Sean McCown contacted me about being on...
2010-11-24
827 reads
Notes from SQLSaturday#59 - Waits & Queues Presentation
SQLSaturday#59 – Waits & Queues Presentation
At SQLSaturday#59 in NYC, my session was about Waits & Queues. I presented a topic I thought was...
2010-11-24
929 reads
SSIS Denali Annotations
I have written a couple quick blogs recently sharing some of the new usability changes for SSIS in Denali.In previous...
2010-11-24
669 reads
What I’m Thankful For
Since it is the week of Thanksgiving in the United States, Jason Strate (@strateSql) has requested that bloggers post what...
2010-11-24
585 reads
XQuery for the Non-Expert – Resources
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
Learning XQuery...
2010-11-24
1,602 reads
2010 PASS Summit Recap
The 2010 PASS Summit has been over for a week and a half now and I've finally recovered & processed everything...
2010-11-23
683 reads
A Couple Interesting Talks
At the PASS Summit a few weeks ago, the keynote talks and the WIT luncheon were streamed live to the...
2010-11-23
816 reads
Building A PowerShell Module Installer
As part of the 2.3 build of SQLPSX I built an MSI based installer to package all 10 SQLPSX modules....
2010-11-23
2,102 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