SQL Saturday #29 Presentations & Twittering
Tomorrow, I’m presenting a couple of sessions at SQLSaturday #29 in Birmingham, Alabama. Here are the presentation materials I’ll use.
SQL...
2010-03-26
562 reads
Cross Apply Ambiguity
Cross apply (and outer apply) are a very welcome addition to the TSQL language. However, today after a few hours...
2010-03-26
1,938 reads
SQL Saturday - Columbia
I've talked about trying to do a SQL Saturday event in Columbia, SC, for the last couple of years, ever...
2010-03-26
682 reads
Learning About Microsoft Certified Master: SQL Server
Among the Microsoft certifications, the Microsoft Certified Master is the apex of all of them except maybe the Microsoft Certified...
2010-03-26
1,678 reads
Book Review: Titan The Life of John D. Rockefeller, Sr.
I read Titan: The Life of John D. Rockefeller, Sr. ($13 @ Amazon) as one of the books recommended to me...
2010-03-26
872 reads
Certification
There seems to be quite a flurry of talk these days about certification. There is evidence of it in the...
2010-03-26
1,273 reads
Indexed Views
Views are used quite often within SQL Server for a number of reasons. They can be used to restrict access...
2010-03-26
472 reads
Simple Series : SSIS Conditional Split
Conditional Split is a very powerful component, enabling you to send records in different directions or exclude them from the downstream...
2010-03-26
918 reads
Powerscripting Podcast 2
I was interviewed by Jon (@JonWaltz) and Hal (@Halr9000) in episode 106 of the PowerScripting Podcast. This was my second...
2010-03-25
1,935 reads
Red Gate and Hyperbac
Imagine my surprise when I arrived at the Red Gate offices Monday morning to find Jeff Aven at the office....
2010-03-25
2,579 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers