Writing Better Queries in Steel City
T-SQL is a very forgiving language. As long as you have the basic syntax of the statement correct, SQL Server...
2010-07-13
425 reads
Blog Posts
Conversion Between Unicode and Non-Unicode Data Flow Pattern
I don't think I'm alone when I find myself having to convert several columns in my Data Flow from Unicode...
2010-07-12
997 reads
Degree Seeker Week at SQL University, Extra Credit
Degree Seeker Week at SQL University, Extra Credit
Welcome back to Degree Seeker Week at SQL University. If you have returned...
2010-07-12
1,748 reads
Enabling Memory Support for over 4GB of Physical Memory
This is something we had to do again recently and its improved our performance and query speeds on one particular system....
2010-07-12
944 reads
Exceptional DBA of the Year 2010 Finalist!
This post is a tad overdue as the public announcement was a few weeks back but it’s been a topsy-turvy...
2010-07-12
442 reads
It is Great to Get Feedback From My Readers
I get a lot of emails from people who read my blog, books, articles, and from people who have attended...
2010-07-12
503 reads
Mix & Match – Day 4
I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have...
2010-07-12
381 reads
Old McDonalds and The Cow Store
As a child did you have a place that was your ‘thing’, something that just the mention of it would...
2010-07-12
509 reads
PowerShell and Effective Meetings at PASS 2010
Last week, PASS announced this year’s program for the 2010 Summit in Seattle, Washington. The program session are available online....
2010-07-12
438 reads
S3OLV July Recap
This month we had our first adventure in LiveMeeting presentations. We had the pleasure of listening to Jack Corbett give...
2010-07-12
436 reads
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Before Using AI with Business Data, Read This
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Detecting Deadlocks Quickly
Comments posted to this topic are about the item Detecting Deadlocks Quickly
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers