Database Corruption and IO Errors
A quick way to have your day turned upside down and rip your gut out with nerves and anxiety is...
2018-01-18
1,009 reads
Pester 4.2.0 has a Because…… because :-)
I was going through my demo for the South Coast User Group meeting tonight and decided to add some details...
2018-01-18
385 reads
Jack of ALL Trades
Warning: If during reading this post, you feel like a lot of bells started ringing – I might have written about...
2018-01-18
418 reads
All Scripts Now On Github
@adedba Adrian Buckman has been working hard and has put all of our scripts up on Github https://github.com/SQLUndercover/UndercoverToolbox
2018-01-18
371 reads
Add color to connections (Day 17)
Have you ever wished for a visual indicator that you are connected to a production instance of SQL Server? Well,...
2018-01-17
151 reads
Add color to connections (Day 17)
Have you ever wished for a visual indicator that you are connected to a production instance of SQL Server? Well,...
2018-01-17
386 reads
SQL Server 2017 DMVs and DMFs for DBAs
Dynamic management views (DMVs) and dynamic management functions (DMFs) are system views and system functions that return metadata of the system...
2018-01-17
894 reads
Secure or fast? Secure, obviously …
By now you have probably seen the news about a major flaw in the design of CPUs from all major...
2018-01-17
338 reads
How to read a technical blog
There are thousands, tens of thousands, probably hundreds of thousands of blogs out there on all sorts of topics. If...
2018-01-17
311 reads
How to get started with Always Encrypted for Beginners Part 3: One Two Punch
A few weeks ago, I wrote Part 1 and 2 of this series, which was a beginner’s guide to Always...
2018-01-17
785 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