2021-05-26 (first published: 2021-04-30)
7,877 reads
Permissions
When one of your DBA colleagues leaves the company, what is your checklist?
A colleague left the company, a couple of days after SQL Server processes start failing...what do you do?
2020-09-29
6,118 reads
Execute on DMVs without user having View Server State
Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]
2020-09-24
1,858 reads
Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules
Being able to get information and save it on a Excel as a report can be a common and tedious task. What if we could join dbatools and ImportExcel PorwerShell modules to accomplish this in a easier and fast way? We will see how to export roles and its' member and save that info on a multi spreadsheet Excel file with handy tables ready to be explored.
2020-06-30
6,138 reads
Blogs
Undercover Catalogue 0.4.4 Released – Database Last Accessed Time and NEW Snapshot Module
Full documentation on the Undercover Catalogue can be found HERE It’s been a while...
Derby City Data Days
By DataOnWheels
It was awesome to see the Kentucky data community come out for the first...
Forums
User permissions and showplan
All, I'm trying to find a way to let some of our users see...
Difference between equal directly and use SUBSTRING
Hello, I have a script that was running really long, and I have found...
Visualisation options as an alternative to SanKey diagram
I am building a report to show customer journeys and their arrears levels. I...
Question of the Day
Express In-Memory OLTP
Can I create In-Memory OLTP tables in SQL Server Express?
See possible answers