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 […]


725 reads


State of Database DevOps Survey


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

HP is the 2019 Laptop Winner


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


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

Read the latest Blogs


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


SQL Server Q&A from the SQLServerCentral community

Get answers