2021-05-26 (first published: 2021-04-30)
8,796 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,302 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
2,171 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,821 reads
Blogs
Monday Monitor Tips: Searching Procedures
By Steve Jones
A customer was asking about how to track all the stored procedures that execute...
Advice I Like: Naps
By Steve Jones
Learn how to take a 20-minute power nap without embarassment. – from Excellent Advice...
Forums
The Next Great Thing
Comments posted to this topic are about the item The Next Great Thing
Building a Database Dashboard with SSRS
Comments posted to this topic are about the item Building a Database Dashboard with...
Enabling Change Tracking
Comments posted to this topic are about the item Enabling Change Tracking
Question of the Day
Enabling Change Tracking
If I want to set up Change Tracking in a database, what should I do first in SQL Server 2022?
See possible answers