Identifying Deprecated Feature Usage (Part 2)

2017-07-21 0 Comments

Dave Mason - SQL Server Deprecation

In my previous post, I took a stab at monitoring deprecation events for SQL Server. It didn't go so well. A deprecation event occurred more than 5,000 times in a very short period of time, and I got one email for every occurrence. Not good. Here's what I kept seeing over and over:

0 comments:

Identifying Deprecated Feature Usage (Part 1)

2017-07-20 0 Comments

Dave Mason - SQL Server Deprecation

I've wanted to do some Event Notification testing for SQL Server deprecation events for quite some time. The thought process here is that I could send myself an alert to identify usage of SQL Server features that will be removed from the next major version (or future version) of SQL Server. I could then forward this info to development and let them take action...or not (I kid, I kid). Today is the day I finally got around to the testing. I didn't get very far, though.

0 comments:

STOPAT And Date Formats

2017-07-12 0 Comments

Dave Mason - SQL Server RESTORE LOG STOPAT

I recently had the need to restore a database with recovery to a point in time. I've only done this a few times, so I had to look up the syntax for stopping the last and final transaction log restore. Microsoft Docs shows us this "Basic Transact-SQL syntax":

RESTORE LOG database_name FROM WITH STOPAT =time, RECOVERY…


There's nothing I see in the documentation regarding the format for "time". But there are a couple of examples, including this one:

0 comments: