2021-05-26 (first published: 2021-04-30)
1,059 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
5,239 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
677 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
4,474 reads
Blogs
Using SQL Compare for One Procedure
By Steve Jones
A customer recently was concerned about the time to run SQL Compare for a...
Daily Coping 11 June 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Azure SQL Database – Secondary Database and Tiers
By Arun Sirpal
On the theme of failover groups let’s do a quick recap on my environment....
Forums
Tracking, Privacy, and Lots of Data
Comments posted to this topic are about the item Tracking, Privacy, and Lots of...
CU 24 patching issue.
We are having an issue applying CU24 patches on SQL 2017. The version of...
what condition case when related to portion key mean ?
I work on sql server 2012 I don't understand condition below do this condition...
Ask SSC