(Adam Machanic) I’ve been thinking a lot about SQL Server 2016 temporal tables of late. I think it’s possibly the most compelling feature in the release, with broad applications across a number of different use cases. However, just like any v.1 feature, it’s not without its faults.

(Prashanth Jayaram) This article talks about various SQL methods to fetch the disk usage details and use of T-SQL in conjunction with invoking OLE automation procedures and WMI class libraries using SQL Windows Shell interface.

(Derik Hammer) In the last post of this blog series, I discussed what a clustered index is and how to choose an ideal clustered index key.

(Rob Sewell) When you look in msdb for the SQL Agent Job duration you will find that it is an int.

(Nakul Vachhrajani) A few days ago, I tweeted a news piece that came to my attention on the name “NULL” causing computing systems to malfunction. When I shared it with my colleagues, a healthy discussion on how should software architectures handle NULL took place.

(Jason Brimhall) What do you do when a developer comes to you and asks, “Where did the database go? The database was there one minute, and the next it was not.” Only one thing could be database droppedworse than the feeling of losing a database on your watch, and that would be losing a production

(sqlkris) In this article we’ll discover data modification statements used to modify data in SQL server using the INSERT, UPDATE, DELETE, and MERGE statement.

(Chris Webb) The Excel Cube Functions are incredibly powerful, and I’m still amazed at the kind of problems they can solve. This post describes how they can be used to build a report with a complex OR filter using data from Power Pivot (it’s equally applicable to SSAS) that shows a number of advance

(James Serra) One thing I try to do in my role with Microsoft is to get clients to think of possible use cases for building solutions in the Azure cloud. To set off light bulbs in their heads. Sometimes this is accomplished by showing them demo’s of existing solutions.

(Daniel Mellor) This is a continuation post from last weeks’ SQL Server Storage: Pages and Extents explanation. Since the description was a bit longer than I originally expected it to be, I decided to split the scripts into more posts.