Script DB Level Permissions v4.6
Script database and object level permissions for all database users
2021-06-21 (first published: 2021-06-11)
3,242 reads
S. Kusen
Script DB Level Permissions v4.3
Script database and object level permissions for all database users
2017-07-25 (first published: 2016-02-26)
7,644 reads
Collect Data from Multiple Instances Using SSIS and Powershell
Use SSIS to pull data from multiple instances. Combine with powershell to run multiple instances simultaneously.
2015-02-23
7,271 reads
Automate Your Central Management Server Registrations
Easily register SQL Servers in your inventory to your CMS for easy multi-server queries.
2014-08-18
4,007 reads
2014-01-24 (first published: 2010-11-02)
18,472 reads
SQL 2008 SP/CU Patching Through Windows Scheduled Tasks
Automate patch installations using the task scheduler and command line hotfix options for SQL.
2011-05-03
4,372 reads
T-Log Backup/Restore with Date & Time
Simple script formatting the date and naming a backup file path for a t-log and restoring those logs.
2010-12-29 (first published: 2010-12-15)
1,383 reads
Multi-Script, Multi-DB Deployments
A way to handle application releases involving multiple scripts and/or multiple databases.
2010-08-23
6,199 reads
Blogs
A New Form of Address: Mx
By Steve Jones
When I was presenting at the dataMinds Connect conference, I called on someone in...
Group By Starting Characters
By Kevin3NF
I was chatting with Jeff (b|t) on my team yesterday and the context escapes...
Daily Coping 22 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Maybe It Is DNS
Comments posted to this topic are about the item Maybe It Is DNS
Finding all logins that can alter DDL
Hello experts, Is there a ready-made query out there that I could run on...
Insert records with a where
I want to insert record job allocations only for selected jobs I know the...
Ask SSC