(Pinal Dave) There are multiple ways by which we can find a list of SQL Server instances name instances on a machine. In this blog, I would show a few ways to do it.

(Denny Cherry) The SQL Server Query Store which was introduced in Azure about a year ago or so, and came to the on-premises version of SQL Server in SQL Server 2016.

(Michael J. Swart) Adam Machanic tweeted this advice last week:

(Arun Sirpal) I remember asking a question at a recent training event, the outcome? I now don’t use task manager to try and understand how much memory SQL Server is consuming. Why? Well it has the ability to lie, and as you will see, it can lie really well. (Depending on settings)

(Nakul Vachhrajani) One of the SSIS related questions that I see often in the forums is around the ability to control the sequence in which a For Each Loop processes the files from a directory.

(Erin Stellato) The primary focus of this blog site is performance in a SQL Server environment. One could argue that performance starts with database and application design. But you can also make a case that having the right resources available is essential for good performance.

(Arshad Ali) Advanced Analytics is becoming a norm now. Every organization wants to use the power of advanced analytics to predict the future outcome and take proactive corrective measures to remain competitive and win over its competitors.

(Pinal Dave) When I wrote the blog around Understanding Database Scalability – Vertical and Horizontal, I saw few have conversations with me on if it is this or that. And these discussions could take a course all by itself. There is no one size fits all when it comes to scalability.

(Thomas LaRock) Today I wanted to help walk you through how to be up and running with SQL Server on Linux so that you can kick the tires on this version yourself.

(Craig S. Mullins) Microsoft SQL Server 2016 for Windows comes in four editions, with updates that include a new stretch database feature, Polybase, dynamic data masking and more.