Daily Coping 20 Jul 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-07-20
14 reads
Blog Posts
Experiment: If I have Dynamic Data Masking enabled will BCP pull the non masked data.
Hypothesis: If I have Dynamic Data Masking enabled on a column then when I use something like BCP to pull ... Continue reading
2021-07-20
27 reads
Microsoft Data Platform Continuity VG Presentation – July 2021
I’m pleased to announce that this month’s presentation for the Microsoft Data Platform Continuity Virtual Group will be on July 29th at 2pm Eastern time. This presentation from Edwin...
2021-07-20
12 reads
WordPress.com Managed Hosting Webinar with Rudy Faile, Automattic Systems
Learn how WordPress.com's managed hosting powers fast, secure websites.
2021-07-20
22 reads
Add DBCC INPUTBUFFER to Your Performance Tuning Toolbox
A command I like to use when performance tuning is DBCC INPUTBUFFER. If you have ever run sp_whoisactive or sp_who2 to find out what sessions are executing when CPU...
2021-07-19 (first published: 2021-07-07)
862 reads
Daily Coping 19 Jul 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-07-19
28 reads
Filtering Extended Events Using Actions
Did you know, you can use Actions to Filter Extended Events? Well, you can. Filtering is one of the greatest ways in which Extended Events differentiates itself from other...
2021-07-19
6 reads
How to Fix SQL Database Error 8961?
Running DBCC CHECKDB or DBCC CHECKTABLE on a database may report error 8961. Such a situation could occur while changing the data type of a table column from “ntext...
2021-07-19 (first published: 2021-07-08)
787 reads
SQLSaturday Orlando 2021
We’ve opened up registration and the call for speakers for SQLSaturday Orlando, to be held October 30th at the Orlando Marriott Lake Mary. In-person! We weren’t able to get...
2021-07-19
10 reads
2021-07-18
21 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers