2014-11-19 (first published: 2014-10-29)
1,137 reads
Scripts
Upload Backup Files to Amazon S3
This script will upload the latest backup files to an AWS S3 bucket
2014-11-14 (first published: 2014-09-14)
1,758 reads
Report on existing user connections
List user connections and possibly any linked server connections older than 1 hour
2014-11-13 (first published: 2014-10-22)
1,697 reads
2014-11-11 (first published: 2014-07-25)
2,657 reads
2014-11-10 (first published: 2014-10-01)
1,357 reads
2014-11-06 (first published: 2014-09-02)
2,483 reads
2014-11-04 (first published: 2014-10-06)
1,373 reads
2014-10-29
1,184 reads
Add all users to user databaes as readonly
I am new to writing scripts so dont blast be to bad. This is a script to make all logins of a sql server readonly users to all user databases. Mainly after a restore from a different server. (for reporting maybe) Any methods to optimize this script are fine.
2014-10-27 (first published: 2004-04-14)
220 reads
After Restoring MSDB perform the following two steps
This script has two essential Steps after restoring MSDB
2014-10-27 (first published: 2010-09-20)
2,337 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Backup Availability Group
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers