(Dinesh Asanka) When subscriptions are created, owner of that subscription will be the user who creates it. However, when that user account is disabled, subscriptions will be failed and there is no way from the user interface to change it.

(Chris Bell) Identity columns are great. they help us to understand our data better, and can even help our queries to perform better.

(Pinal Dave) Here is an interesting comment from one of my previous blogs on how to change the compatibility level of SQL server post posted earlier. Some of these comments are interesting and can provide some interesting extension to blog ideas like this.

(Chris Shaw) This article is part 6 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is not all inclusive.

(Chris Webb) I saw an interesting post the other day on the Power Query Technet forum which showed how the List.Buffer() function could be used to improve calculation performance.

(Koen Verbeeck) Next to the average and the median, there is another statistical value that you can calculate over a set: the mode. This is the value that appears the most often in the set.

(Kenneth Fisher) The other day Tom Roush (b/t) and Tim Radney (b/t) were having a discussion on twitter about using scheduled windows tasks to run SQL Processes. Now why would you ever want to do this?

(Mladen Prajdic) The new feature is called Global Replacement Texts.

(Pinal Dave) Recently I wrote blog to enable and disable all constraints in the database SQL SERVER – How to Disable and Enable All Constraint for Table and Database.

(Jen McCown) A company with more than one SQL Server instance has no built-in way to gather and report on maintenance, backup, and configuration data across those instances.