Working with ADO.Net variables in SSIS scripts
I am always looking to improve the performance of my SSIS packages. I try to do as much work within...
2010-01-25
5,292 reads
Blog Posts
Working with ADO.Net variables in SSIS scripts
I am always looking to improve the performance of my SSIS packages. I try to do as much work within...
2010-01-25
520 reads
Are You on Twitter?
Like many busy DBAs, I used to be very dismissive of Twitter. It seemed like a self-indulgent waste of time....
2010-01-24
1,905 reads
Recap - SQL Saturday #32 Tampa
This past weekend I was a presenter in two sessions at the SQL Saturday in Tampa.First, I just want to...
2010-01-24
508 reads
SQLSaturday 32 – Tampa Recap
I had the privilege to attend and speak at SQLSaturday 32 – Tampa this past weekend. As I said in my...
2010-01-24
561 reads
XML Index - ALTER INDEX with REBUILD Issue
I run into a small issue at the end last week, a CHECKDB job was reporting corruption on one of...
2010-01-24
666 reads
Indexes Out the Window
I ran into a peculiarly puzzling situation with a query I have been tuning of late. The query runs some...
2010-01-23
1,085 reads
SQL Saturday #32
I presented a one hour session at SQL Saturday #32 in Tampa on Powershell ETL: "In this sesssion we will look...
2010-01-23
424 reads
We Are Microsoft (GiveCamp Dallas)
Last weekend (January 15-17) found me at the third annual GiveCamp Dallas event, known locally as We Are Microsoft. This...
2010-01-23
738 reads
Book Review: K2: Life and Death on the World’s Most Dangerous Mountain
I read Life and Death on the World’s Most Dangerous Mountain by Ed Viesturs ($18 @ Amazon) over the holiday break....
2010-01-22
737 reads
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I specify only the Resource Database?
See possible answers