Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Msg 3168, Level 16 – The Backup of the System Database on the Device Cannot be Restored Because it was Created by a Different Version of the Server

June 23, 2017

Ransomware, SQL Backup, SQL Error Messages, SQL Restore, SQL Server, System Database

In the recent past, I have written a blog about Ransomware. Here is the link. system database – How to Protect Your Database from Ransomware?

SQL SERVER – Unable to Restore from URL – The Specified URL Points to a Block Blob. Backup and Restore Operations on Block Blobs are not Permitted

June 22, 2017

Pinal Dave

SQL

SQL Azure, SQL Backup, SQL Error Messages, SQL Restore, SQL Server

With Microsoft Azure pitching in the market, I am getting few clients who want me to assist them for errors related to Azure as well. As a part of growth, I do learn them and try to help the clients. Let us learn about Block Blobs in this blog post.

SQL SERVER – FIX: Msg 15170, Level 16, This login is the Owner of 1 Job(s). You Must Delete or Reassign these Jobs Before the Login can be Dropped

June 21, 2017

Pinal Dave

SQL

SQL Error Messages, , SQL Scripts, SQL Server, SQL Server Security

In our real life, there are lots of dependencies and same is true with SQL Server as well. This blog also talks about inability to drop a login due to a dependency.

SQL SERVER – New Quality of Database Documentation – Dataedo

June 20, 2017

Pinal Dave

SQL

I recently stumbled upon an interesting tool – Dataedo, quite powerful database documentation tool. It enables describing each table and column (data dictionary), procedure and function, create ER diagrams from existing schema and generate a pretty HTML, PDF or Excel documents.