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,428 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)
55,397 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,916 reads
2008-06-19
9,521 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,608 reads
Blogs
Derby City Data Days
By DataOnWheels
It was awesome to see the Kentucky data community come out for the first...
Tomorrow: Webcast on SQL Server security
By Brian Kelley
Tomorrow, April 16, 2024, I will be giving another webcast; this one will be...
A New Word: the Wends
By Steve Jones
the wends– n. the frustration that you’re not enjoying an experience as much as...
Forums
Should I create tables with dynamic SQL?
Hello all, I am thinking of creating a "shopping cart" in our application. My...
Expression Error ( property 'Error' cannot be selected )
Hello there. I have the following Pipeline I want to get the property error...
create cluster fails Win2016.
I'm installing a cluster prior to my 2019 SQL build. Failover Cluster tools...
Question of the Day
Express In-Memory OLTP
Can I create In-Memory OLTP tables in SQL Server Express?
See possible answers