(James) I’ve long thought about creating some video content but forever put it off – like many people I dislike seeing and hearing myself on video (as I quipped half in jest, half in horror, on Twitter “I have a face made for radio and a voice for silent movies”).

(Jose M Jurado) Today I worked with a customer that were not able to connect to their Azure SQL Database from their Azure environment. They have protected their environment using different appliances and just having the port 1433 for outbound connections.

(Rick Dobson) Please provide a general framework with SQL code based on data science practices for assessing if a set of data values conform to any of several commonly used distribution types.

(Chris Webb) Reading Prathy Kamasani’s excellent blog post on Sync Slicers the other week I had a revelation: in the post Prathy shows how it is possible to sync selections between two slicers that are based on different columns from different tables in your dataset, something I had not known was po

(Priyanka Devre) In this article, we will continue our journey to configuring a SQL Server AlwaysOn High availability configuration and failover nodes, by setting up iSCSI including an iSCSI initiator, setting up disk drives on notes, configuring our Quorum and finally installing the SQL Server clus

(Kenneth Fisher) I tend to feel that a lot of people who use triggers don’t really understand them. That said, every now and again you have to deal with them. And in particular (for this post) you might need to disable and then re-enable them.

(Grant Fritchey) I’ve shown before how to use the DMVs that read the plan cache as a way to connect the missing indexes suggestions with specific queries, but the other place to find missing index suggestions is the Query Store.

(Jose M Jurado) Today, I worked on a case that our customer needs to load some data from a bacpac to an Azure SQL Database, for different and urgent situations was not possible to export and create again this bacpac.

(Laeeq Hamid) I have an XML document with some incorrect data in it. Is there a way of iterating through the nodes of XML document using T-SQL and correcting the data before processing the contents?

(James Serra) Azure Data Explorer (ADX) was announced as generally available on Feb 7th. In short, ADX is a fully managed data analytics service for near real-time analysis on large volumes of data streaming (i.e. log and telemetry data) from such sources as applications, websites, or IoT devices.