Delete old backup files

This is one example of how you can make backups with a date stamp for the file name. You can then periodically remove the files that are older than a specified date by simply placing a few lines of code in a job step and calling the supplied sp and passing the date from which […]

2003-04-25

725 reads

Blogs

State of Database DevOps Survey

By

Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe...

HP is the 2019 Laptop Winner

By

This is for me, not necessarily for you, but I decided to go with...

Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 4

By

This is the fourth and final post in a series about modern Data Lake...

Read the latest Blogs

Forums

Snapshot Isolation and DMVs

By chris.o.smith

I recently noticed that DMVs, or at least sys.dm_db_partition_stats, does not respect snapshot isolation. ...

SSAS Remote Access

By Nick

Hi all, I've been using Power Pivot and Power BI for some time and...

Stored Procedure Documentation

By SQL Espo

I have developed several stored procedures that will be utilized by developers on a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers