SQL Server 2012 (“Denali”): Database Recovery Advisor
Database Recovery Advisor is a new feature in SQL Server 2012 that introduces significant user experience enhancements to the ways DBAs...
2012-03-02
1,042 reads
Blog Posts
The Daily Status Meeting
For the past six months or so I’ve hosted a daily status meeting for a large project. It started out...
2012-03-02 (first published: 2012-02-26)
2,017 reads
Want to write for Microsoft?
Edit: The group I’m speaking to is the Content Team, not the Books Online (BOL) team!
Edit: Updated with FAQs and...
2012-03-02
722 reads
A Solid Laser Printer
I bought a Brother 2060 about 5 years ago to serve as our primary printer at the ranch. It was...
2012-03-01
967 reads
Checking Your Service Account with T-SQL
Somehow this slipped by me, but there were some new DMVs added in SQL Server 2008 R2 SP1. I suspect...
2012-03-01 (first published: 2012-02-22)
2,818 reads
Choosing the Right Microsoft Reporting Technology Part 1: Report Services
As Business Intelligence has evolved over the years the number of tools we have to choose from for presenting data...
2012-03-01
1,462 reads
Linked Servers
Do you have linked servers that have been created in your environment? Do you know what these linked servers are? Finding Linked Servers SQL Server has provided us means...
2012-03-01
11 reads
Linked Servers
Do you have linked servers that have been created in your environment? Do you know what these linked servers are?
Finding...
2012-03-01
1,106 reads
March Question: What tool(s) do you use to help you identify and tune slow performing queries?
Tuning poorly performing queries is one of the most important jobs of the DBA. With this in mind, this month’s...
2012-03-01
1,206 reads
Smart Car Charging
I don’t know if electric cars are the answer, but I do think electricity will play a larger part of...
2012-03-01
887 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