(blobeater) Thanks to Grant for hosting this month’s T-SQL Tuesday found (http://www.scarydba.com/2017/06/06/t-sql-tuesday-091-databases-devops/) where it is a chance to share our DevOps stories.

(Pinal Dave) In versions prior to 2012, you need to use the CONVERT function with different styles to convert the date values into a different format. Let us learn about the FORMAT function in this blog post.

(Greg Larsen) In my last tip, I showed you how to use a transaction log backup file to identify who deleted an object from a database. In this tip, I will show you how to find out the actual table name for the object deleted.

(Holger Sirtl) Recent changes in Azure brought some significant changes in autoscaling options for Azure Web Apps (i.e. Azure App Service to be precise as scaling happens on App Service plan level and has effect on all Web Apps running in that App Service plan).

(Kenneth Fisher) A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He then ran into an issue where he had to have one.

(Manoj Pandey) After installing the AzureRM module, I tried to import it, but it gave me an error:

(Scott Murray) Often when you speak with a DBA about grouping items into specific sets or binning data into certain groups, they will say, “Do it in the presentation layer” and not in your query.

(Denny Cherry) Running SSRS with the ReportServer and ReportServerTempDB databases has been supported for a while now. If however you want to use scheduled delivery of reports you need to do some extra stuff to make this work.

(Michael J. Swart) A .Net tick is a duration of time lasting 0.1 microseconds. When you look at the Tick property of DateTime, you’ll see that it represents the number of ticks since January 1st 0001.

(Pinal Dave) Question: Why I am not able to KILL SPID with command KILL (spid) WITH STATUSONLY?