Where is that Mask?
In this article, I share one easy script that could help eliminate one database feature as a culprit to an anomalous data masking suddenly getting enabled.
Related Posts:
Failed to Create...
2019-12-28
2 reads
Blog Posts
Easy Audit Index Changes
When looking for an easy method to audit Index changes, one of the first technologies to try really should be Extended Events (xevents).
Related Posts:
Monitor Database Offline Events November 15,...
2019-12-27
Free SQL Server Training Videos
Hello everyone! This is your SQL Server Consultant in Austin, TX and due to some posts on twitter about SQL PASS recordings costing $999 I wanted to share some...
2019-12-27
3 reads
Free SQL Server Training Videos
Hello everyone! This is your SQL Server Consultant in Austin, TX and due to some posts on twitter about SQL PASS recordings costing $999 I wanted to share some...
2019-12-27
134 reads
I’m Speaking at #SQLSatCleveland
I am so excited and honored to have been selected to speak at SQL Saturday Cleveland #930 on February 1, 2020. This will be my second time speaking at...
2019-12-27
13 reads
Merry Christmas
Christmas was this week so nothing technical today, just a simple blog post wishing you and your family blessings and good tidings during this holiday time. May the holidays...
2019-12-27
54 reads
Resolving Merge Conflicts in SQL Source Control – the Basics (video)
In this 35 minute livestream recording, I commit conflicting code to a Git repo in Azure DevOps Services using Redgate’s SQL Source Control, then step through options to fix...
2019-12-27
23 reads
SQLSaturday Tampa 2020 (On Leap Day!)
Feb 29, 2020 is the date for SQLSaturday Tampa, number 951. The call for speakers is open through January 10th, so you don’t have much time to get something...
2019-12-27
52 reads
T-SQL Tuesday 121 – Gifts received – Summary
I got several responses for the last T-SQL Tuesday of the year that am honored to host. My topic was to blog on whatever you considered to be a...
2019-12-27 (first published: 2019-12-12)
312 reads
Understanding Azure Geo-Redundant Storage
While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery Strategies for the Data Platform. In that session, I talked about Azure storage and the...
2019-12-27 (first published: 2019-12-13)
305 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Free Online Sessions – Building the €100 DWH and Indexing for Dummies
I’m giving two online sessions soon on virtual events that are free to attend....
Forums
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Tables with a SPARSE Column and Consumption
Comments posted to this topic are about the item Tables with a SPARSE Column...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers