Tech Books: Caveat Emptor
These days, we have a myriad of ways to judge whether any given product – like, say, a book on SQL...
2011-01-05
777 reads
Blog Posts
Who Should Vote for PASS SQLRally Sessions
Adam Machanic (@AdamMachanic) asked on Twitter if people who aren’t planning on attending PASS SQLRally should still vote for sessions on the schedule. My answer is a resounding...
2011-01-05
6 reads
Who Should Vote for PASS SQLRally Sessions
Adam Machanic (@AdamMachanic) asked on Twitter if people who aren’t planning on attending PASS SQLRally should still vote for sessions...
2011-01-05
810 reads
31 Days of SSIS – Data Flow Breakpoints?! (3/31)
31 Days of SSIS
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. In yesterday’s post I...
2011-01-04
544 reads
31 Days of SSIS – Folder Structures (4/31)
31 Days of SSIS
Hopefully by now you’ve read the introductory post for the 31 Days of SSIS series that I...
2011-01-04
424 reads
Capturing the Execution Plan
One last post on execution plans and Profiler (at least for now)
When trying to check a query’s execution plan, the...
2011-01-04
1,392 reads
Filling in Data Potholes Redux: Tally Tables vs CTEs
In A Previous Installment
Re-Ducks
… our heroine (that’s me) rediscovered CTEs, specifically in the recursive style. That was in my post...
2011-01-04
1,116 reads
Finding last database growth date and time
A file growth operation on a database server is a extremely expensive operation. Many Performance problems correlate to a Data...
2011-01-04
490 reads
Invitation to T-SQL Tuesday #014
Hello and welcome to the first T-SQL Tuesday of 2011!
2010 was a great year for T-SQL Tuesdays, dreamed up and...
2011-01-04
1,290 reads
Making an Operations Manager Module
Operations Manager 2007 R2 ships with Operations Manager Shell which is simply a provider with associated cmdlets for working with...
2011-01-04
854 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
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,...
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