Backup a database
This procedure when executed with the correct parameters, backs up a database in the specified directory pathUsage :exec USP_BACKUPDATABASE databasename, directory_path
2002-03-12
563 reads
Script to export Stored Procedures
This procedure when executed with the correct parameters, exports all stored procedures from a database into different .SQL files in the path specified.Usage :exec USP_PRINT_PROCS username, password, servername, databasename, directory path
2002-03-12
431 reads
Blogs
How I passed the 70-761 certification exam
By DesertDBA
FUN FACT: I have been a Microsoft Certified Professional for SQL Server for over...
Azure Storage tips
By James-Serra
As a followup to my blog post Azure Data Lake Store Gen2 is GA,...
Managing Agent Jobs on Availability Group Servers
As always, the scripts in this post can also be found on our Git...
Forums
how about explaining your RegEx logic?
RegEx is always tough to digest (without referring to document), so it would be...
Relatively easy query assistance - datediff
Hi all, I have a question since I'm new to SQL: I have a...
Mirroring alerts
Hi, In one of our customers the database mirroring was already configured. After long...
Ask SSC