Power Bi, PowerShell and SQL Agent Jobs
Continuing my series on using Power Bi with my DBA Database I am going to show in this post how...
2015-10-01 (first published: 2015-09-28)
4,296 reads
Continuing my series on using Power Bi with my DBA Database I am going to show in this post how...
2015-10-01 (first published: 2015-09-28)
4,296 reads
Following my post about using Power Bi with my DBA Database I have been asked if I would share the...
2015-09-22
872 reads
Following my last post about using Power Bi with my DBA Database I have been asked if I would share...
2015-09-09 (first published: 2015-08-31)
2,505 reads
This months TSQL2sDay blog post party is hosted by Jen McCown and is about Enterprise Strategy.
Adam Mechanic started TSQL Tuesdays...
2015-09-08
606 reads
Following my post about using Power Bi with my DBA Database I have been asked if I would share the...
2015-09-07
933 reads
A quick post today just to add some weight to something that Mike Fal b | t has kicked off. The #SQLHelp...
2015-09-06
511 reads
Every good DBA should have a DBA database. A place to store information about all of their instances and databases.
I...
2015-08-21 (first published: 2015-08-16)
4,354 reads
This weekend I was creating some Azure VMs to test and was required to use the GUI for some screenshots....
2015-07-24
1,516 reads
First I must say thank you to all of the wonderful people who have put time and effort into providing...
2015-06-16 (first published: 2015-06-08)
1,766 reads
If you are a SQL Server DBA you should know about Ola Hallengren and will probably have investigated his Maintenance...
2015-05-20 (first published: 2015-05-06)
5,904 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