How to Troubleshoot Waiting Tasks Without Requests in SQL Server?
Usually, when I need to troubleshoot currently running requests, I use a combination of sys.dm_exec_requests and sys.dm_os_waiting_tasks. The former retrieves...
2018-02-01
514 reads
Controlling what appears in the status bar and query tabs (Day 32)
When you run a query in SSMS, you are probably aware that the status bar contains many pieces of information...
2018-02-01
540 reads
Summit 2018 Program Survey
PASS has a survey out asking for your thoughts on the 2018 content. Take a few minutes and fill it...
2018-02-01
451 reads
Multiple disk controllers in VMs can mean improved performance
I recently had a great question on some of the differences in virtual machine disk presentation from one of our...
2018-02-01
1,277 reads
gdpr - panic part 1
GDPR is coming (or if you are reading this in a few weeks then gdpr is here, what do you...
2018-02-01
342 reads
gdpr - panic part 1
GDPR is coming (or if you are reading this in a few weeks then gdpr is here, what do you need to know and where do you start?
This post...
2018-02-01
15 reads
gdpr - panic part 1
GDPR is coming (or if you are reading this in a few weeks then gdpr is here, what do you...
2018-02-01
16 reads
gdpr - panic part 1
GDPR is coming (or if you are reading this in a few weeks then gdpr is here, what do you...
2018-02-01
66 reads
gdpr - panic part 1
GDPR is coming (or if you are reading this in a few weeks then gdpr is here, what do you...
2018-02-01
76 reads
Undercover TV – We’ve got a YouTube channel!
We’ve now got ourselves a shiny new YouTube channel at UndercoverTV.
We’ll be using this to host our monthly podcasts as well...
2018-02-01
398 reads
Blogs
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....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
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