Daily Coping 27 Apr 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-04-27
13 reads
Blog Posts
Geek Sync: Meeting Security Benchmarks and Compliance with Microsoft SQL Server
Tomorrow, April 28, 2021, 12 PM EDT, I will be talking about meeting security benchmarks and compliance requirements with Microsoft SQL Server. Here is the registration link: Geek Sync...
2021-04-27
43 reads
Machine Learning – Introduction
Machine Learning : it is a system where system will learn how the pattern is going and accordingly we can predict the future information. There are two types in...
2021-04-27 (first published: 2020-04-26)
443 reads
Modern Data Warehouse explained
I created a short YouTube video (20 minutes) that is a whiteboarding session that describes the five stages (ingest, store, transform, model, visualize) that make up a modern data...
2021-04-27
7 reads
Using Pester to Improve Operational Tasks
Taking the Time To Test
Requirements in a constant state of change set you up for failure.
Failure to work through requirements before starting can also increase the risk of failure.
Planning...
2021-04-27 (first published: 2020-04-20)
792 reads
Checking for SQL Server Updates with dbatools
It turns out I was doing this all wrong for months. For the longest time, I’ve been checking my SQL Server instances to see what needs patching with Test-DbaBuild...
2021-04-26 (first published: 2020-04-28)
955 reads
Daily Coping 26 Apr 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-04-26
10 reads
TIL: Backup-DbaDatabase
(This post comes from one of our Junior DBAs – @SQLDork) I’m learning how to use dbatools. Today’s command: Backup-DbaDatabase I’m using the 64-bit PowerShell ISE (running as administrator),...
2021-04-26 (first published: 2020-04-27)
540 reads
Using Extended Events Live Data With Azure
In my last post I showed some shortcomings of Extended Events, however, it is possible to use Live Data with Azure. Let’s explore exactly how that works. To get...
2021-04-26
30 reads
Changing MaxDop For Resumable Index Create Operations
I’ll admit it, sometimes I’m wrong. Recently I blogged about the usefulness of a newer feature that was enhanced with the release of SQL Server 2019. Resumable Indexes operations...
2021-04-23 (first published: 2020-01-17)
1,305 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers