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,724 reads
Scripts
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,687 reads
2014-11-11 (first published: 2014-07-25)
2,466 reads
2014-11-10 (first published: 2014-10-01)
1,329 reads
2014-11-06 (first published: 2014-09-02)
2,420 reads
2014-11-04 (first published: 2014-10-06)
1,313 reads
2014-10-29
1,169 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)
212 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,297 reads
Retrieve instance-wide index level fill factor information
This script retrieves all fill factor information for all indexes (clustered and non) when it is not set to 0 or 100
2014-10-24 (first published: 2014-10-14)
618 reads
Blogs
When is the perfect moment to build a data strategy in a company?
The post When is the perfect moment to build a data strategy in a...
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
Forums
Rebuild Index Job on a Large DB
We have a db close to 3 tb and rebuilding/ reorganizing indexes weekly is...
Authentication Error 0x8009030c
Hi, I'm using a small database on SQL Server 2019 on Windows 10 Pro....
how to stop command prompt window from appearing when running PowerShell script?
Hi everyone I have a PowerShell script that is run by Execute Process Task...
Question of the Day
Renaming a Database
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers