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
14 reads
Blog Posts
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
11 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
19 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)
860 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
26 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
4 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)
781 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
9 reads
2021-07-18
19 reads
Where Can I Manage Spatial Data in Azure?
[read this post on Mr. Fox SQL blog] Every now and then you come across a use-case where you need to do something with spatial data, and you need...
2021-07-18
42 reads
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers