If you use the excellent tools from dbatools.ie to manage your SQL Server, you may worry about what happens if it all goes wround.  Maybe the resatore files were corrupted wne copied from another server or not in the directory you specified.  Well, I worry about stuff, so I tried to find a solution.  This […]

SQL Agent jobs that run a PowerShell script need to run with a proxy account, so I can adhere to Windows permissions constraints.  However, the SQL Agent job returned the following error message Message Unable to start execution of step 1 (reason: Error authenticating proxy DOMAIN\account_name, system error: The user name or password is incorrect.).  […]

I was asked recently to setup Heterogeneous SAP replication from SAP ASE to SQL Server and then the task was extended to also replicate to an Azure Database. This can be complicated to setup and get working so I documented the procedure and updated our PDF downloadable instructions available from, http://www.dbxperts.co.uk/downloads/ A common issue with the […]

If you want to backup your SQL Server databases you normally use the Maintenance Plan Wizard to generate an automated job to do just that. But what if you want to backup across multiple files to improve the backup performance ( on multi CPU servers) AND still included an automatically generated date/time stamp within the […]