2021-05-26 (first published: 2021-04-30)
8,600 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,276 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,084 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,677 reads
Blogs
T-SQL Tuesday #184–Mentoring
By Steve Jones
This month’s T-SQL Tuesday blog party is hosted by Deborah Melkin, and it’s a...
T-SQL Tuesday 184 - Mentorship
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
March 2025 SQL Challenge: Test Your Skills with Advanced SQL Scenarios
If you’re an experienced SQL user eager to sharpen your expertise with real-world challenges,...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
SSIS Execute Process Task forfiles not working
I'm trying to use forfiles in an Execute Process Task in my SSIS package...
Display Data
Hi I want below data to appear like below using query CREATE TABLE [dbo].[Test](...
Question of the Day
Partial Backups II
What is a partial backup for a read-write database?
See possible answers