(Jack Vamvas) Question : During a recent round of patching , I’ve been frequently seeing msdb110_upgrade.sql’ encountered error 574, state 0, severity 16 in the Event Viewer when the service for the SQL Server Instance is attempting to start.

(Jovan Popovic) Azure SQL Managed Instance is fully managed and secured SQL Server Database engine hosted in Azure cloud, placed in your private Azure VNet.

(Jayendra Viswanathan) Indexes allow queries to run faster for data selection and are a key part of high performance for SQL Server. In this tip, will see the types of indexes used in SQL Server such as clustered indexes, non-clustered indexes, filtered indexes and how to create, modify and delete i

(blobeater) So you want to do a clean-up exercise in Azure and remove some databases. You go to delete a database that is no longer required (as shown below)

(Anoop Kumar) In a previous article we discussed Modern Data Warehouse designs patterns and components. In this article we will discuss two more modern design patterns to handle your scenarios; 1) Advanced Analytics on big data 2) Real time analytics

(Daniel Janik) I’ve read a lot of things lately pointing to scalar functions as if they were the devil. In this blog I’m going to explore if that’s the case. Let’s have a look.

(Robert Sheldon) The Gen2 version of Azure SQL Data Warehouse gives Microsoft’s cloud data warehouse a shot in the arm on performance, making it more competitive with rival technologies.

(Pedro Lopes) Over the years you have read a number of blogs advocating for or against trace flags that influence SQL Server’s query execution model.

(Prashanth Jayaram) The ability to combine results from related rows from multiple tables is an important part of relational database system design. In SQL Server, this is accomplished with the SQL join clause.

(Grant Fritchey) A question that came up recently around Query Store is what happens when there are log backups in use on the database. Let’s talk about it.