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,378 reads
Simon Facer
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)
51,718 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,833 reads
2008-06-19
9,235 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,571 reads
Blogs
Our SQL Server 2019 Administration Inside Out Fun Author Survey
By Will Assaf
SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...
What's New in SQL 2019? at the Data Architecture Virtual User Group and Q&A followup
By Will Assaf
Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...
My home office setup
That aging hippie (he likes Apple products and has a goatee) known as Brent...
Forums
Trigger for only updating specific column
Hi, using Merge I can sync table A with Table B at ROW level....
SQL Server Licencing Question
This question is about SQL Server Licencing and licencing for Maximum Virtualisation. I'm curious...
Error converting data type varchar to float
All, I know this topic has been discussed numerous times and I tried all...
Ask SSC