Comprehensive Backup Script
These scripts were generated to standardize our SQL backup environments, and to remove backups from Maintenance Plans.
2011-12-22 (first published: 2008-01-29)
3,452 reads
Simon Facer
- Interests: My kids, building furniture, DIY, garden ponds, SQL Server and PDW
Why SHRINKFILE is a very bad thing, and what to do about it.
This article talks about why SHRINKFILE is a very bad thing, and what to do about it if you must shrink a database file.
2011-12-16 (first published: 2010-11-09)
56,240 reads
Proc to Rename a file
A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.
2011-10-28 (first published: 2008-05-13)
2,955 reads
2008-06-19
9,625 reads
Audit SQL Logins
We have auditors in the building, looking at our security (amongst other things). So, we needed an easy way to generate a listing of the SQL logins, and the permissions into each database on our servers (over 70 if them).This script will generate the listings the auditors wanted.
2007-04-02 (first published: 2007-03-07)
5,624 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCU MANGGA DUA RAYA Hub.0853•5504•2311
BCA KCU MANGGA DUA RAYA Hub.0853•5504•2311 Jl. Mangga Dua Raya Jalan Kavling No.1 Blok...
ATM Bank BCA A. Yani, Pekanbaru TLP/WA 08216977749
Jl. Jend. Ahmad Yani No.41 C, Kota Baru, Kec. Pekanbaru Kota, Kota Pekanbaru, Riau...
BCA KCP Kas Arifin Ahmad TLP/WA 08216977749
Komp. Hatta Centre, Jl. Arifin Ahmad Perkantoran Soekarno No.9 Blok D, Sidomulyo Timur, Marpoyan...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers