Script DB Level Permissions v4.6
Script database and object level permissions for all database users
2022-01-12 (first published: 2021-06-11)
18,172 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)
14,831 reads
2015-08-06 (first published: 2010-11-02)
26,794 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
8,471 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
5,593 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,680 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,486 reads
Multi-Script, Multi-DB Deployments
A way to handle application releases involving multiple scripts and/or multiple databases.
2010-08-23
6,732 reads
Blogs
Measuring What Matters: Operationalizing Data Trust for CDOs
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
A Small LLM Fail
By Steve Jones
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...
SQL Server Versions: Out With the Old, In With the Supported
By Kevin3NF
If your production SQL Servers are still running 2016 (or older) you’re basically banking...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Can Flyway work with GitHub Self-Hosted Runners?
I work on the CI/CD team. We're considering different applications for helping us with...
SSIS packages failing with a status "ended unexpectedly" (SSL/TLS timeout ?)
We have an issue where SSIS packages are failing with a status of "ended...
Question of the Day
Slip Streaming Installs
What does a slipstream installation mean?
See possible answers