One Thousand SQL Saturdays (*ish)
This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule, with lots of neat sessions. I’ll be speaking in the am, and am happy to...
2020-10-22
107 reads
Blog Posts
Permissions script for Azure Synapse
I was recently asked to add on to my permissions stored procedures (sp_SrvPermissions, sp_DBPermissions and sp_AzSQLDBPermissions) and create one for ... Continue reading
2020-10-22 (first published: 2020-10-15)
268 reads
Pre-Conference Workshop and Sessions at PASS Summit
I’m pleased to announce that I will be presenting at PASS Summit. This year I have a pre-conference workshop and a regular session. Let’s dive into each. Pre-Conference Workshop:...
2020-10-22
25 reads
Pre-Conference Workshop and Sessions at PASS Summit
I’m pleased to announce that I will be presenting at PASS Summit. This year I have a pre-conference workshop and a regular session. Let’s dive into each.
Pre-Conference Workshop: The...
2020-10-22
6 reads
SQL Virtual Machines
I was recently watching the first session of the Azure SQL Bootcamp by Anna Hoffman (twitter) and Bob Ward (blog|twitter) ... Continue reading
2020-10-22
178 reads
Writing Output from Powershell
One of the things we often want to do when building a PoSh script is to get some output. I first learned about Write-Host, but I learned over time...
2020-10-22 (first published: 2020-10-14)
573 reads
Copying an Azure SQL Database
Copying an Azure SQL Database is a vital skill when managing cloud databases. Recently, a request was received from the “business”. They wanted to create a copy of an...
2020-10-21 (first published: 2020-10-13)
291 reads
Daily Coping 21 Oct 2020
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...
2020-10-21
21 reads
How to Import Perfmon Data into a SQL Server for Analysis
If you followed the last video, I showed you how to set up windows perfmon for ongoing performance metric collection on all of your critical SQL Server machines. However,...
2020-10-21
120 reads
Shell to Script Shortcut
I’ve been meaning to write something this post for a while but the stars have aligned this week. Garry Bargsley (blog | twitter) published a post about making a...
2020-10-21
5 reads
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
We Are Eating Our Own Seed Corn
Comments posted to this topic are about the item We Are Eating Our Own...
Before Using AI with Business Data, Read This
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers