(Rajendra Gupta) In previous tips SQL Server 2016 extended events detailed backup information, SQL Server restore steps with extended events and SQL Server 2016 Telemetry Extended Event Session we have seen how useful Extended Events are in SQL Server 2016 compared to Profiler.

(Joshua Feierman) If you are a DBA who hasn’t so far dived in head-first into using Azure, it is worth setting up an Azure ‘Virtual Lab’ environment the easy way, using a template. This will then allow you to experiment, try things out with SQL Azure, and get familiar with Resource Groups.

(Pinal Dave) When it rains, it pours. In the last few days last few contacts from my customers were for cluster related issues.

(Greg Larsen) The first thing I do in the morning at work is to scan my email looking for nightly failed SQL Agent jobs. Not only does my inbox have all the SQL Agent Job failures, but it also has lots of successful job notifications and alert email messages.

(Kenneth Fisher) Ok, I know I’m hosting T-SQL Tuesday this month but I still had post I wanted to share.

(Kennie Nybo Pontoppidan) If you use SQL Server 2016 for your Dynamics NAV database, and you need to export a database to the .bacpac format, then please make sure that you are running the latest update (August 2016 update or later) of the Microsoft SQL Server Data-Tier Application Framework (DacFx)

(Grant Fritchey) There are a bunch of ways you could create a database clone. Backup and restore is one method. Export/Import is another. There are even third party tools that will help with that.

(Arun Sirpal) For this post I want to show you how I recovered to a LSN where I did do this on a server where I wanted to go back to a time just before a delete occurred.

(Greg Larsen) Is your msdb database growing bigger every day? If so you might want to consider purging some of the history records from the msdb database. One of those types of history records that are stored in the msdb database are records associated with using database mail.

(Pinal Dave) Along with freelancing, consulting, I also spend time in replying to my blog comments to learn something new. Few such conversations end up in business deals, few in emails and few in the blog. This blog originates from one of such conversation regarding incorrect syntax.