(James Serra) Read Scale-Out is a little-known feature that allows you to load balance Azure SQL Database read-only workloads using the capacity of read-only replicas, for free.

(Denny Cherry) If you work in IT, you probably heard about the disaster that Azure had last week with their South Central US (Texas) region. This outage has been a significant problem for a lot of customers, as well as to Microsoft.

(Pinal Dave) One of my clients contacted me in a situation where their business was down! Their production SQL Server instance used by their Human Resource team was unable to start in a clustered environment.

(Kevin Beaver) What’s your situation with regard to web application SQL injection? Are you testing for it from all the right angles?

(Itzik Ben-Gan) Gaps and Islands tasks are classic querying challenges where you need to identify ranges of missing values and ranges of existing values in a sequence.

(Jovan Popovic) Azure SQL Database is a fully managed latest stable version of SQL Server Database Engine hosted in Azure cloud that has several built-in features that protect and manage your data.

(Simon Liew) I have a table with many columns in Teradata. I wanted to copy data from this Teradata table quickly to SQL Server to do some data reconciliation.

(Kenneth Fisher) I was reading a post today by Bert Wagner (b/t).

(Pinal Dave) I hSQL SERVER – How to Generate Random Password? – Enhanced Version – Part 2 randompassword ave previously written about Random Password before in the blog posts here, here and here.

(Pablo Echeverria) It is often required to perform advanced operations within a SQL Server Agent Job step, like interact with the operating system or import custom modules.