SQLAdmin

 If you create a new SQL Agent job step with tokens in output file name using the stored procedure sp_add_jobstep or want to add a filename...

For the first time in a long time we have a security update for SQL Server with MS16-136 . Some technical details on the update itself are ...

Microsoft Transact-SQL (T-SQL) is really great for many things inside the SQL Server Database Engine, but automated maintenance with file h...

I had to create a workaround on a database backup job for a server withe 50+ important databases. To be sure that an attempt is made to tak...

With SQL Server 2012 SQLPS was changes from a mini-PowerShell to a PowerShell module. This makes is much simpler to import the functionality...

When a ps1-scriptfile contains a Clear-Host statement, which I often use when testing a script in PowerShell ISE, the script fails on SQLPS ...

To log the execution and output from all steps in a SQL Server Agent job into a single logfile, you can use SQL Server tokens and macros to ...

I often use the standard folders of SQL Server, like the folder "Log" with SQL Server Error Log files and my SQL Server Agent job ...

I wanted to have a template for a SQL Server Agent PowerShell job step. A key feature of the template is to make the job step fail controlle...

Some time ago I wrote about this in another blog entry , and I do it again while there are some major changes in what I want to use. First ...

There are several CmdLets for output in PowerShell. I got some by the statements man write-* and man out-* Putting the CmdLets in a scr...

I have entered CodePlex. After some looking around, my first project is published. Please take a look. The subject is maintaining the dat...

When a database mirroring session is created using Microsoft SQL Server Management Studio (SSMS) the job "Database Mirroring Monitor Jo...

I have had some problems executing a PowerShell script in a SQL Server Agent job step. The errormessage I got – several times – was Execut...

This seems like a valid and simple way to execute a PowerShell script in a SQL Server Agent job step. The script I've been testing with...