Script DB Level Permissions v4.5
Script database and object level permissions for all database users
2019-07-03 (first published: 2019-06-10)
651 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)
2,423 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
5,860 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
3,227 reads
2014-01-24 (first published: 2010-11-02)
11,141 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,064 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,357 reads
Multi-Script, Multi-DB Deployments
A way to handle application releases involving multiple scripts and/or multiple databases.
2010-08-23
5,930 reads
Blogs
Why do DBAs dislike loops?
If you started out as a developer you were probably taught how important loops...
Public and Demo Data Coming Soon!
Any database professional that has been around the Microsoft world for more than about...
New Centralized View of SQL Resources in Azure
Yesterday, some new views were made available in the Azure portal that will be...
Forums
Upgrade to SQL Server 2008 R2 SP2 from SQL Server 2005 SP3
Hello, I noticed that SQL Server 2005 SP3 is not in the in the...
Can't drop database in "restoring" state from secondary instance of AG
MSSQL version: 2016 (13.0.5026.0) Situation: Removed a database from an availability group so it...
ReportServer Database upgrade fails
I've tried several times to successfully migrate a SQL Server 2008R2 ReportServer and ReportServerTempDB...
Ask SSC