2014-11-19 (first published: 2014-10-29)
1,133 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,745 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,694 reads
2014-11-11 (first published: 2014-07-25)
2,628 reads
2014-11-10 (first published: 2014-10-01)
1,348 reads
2014-11-06 (first published: 2014-09-02)
2,472 reads
2014-11-04 (first published: 2014-10-06)
1,363 reads
2014-10-29
1,177 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)
217 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,325 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
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...
SQL Art, Part 2: New Year Fireworks in SSMS
Comments posted to this topic are about the item SQL Art, Part 2: New...
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