Script DB Level Permissions v4.6
Script database and object level permissions for all database users
2021-06-21 (first published: 2021-06-11)
2,587 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,140 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,189 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,915 reads
2014-01-24 (first published: 2010-11-02)
17,804 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,334 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,161 reads
Blogs
Container Limits and SQL Server
Limits in Containers Docker gives you the ability to control a container’s access to...
Inspector V2.6 now available
As always the code can be found here in our github repoWe updated our...
Data Mesh: Centralized ownership vs decentralized ownership
By James-Serra
I have done a ton of research lately on Data Mesh (see the excellent...
Forums
Do You Have ALL the YAML?
Comments posted to this topic are about the item Do You Have ALL the...
Why Power Query as an Activity in Azure Data Factory and SSIS?
Comments posted to this topic are about the item Why Power Query as an...
Azure Blob Store Redundancy
Comments posted to this topic are about the item Azure Blob Store Redundancy
Ask SSC