SQLBits X videos online
All the videos for this popular conference are online or will be soon (69 of them). Take a look at the...
2012-06-20
1,132 reads
SQL Server 2012 CU2 – Have a little fun (#AppliedSQL)
SQL Server 2012 Cumulative Update (CU) 2 is out! If you’re like Me-from-10-years-ago, you couldn’t care less!
But there are actually...
2012-06-20
1,294 reads
Bug? Can’t Pass TVP to SQL Function Twice
I run into a bug recently with SQL Server 2012. I believe this exists in SQL Server 2008 as well....
2012-06-20
1,106 reads
Contracting – Your best clients are your current clients…
and your old clients too.
Before I started my contracting business five years ago I realised the importance of selling and...
2012-06-20
840 reads
Corrupt Model database
An interesting case arose at work the other day. SAN issues had caused SQL Server to shutdown and it was...
2012-06-20
763 reads
Enumerating Index Fragmentation with Powershell and SMO
I wish I could say that this was a simple task, but as I dove into SMO and some of...
2012-06-19
2,753 reads
X-XMLA: iv. Deploying Databases with XMLA
The fourth segment in this series focuses on using XMLA to deploy databases. When you create SQL Server Analysis Services...
2012-06-19
908 reads
Two New Cumulative Updates for SQL Server 2008 R2
Microsoft has released two new Cumulative Updates for SQL Server 2008 R2. The first one is SQL Server 2008 R2...
2012-06-19
1,139 reads
The First Interview: What companies do that make me want to run far, far away
I’ve recently been asked for some clarification about this statement (from my last blog post): “This is EXACTLY the kind...
2012-06-19
776 reads
PASS Summit 2012
I sure hope you’re planning on attending the PASS Summit this year. If you’re not, you might want to reconsider....
2012-06-19
789 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