Introduction A popular joke about DBAs and database backups goes like this. There are two types of DBAs: DBAs that do backups DBAs that will do backups The joke is only stating the obvious – lack of database backups might be the end of a DBA career and/or the supported business. Unfortunately, that joke fails […]
2020-01-07
6,400 reads
Introduction The SSISDB database (a.k.a. the SSISDB catalog) was introduced back in SQL Server 2012 to de-clutter the MSDB database and provide an in-house logging and reporting infrastructure. In a nutshell, SSISDB is an SSIS framework making SQL Server Integration Services more robust and enterprise-friendly by providing the following features: Database backup Database encryption Support […]
2019-12-26
4,066 reads
I almost died. I’m sure a lot of you already know this but just...
By Steve Jones
This month the T-SQL Tuesday invitation comes from Tamara Clark. I strong-armed Tamara last...
By Arun Sirpal
Recently I found out that I passed the BETA exam for Azure Database Administrator...
Hi I have a job that I need to be notified/emailed if it runs...
Hi I have an application that is timing out i run the query...
I have table with all charges and payment the charges are 'c' and payments...
Ask SSC