Administration

SQLServerCentral Article

Using Different Techniques for SQL Server Automation

  • Article

Automating SQL Server tasks is the sign of an experienced DBA. One who doesn't waste time on repetitive tasks that can be easily setup in a job, task, or some other scheduling process to run when they need to run. Haidong Ji has written a number of articles on how to perform automation and brings us yet another technique. This time he looks at managing your backup files, something that we all need to do, but all too often forget to do.

5 (2)

You rated this post out of 5. Change rating

2004-08-02

17,389 reads

Blogs

Denver Dev Day Oct 2024 Slides

By

Here are the slides from my talk today: CI in Azure DevOps If you...

Should I Learn PostgreSQL

By

I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...

A New Word: Hickering

By

hickering – n.  the habit of falling hard for whatever pretty new acquaintance happens...

Read the latest Blogs

Forums

Are We Dinosaurs?

By Grant Fritchey

Comments posted to this topic are about the item Are We Dinosaurs?

how to solve a conversion failure error

By Wren

Sample query reply appreciated Getting the following error: Conversion failed when converting the varchar...

Why does SSMS always pop up this window every time I get into it?

By Rod at work

For the last few weeks every time I get into SSMS 20.2 I am...

Visit the forum

Question of the Day

Code Blocks

What happens with this code:

DECLARE @Iteration INT = 0;

WHILE @Iteration < 10
    SELECT CustomerName,
        CustomerStatus
    FROM dbo.Customer
    WHERE CustomerID > 3;

    SET @Iteration += 1;

See possible answers