Azure SQL Managed Instance – Premium Tier
In case you are not aware Microsoft have now deployed a new change to SQL Managed Instances within the tier types. In certain regions ( shown later) you can...
2021-11-10
144 reads
Blog Posts
Daily Coping 10 Nov 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-11-10
11 reads
Error [IM002] [Microsoft][ODBC Driver Manager] "Data source name not found and no default driver specified" and who do you trust?
(2021-Oct-31) A very short blog post, just a reminder to myself, but if you have ever tried to connect to a PostgreSQL database using ODBC interface (I know, it already...
2021-11-10 (first published: 2021-11-01)
9,645 reads
Notes on SQLSaturday Orlando 2021
We held an in-person SQLSaturday here in Orlando last weekend (Oct 30th). We didn’t organize one last year, there was just too much risk and too much uncertainty, so...
2021-11-10
62 reads
PASS Data Community Summit 2021
A collection of the resources mentioned in my PASS Data Community Summit session Backup Basics with PowerShell and dbatools, including bonus content!
2021-11-10
12 reads
PASS Data Community Summit 2021 Presentation Resources
A collection of links and resources related to my PASS Data Community Summit 2021 presentation Backup Basics with PowerShell and dbatools including bonus content! Resources dbatools main site dbatools...
2021-11-10
11 reads
SQL Saturday at the Summit
At the PASS Data Community Summit today, I’ll be in the Community Zone to talk about SQL Saturday and answer questions from people. I have a few other times...
2021-11-10
29 reads
Table Valued Parameters and Dapper in .NET Core
A customer I’ve been working with for a while now has a monolithic ASP.NET MVC web application which we are porting to .NET Core 3.1 (and then almost immediately...
2021-11-10
1,290 reads
Understanding The Basics of SQL Server Security
Confusing
As I’ve worked with folks using other database engines, I’ve realized that Microsoft SQL Server has some terminology and handling that is a bit confusing.
Here’s my attempt to clarify...
2021-11-10 (first published: 2021-06-24)
459 reads
#PowershellBasics: The WHERE clause
Sometimes when you are trying to figure something out you run across something really interesting. In this case I discovered ... Continue reading
2021-11-09
16 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
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...
Detecting Deadlocks Quickly
Comments posted to this topic are about the item Detecting Deadlocks Quickly
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