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,505 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)
15,066 reads
2015-08-06 (first published: 2010-11-02)
26,928 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,492 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,608 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,687 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,496 reads
Multi-Script, Multi-DB Deployments
A way to handle application releases involving multiple scripts and/or multiple databases.
2010-08-23
6,750 reads
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers