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
11 reads
Blog Posts
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
10 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
28 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,289 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)
458 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
13 reads
Daily Coping 9 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-09
10 reads
T-SQL Tuesday #144–Data Governance
This month’s topic is something I wouldn’t have considered a decade ago. Especially in the US, this isn’t something that I’d actually have cared about for most of my...
2021-11-09
90 reads
Daily Coping 8 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-08
11 reads
Log Analytics with Azure Synapse Analytics
There are a lot of services in Azure. Way more than a few. What is something you want to do with all your services and applications? You want to...
2021-11-08 (first published: 2021-11-01)
1,925 reads
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers