It’s a great question. Let’s say you want to capture stored procedure completions. But, you only want to capture them between 3AM and 4AM. Can you do it? Output...
2024-07-19 (first published: 2024-07-01)
226 reads
Hey all! Quick one here. Tracy Boggiano, awesome person that she is, has put together an interesting collection of data over on GitHub. It’s titled DBA Resources, but it...
2024-07-12 (first published: 2024-06-27)
233 reads
There are quite a few different ways that you’re likely to see windows functions evidence themselves within your execution plan. Let’s take a look at one example. Windows Function...
2024-07-10 (first published: 2024-06-24)
296 reads
If you want more of a career and less of a job, one thing you will have to do is learn to use your voice. I mean this on...
2024-07-08
45 reads
I was at a customer this week (sorry, can't share who). I spent the day talking about Redgate Monitor and how it can help with query tuning, server management, and estate management. Through the day, the data pros at the company were sharing how they were managing hundreds of servers and several thousand databases. They […]
2024-06-29
128 reads
There are quite a few different ways that you’re likely to see window functions evidence themselves within your execution plan. Let’s take a look at one example. Window Functions...
2024-06-24
61 reads
As I type this, we’re leaving behind spring, and all the amazing events that take place then, and entering the quiet time of summer. After that, we’ll go into...
2024-06-18
46 reads
Oh good gosh. Six months without a single blog post. Most important information: I’m not dead. Apologies. The issue is pretty simple. I’m getting old. Ha! Seriously though, I...
2024-06-17
51 reads
2024-06-10 (first published: 2020-01-23)
556 reads
I had the opportunity last week to present a session at DataSaturdays Stockholm. I can't say enough nice things about the event and the organizers. I presented on Query Store in SQL Server. In my mind, it's an entry-level to middle tier presentation. Most of the room was already working with Query Store, some quite […]
2024-06-01
137 reads
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item Planning for Change
Comments posted to this topic are about the item Importing Excel files into SQL...
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers