Misc Links for Aug 29,2012
Sword fighting. A friend sent me this, debunks the movie view we have of sword fighting. I can’t say I...
2012-08-29
1,630 reads
SQL Audit 302 – Deploying the Audit Solution with Powershell
This is it, ladies and gentlemen. One last post and I promise I won’t mention the word audit for at...
2012-08-29
2,648 reads
Free Second Shot offer for Microsoft Certification Exams
Nothing for me to really say except if you mess up, you get a free second chance Click HERE to see...
2012-08-29
1,141 reads
September 2012 Speaking Events
September is another busy month of speaking events for me and I thought I’d share them with you so maybe...
2012-08-29
1,731 reads
SQL in the City – FREE Training
Is SQL in the City coming to a town near you? The events are being held in New York, Austin,...
2012-08-29
1,415 reads
Upcoming Speaking Events
I will be the inaugural speaker for the Northern Colorado Database Professionals on September 17, in Loveland, CO. I will...
2012-08-28
2,037 reads
Suppressing namespace attributes in nested select statements when using FOR XML workaround
I was helping out on the forums the other day with a user who had stumbled across the quirk of...
2012-08-28
6,882 reads
Lookup transformation in SSIS: Performance Improvements
There are 2 suggestions I hear about when performance tuning the Lookup transformation on a large dimension table when getting...
2012-08-28
9,144 reads
Parallel Data Warehouse (PDW) How-To: Check Database Size with DBCC_pdw_showspaceused
There is a way to view the size of a particular PDW database using the DBCC_pdw_showspaceused command via the NEXUS...
2012-08-28
3,399 reads
These People Are Exceptional
I should know. I was one of the judges of this year’s Exceptional DBA of the Year award. I had...
2012-08-28
1,011 reads
Blogs
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...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
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...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers