SQL 2005 Restore Script Generator
This script will generate a restore statement with supporting MOVE operations to a new directory structure.
2011-12-13 (first published: 2008-05-29)
3,870 reads
- Interests: Anything with two wheels and a motor.
Delete files older than n-days via T-SQL
Delete files on a fileshare leaving behind files not older than n-days.
2011-09-13 (first published: 2008-04-02)
8,641 reads
Powershell/SMO: Unload table schema, dri, perms & data.
PSH script to unload table schema, dri, permissions and data to file(s).
2008-06-10 (first published: 2008-05-07)
1,071 reads
Blogs
Errata for my book: Pro Encryption in SQL Server 2022
My biggest fear when my book went into production was that any factual errors...
SQL Server Quickie #45 – SQL Server Availability Groups
Today I have uploaded SQL Server Quickie #45 to YouTube. This time I’m talking...
Daily Coping 21 Mar 2023
By Steve Jones
Today’s coping tip is to listen to a piece of music without doing anything...
Forums
Is It Risky To Jump Starting A Car With The Dead Battery?
What could be the most surprising fact for you in the morning? It is...
Fixing a mismatched collation on MSDB
Hi, I've been tasked with finding out why we've been unable to patch the...
How to download from a dynamic link using SSIS?
Hi everyone, So I have a ssis package in which I download a excel...
Ask SSC