Query Table Metadata
There will inevitably come a day when you want to take a look at the metadata of the tables inside...
2011-06-23
5,979 reads
Bradley Schacht
SSIS Configurations: When and How
Configurations in SSIS are a lovely tool that when implemented correctly can greatly reduce package maintenance. It is very possible...
2011-06-14
885 reads
SSIS Webinar Recording Is Up
I want to say a huge thank you to everyone who attended the webinar from Pragmatic Works (website) that I...
2011-06-10
689 reads
Free Dynamic SSIS Webinar Today
If you were able to make it out to SQL Saturday in Pensacola this past weekend I want to say...
2011-06-07
640 reads
SQL Saturday Pensacola
I know it has been almost a month since I posted last and this is not really a “real” post,...
2011-06-01
433 reads
SQL Saturday #74 Session Recap
Hopefully if you came to my session this year at SQL Saturday in Jacksonville, FL you came away with some...
2011-05-04
515 reads
Search Stored Procedure Text
There will come a day, if it has not already come and gone, when you will want to search through...
2011-04-26
1,079 reads
A Caution About Checkpoints
Checkpoints in SSIS are a great tool and they definitely have their place. The downside to them is that they...
2011-04-25
1,120 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
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...
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers