Join Denny Cherry and Associates at SQL Bits 2023
I am very excited and lucky to be speaking once again at SQLBits along with my DCAC colleagues. SQLBits, the largest Data Platform conference in Europe, held this year...
2023-01-27
83 reads
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
26 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
214 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
27 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
91 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)
773 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
19 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)
233 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)
493 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)
399 reads
Blogs
Speeding Up Patching – Beyond Patch Delivery
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
Monday Monitor Tips: Query Recommendations
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Forums
Azure SQL Hyperscale Unveiled
Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
MiniMax m3 and SQL Server
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers