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,873 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)
9,018 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,082 reads
Blogs
Introduction to SQL Server Query Store
Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and...
Flyway with Multiple Folders
By Steve Jones
A customer asked about how they could organize their migration scripts in different ways...
Migrating from EverNote to Joplin
By Steve Jones
Recently I got a message that my Evernote subscription was going up. It’s been...
Forums
Database copy issue through - COPY DB WIZARD
I have a production server with SQL server 2016 version (13.0.5026.0) and a database...
Help with a SQL Unpivot
I am trying to use unpivot to extract some data, however, the results are...
how to de escalte a isolation level, and are there any implications.
hi, I have one nested transaction and want to deescalate to outer transaction's isolation/...
Ask SSC