(Nakul Vachhrajani) I was recently participating in a forum and came across an interesting question. What attracted my attention was that the person was trying to keep their T-SQL code clean and readable (which in itself is a rare sight).

(Ameena Lalani) Temporal tables were first introduced in SQL Server 2016. It is a great feature for tracking DML changes over the life of the data row in a particular table. Temporal history tables are meant to keep historical data for a long period of time.

(Arun Sirpal) Naturally the cost of Azure SQL Database directly relates to what tier and performance level you are using. Starting from the least expensive basic database to the more premium ones I thought it would be worthwhile capturing the costs (GBP) across all tiers.

(Thomas LaRock) The SQL Vulnerability Assessment (VA) feature in now available in SSMS (SQL Server Management Studio)!

(Randy Park) A customer recently launched a global intranet portal with an audience distributed across the globe. They expected an increase of the audience on a daily basis and leadership team requested one more interesting feature– live video streaming.

(Grant Fritchey) With all the options available within T-SQL these days, it’s more and more imperative that our code be clear and consistent. For example, there are clustered indexes and nonclustered indexes.

(Denny Cherry) Back when Azure and Azure Active Directory got Windows InTune pushing down setting, and specifically oddball settings changes were complex. In the newest release of InTune that is accessible via Azure and Office365 things have gotten much easier.

(Marcin Policht) In our previous article published on this forum, we described main characteristics of two new features known as Virtual Network service endpoints and Azure SQL Database virtual network rules. Their purpose is to restrict inbound traffic targeting an Azure SQL Database server to indi

(James Serra) Azure Databricks (documentation and user guide) was announced at Microsoft Connect, and with this post I’ll try to explain its use case. At a high level, think of it as a tool for curating and processing massive amounts of data and developing, training and deploying models on that dat

(Greg Larsen) There may be times when you need to perform some maintenance against a database that requires you to keep normal database users from connecting to your database, while the maintenance is being performed.