How to Run DBCC CHECKDB to Check SQL Database Integrity
Database Console Command CHECKDB (DBCC CHECKDB)is used to check the integrity (physical & logical) of objects in a SQL Server database.The...
2018-01-17
62,626 reads
Using Windows stored credentials to connect to SQL in containers
I work with SQL Server in containers pretty much exclusively when testing code and one of my real bug bears...
2018-01-17
1,113 reads
SSMS Line Numbers
I typically don’t turn on line numbers if SSMS, but while working with someone on a bit of code, they...
2018-01-16
23,100 reads
Assign a keyboard shortcut to menu items (Day 16)
You may have noticed that there are many menu commands that don’t have a keyboard shortcut. For instance, SQLCMD mode...
2018-01-16
120 reads
Assign a keyboard shortcut to menu items (Day 16)
You may have noticed that there are many menu commands that don’t have a keyboard shortcut. For instance, SQLCMD mode...
2018-01-16
368 reads
Finding the Titles in R
PASS has released the videos to members from this past Summit. I say TJay Belt today ask about relating a...
2018-01-16
573 reads
Deploy Dacpacs with dbatools – The Script!
Hello!
Not so long ago, I wrote about how dbatools now has functions that can be used to deploy dacpacs. What...
2018-01-16
335 reads
Updated YouTube Channel
Hello all,
I’ve recently updated my YouTube channel. I’m going to be posting a lot more videos up there. If you...
2018-01-16
325 reads
Azure Portal – Bad Request
I had a strange issue recently when trying to login to the Azure Portal. Quite simply I would enter my...
2018-01-16
271 reads
Checking the Health of your CLR
Having a tool to be able to monitor CLR health will be essential as you deploy more and more managed code within SQL Server. Extended Events offers a great...
2018-01-16
28 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