Steve Rezhener

Verify your SQL Server database backups

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 […]

4.25 (4)

2020-01-07

5,895 reads

SSISDB Catalog Defaults Best Practices

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 […]

5 (1)

2019-12-26

3,596 reads

Blogs

Reviewing 2019 Career Goals

By

According to this post, I rate 2019 as a Failure. Of the books I...

ASF 029: Tomaz Kastrun interview

By

Introduction Tomaž Kastrun is BI & DEV developer, data analyst & data science. With...

Schema Filtering in SQL Prompt

By

I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue...

Read the latest Blogs

Forums

Can we use DC SQL Cluster Role name in DR Site (Same name Both Site)

By Harshana-455711

Hi I have SQL Server FCI running in my DC site following are cluster...

error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE

By webrunner

Hello experts, A client is reporting the following error when his application tries to...

Connectivity to Oracle 12.2 instance via OLE DB ?

By VoldemarG

I installed Oracle 12 on Windows 10 in  all possible ways/configurations, including the defaults....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers