Administration

Verify your SQL Server database backups

  • Article

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.33 (3)

2019-11-22

5,106 reads

Verify your SQL Server database backups

  • Revision

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

2019-11-22

Fixing MLS Python Services to Load the Runtime

  • Article

Recently I went to work on a SQL Server 2017 instance and couldn't get the Python runtime to load. I'd keep getting this error: A strange error for me to see, and one that didn't quite make sense. How can the runtime not launch? However, restarting the instance still resulted in this error: Msg 39021, […]

2019-10-24

1,245 reads

Blogs

The Gift of the SPN

By

Every once in a while there is an extremely valuable tool that comes along....

T-SQL Tuesday #121: Gifts received for this year

By

It’s T-SQL Tuesday time again! This edition is hosted by Malathi (blog|twitter) and the...

A gift. T-SQL Tuesday #121

By

My good friend Malathi Mahadevan (blog|twitter) is hosting T-SQL Tuesday this month and wants...

Read the latest Blogs

Forums

T-SQL script to purge all the tables including foreign key references

By Brahmanand Shukla

Comments posted to this topic are about the item T-SQL script to purge all...

Performance difference

By tcroninlifepoint

I have a user sql from 3rd party started running terrible on prod server. ...

List of INDEX with create and DROP script should not include any constrains P/F

By DBA.k

Hello Sir.. Please help me the script.. From entire database i want List of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers