From the Power BI dashboard to a specific page in a Report
Recently, I was working with a customer designing Power BI reports and dashboards. Everything was going great until she asked...
2016-01-25
2,899 reads
Reusing schedules in SQL Agent
I’m a big fan of automation. You get it written, tested, and scheduled, then you just sit back and monitor...
2016-02-01 (first published: 2016-01-25)
1,517 reads
Public Speaking – The First Time
Update for T-SQL Tuesday #84
Well, this year I was challenged with the goal of speaking publicly three times, well I blew that out of the water and have spoken...
2016-01-25
11 reads
Public Speaking – The First Time
This past week I had the pleasure of speaking for my first time professionally to the Chicago Suburban SQL Server...
2016-01-25
509 reads
Querying Deadlocks From System_Health XEvent
It’s easy to query XEvents to see some of the basic info in deadlocks, including the system_health session which is already capturing this information by default. This script will,...
2016-01-25
113 reads
Querying Deadlocks From System_Health XEvent
It’s easy to query XEvents to see some of the basic info in deadlocks, including the system_health session which is...
2016-01-27 (first published: 2016-01-25)
2,928 reads
Speaking at SQL Saturday #500 in Boston!
I have been selected to speak at SQL Saturday #500 in Boston on March 19th - I will be speaking (at...
2016-01-25
477 reads
Things I learned in 2015
Happy 2016!
I continue my tradition of summarizing the things I learned in the past year (as a reminder, here’s what...
2016-01-25
664 reads
Monday Morning SQL Break – January 18, 2016
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2016-01-25
431 reads
Monday Morning SQL Break – January 11, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-01-25
531 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Planning for Change
Comments posted to this topic are about the item Planning for Change
Importing Excel files into SQL Server, Azure Edition
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
The ##MS_DatabaseConnector## User
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