Script DB Level Permissions v4.5
Script database and object level permissions for all database users
2019-07-03 (first published: 2019-06-10)
1,122 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)
3,571 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
6,253 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,460 reads
2014-01-24 (first published: 2010-11-02)
13,597 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,132 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,364 reads
Multi-Script, Multi-DB Deployments
A way to handle application releases involving multiple scripts and/or multiple databases.
2010-08-23
5,979 reads
Blogs
Using Google Chrome with SSRS
In this post, you will learn how to resolve the Kerberos Double-Hop issue and...
Friend of Redgate 2020
By Chris Yates
Last week I was excited to receive an email from Redgate notifying me that...
Azure Database for PostgreSQL
By Arun Sirpal
Having worked with Azure SQL Database and its many flavours for couple of years...
Forums
Question on restoring a backup
Hi, I am not that knowledgable on backups and the files that they create,...
Regular Expression help - Does (.) Mean new line?
Hi there I am re-writing some code which uses regular expressions Part of...
SQL AG Secondary Database Backup Throwing "not supported" error with COPY_ONLY
Hello. I am using SQL Server 2016 with 2 Node AG. There is no...
Ask SSC