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,849 reads
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)
7,982 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)
982 reads
Blogs
Simple-Talk Article…Understanding Azure Storage Options
Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...
T-SQL Tuesday #120 – Recap
The wrap up post for T-SQL Tuesday #120. 9 bloggers contributed this month. The post...
Setting Certificate Backup Permissions for an Instance–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Union with temp table
insert into dbo.details ( DetailId ,DetailName ) select distinct st.stdid ,st.name from dbo.student st...
need help with a query to avoid while loop
i am struggling with a query to avoid while loop, please guide me if...
Ask SSC