Using Bookmarks to navigate code in SSMS (Day 24)
Bookmarks are used in SSMS to have SSMS remember selected line positions, and to quickly move between the bookmarks. All...
2018-01-24
360 reads
tSQLt tests for Day 5 Advent of Code 2017
This is day 5 of the Advent of Code 2017. If you want to read about the puzzles, start with...
2018-01-24
813 reads
Speaking at SQLBits next month
As I mentioned a couple of weeks ago, I will be presenting for the first time at SQLBits in London,...
2018-01-24
332 reads
Creating a SQL Server Test Lab On Your Workstation – Part Three, Creating a Windows Failover Cluster and a SQL Server Availability Group
Welcome along to the third part of our series ‘Creating a SQL Server Test Lab On Your Workstation’. If you’ve...
2018-02-02 (first published: 2018-01-24)
2,222 reads
SQL Server User Already Exists – Back to Basics
One of my all-time favorite things in SQL Server is security. No matter what, it always seems that there is a new way to abuse permissions. When people abuse...
2018-01-24
26 reads
SQL Server User Already Exists – Back to Basics
One of my all-time favorite things in SQL Server is security. No matter what, it always seems that there is...
2018-01-24
531 reads
Help it takes forever to open the SQL Server Log!
Just to be very clear, I’m talking about the SQL Server Log, not database logs. Sometimes this is called the...
2018-01-24
443 reads
Maintaining Balance
Last week, I got the chance to give my I’m It Survival Tips for the Lone DBA in a webcast for the first...
2018-02-09 (first published: 2018-01-24)
1,650 reads
Know How to Recover SQL Server Database Without Backup
Microsoft SQL Server has widely used database management system for storing and retrieving data. It stores its files in MDF,...
2018-01-24
597 reads
Configuring Persistent Storage for SQL Server in Azure Container Services
I’ve been playing around with SQL Server running in Kubernetes in Azure Container Services (AKS) for a while now and...
2018-02-01 (first published: 2018-01-24)
1,468 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