Status Column in SSISDB Catalog Database
I occasionally review the search terms people use to get to this blog and secretly celebrate knowing my post helped...
2012-06-19
1,229 reads
Speaking at PASS Summit 2012
Today I’m thrilled and humbled to announce that I will be speaking 3 times at PASS Summit in November 6-9! ...
2012-06-19
1,003 reads
SQL Server 2012 RTM Cumulative Update 2
Last night, Microsoft released SQL Server 2012 RTM Cumulative Update 2, which is Build 11.0.2325.0. It has 37 fixes in...
2012-06-19
1,792 reads
Jacksonville IT Pro Camp 2012 Presentation
Presentation and scripts from my Integrating SQL Server PBM with SCOM session at Jacksonville IT Pro Camp 2012.
2012-06-19
1,175 reads
Simply NomCom
So there seems to be some confusion as to what the NomCom’s job is. I have to admit I was...
2012-06-18
611 reads
MAXDOP and Cost Threshold for Parallelism – an example for a parallel query
The most popular post on this blog ranked by hits is one about the CXACKET wait stat. There are no...
2012-06-18
2,409 reads
File Extensions for SQL Server Database Files
I was reading an article over the weekend where the author pointed out that the standard naming convention for SQL...
2012-06-18
1,658 reads
The Side Effect of NOLOCK
Have you ever been told that you should use NOLOCK? I have, and its usually been with OLTP systems where...
2012-06-18
1,988 reads
Tabular query modes: DirectQuery vs In-Memory
When using the Tabular model in SSAS, the deployment options screen offers four choices for “Query Mode”: DirectQuery, DirectQuery with...
2012-06-18
13,925 reads
Determine Index Fragmentation in a SQL Server Database
Index fragmentation can adversely affect query response time. When accessing data through an index, SQL Server must read each page...
2012-06-18
9,153 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
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
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers