(Jayendra Viswanathan) In the world of software development, SQL Server developers face issues when it comes to having to perform multiple Insert and Update statements.

(Grant Fritchey) I use Extended Events almost exclusively for capturing query metrics. They are the most consistent and lowest cost mechanism for getting the time and resources used by a query. They can be filtered, combined with other events, they’re just marvelous… until you capture an execution p

(Chris Webb) The April 2018 release of Power BI Desktop included a new M function: Binary.InferContentType. There’s no online documentation for it yet but the built-in documentation is quite helpful:

(Pinal Dave) The scariest word for any DBA is – Database Downtime. Every DBA who is going off duty for the day or going away on vacation for a month is always worried about Database Downtime. I totally sympathize with everyone who is constantly worried about their database’s downtime.

(Hannes du Preez) You may need to check address fields (for example) for a NULL value or an empty string (the value looks null, but simply contains an empty string – which is still technically a value).

(blobeater) After demo building and testing features out within Azure SQL Database I like to delete the databases to save costs. Very rarely the following happens when trying to delete a database within Azure.

(Prashant Pratap) Here are the simplified steps to start developing Azure Bot Function. In this blog post we will create a test bot that talks to LUIS and QnA Maker. LUIS will help us understand user’s natural language. QnA Maker will help us answer user’s frequently asked questions.

(Parvathy Natraj) How do I transform JSON data to relational data in SQL Server 2016?

(Thomas LaRock) From Strata last year, Kurt Brown from Netflix gives a wonderful talk on how Netflix get’s the most out of their data platform. The video is 37 minutes long and worth your time.

(Jason Brimhall) It may come as no surprise to many that Microsoft has hastened the SQL Server development cycle. Furthermore, it may be no surprise to many that Microsoft has also hastened the patch cycle for SQL Server.