(James Serra) SQL Server 2016 introduces a very cool new feature called real-time operational analytics, which is the ability to run both analytics (OLAP) and OLTP workloads on the same database tables at the same time. This allows you to eliminate the need for ETL and a data warehouse in some case

(Sandeep Chanda) The support for Temporal Tables has now been extended to SQL Azure databases. With Temporal Tables, you can track changes made to your data and store the entire history either for analysis or for making the information actionable.

(Chris Skorlinski) I had need other day to STOP and START all Distribution Push Agent. Using the syssubscriptions and syspublications I can easily build list of SQL commands to either stop or start all the Distribution Push Agents.

(Daniel Mellor) Always On Availability Groups is the new feature for High Availability in SQL Server 2012. It’s been out for awhile now, but unless you have Enterprise Edition SQL, you might not have been able to use it much.

(Kenneth Fisher) Continuing my exploration of Azure the next logical step seemed to be copying an on-premise database up to the cloud.

(Jack Vamvas) I run a daily health check across SQL Servers . One of the checks made is whether the SQL Server configurable AUTO_SHRINK is turned ON.

(Hannes du Preez) There will be times when you need to get the next number in a sequence. Say, for example, you store all student numbers, or you keep track of them. Then, you need to get the next student number in the list and you do not know what it will be.

(Matt Busche) The title of this is horribly confusing, but hopefully this is helpful for some people. The problem I was trying to solve is I have a report that shows where travelers are based on certain dates.

(Sanjay Mishra) DBCC CHECKDB is a common database maintenance task. It can take up significant amount of system resources, and can impact the performance of the production workload.

(Jason Brimhall) I have a fairly large backlog of articles that are in progress or that are planned for my series about Extended Events. Despite the backlog and planned articles, every now and then something else comes up that bumps things around.