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,401 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)
53,210 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,870 reads
2008-06-19
9,414 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,578 reads
Blogs
Daily Coping 5 Aug 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Interview Tip: Know your resume
Seriously. Make a point of reading your resume before submitting it, and again before...
SQL Server on Kubernetes Book Published!
I’m super proud to announce that Ben E. Weissman and I have published SQL...
Forums
BUY UNDETECTABLE COUNTERFEIT MONEY(counterfeitmoney414@gmail.com)
MONEY TEAM BANKNOTES IS THE BEST SELLER OF COUNTERFEIT BANKNOTES . We are the...
cheap hennessy
Are you looking for quality Wine, Champagn,Hennessy or Heineken for your birth day party,wedding,events...
is Forced Parameterization usually more beneficial than less?
On a hybrid server, with ~70% OLTP vs 30% (somewhat heavy) DW workloads, with...
Ask SSC