Column Based Indexing in Denali
Recently, I was asked to install Denali for a client because one of the employees attended PASS 2010 and had...
2010-11-24
926 reads
Blog Posts
Do the Packet Trace - Especially When Things Are Good
Last night we were troubleshooting really poor performance on a core system. One of the things being investigated was a...
2010-11-24
1,028 reads
FreeCon
I got my FreeCon. What’s more, I did it in public and didn’t get in trouble.
FreeCon is the brain child...
2010-11-24
1,611 reads
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
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,088 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
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers