Creating Backup Devices
This Stored Procedure create backup devices for all user databases. You can customize path, name standard and type of device.See Creating Job Backup
2002-09-12
511 reads
Creating Job Backup
This Stored Procedure create backup job for all user databases. You can customize SQLAdmin operator.See Creating Backup Devices
2002-09-12
832 reads
Blogs
Power Platform Quick Tips – Episode 01: Fixing Power BI Column Sorting
By Devin-Knight
Check out this new series that I’ve started on Power Platform Quick Tips. This...
The curious case of CHAR(0)
Over the years I’ve seen quite a few strange things with SQL Server. This...
Transaction log Information gathering
By Vinay Thakur
Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...
Forums
how can i see the last 100 select statements that were run by any user
how can i see the last 100 select statements that were run by any...
Dynamically execute SSIS package.
I am trying to figure out how to dynamically execute SSIS package based on...
Metric CPU show 100% , but Query Performance Insight show only 60% same period
Hi, I am investigation DTU spike for period specific period of time In my...
Ask SSC