Daily Coping 27 Jan 2023
Today’s coping tip is to try something new to get out of your comfort zone. I did two things here. First, I’ve been participating in a Jan American Cancer...
2023-01-27
20 reads
Things to look out for while TDE is encrypting existing data
Monitoring for Problems The encryption of your existing data occurs as a background process referred to as the encryption scan, but it will consume resources while it runs, so...
2023-01-27
203 reads
Daily Coping 26 Jan 2023
Today’s coping tip is to focus on what’s good, even if today feels tough. Yesterday was a tough day. I got busy, distracted, had some bad news come up,...
2023-01-26
18 reads
Working With Tags in FlashArray using PowerShell
Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and Cloud Block Store. Starting in Purity 6.0, you can assign tags to objects. This post...
2023-01-26
82 reads
Using SQL Data Compare from the Command Line with a Project
SQL Data Compare (SDC) is a great way to sync data among tables. It’s a software utility analogous to SQL Compare, but working with data rather than schema. I...
2023-02-17 (first published: 2023-01-25)
764 reads
Daily Coping 25 Jan 2023
Today’s coping tip is to be gentle with yourself when you make mistakes. I forgot about a commitment. I had agreed to do a webinar and prepare some content....
2023-01-25
10 reads
Allow a user to only trigger pipelines in Azure Data Factory
Typically you have a bunch of pipelines that are started by one or more triggers. Sometimes, a pipeline needs to be manually triggered. For example, when the finance department...
2023-02-08 (first published: 2023-01-25)
225 reads
Recovering data with crash consistent snapshots
When we talk about snapshots of SQL Server there are two types, application consistent snapshots and crash consistent snapshots. Application consistent snapshots require freezing IO on a database allowing...
2023-02-08 (first published: 2023-01-25)
484 reads
Unpivot a matrix with multiple fields on columns in Power Query
I had to do this for a client the other day, and I realized I hadn’t blogged about it. Let’s say you need to include data in a Power...
2023-02-06 (first published: 2023-01-24)
393 reads
Script to Install the Tools I Use on My Jumpbox
I wrote a blog post a few months ago about the tools I use on my jumpbox you can read here. Since then, I have
The post Script to Install...
2023-02-06 (first published: 2023-01-24)
457 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers