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
5,895 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
3,596 reads
By Steve Jones
According to this post, I rate 2019 as a Failure. Of the books I...
By Kamil
Introduction Tomaž Kastrun is BI & DEV developer, data analyst & data science. With...
By Steve Jones
I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue...
Hi I have SQL Server FCI running in my DC site following are cluster...
Hello experts, A client is reporting the following error when his application tries to...
I installed Oracle 12 on Windows 10 in all possible ways/configurations, including the defaults....
Ask SSC