(Paul White) This article uses a simple query to explore some deep internals concerning update queries.

(Pinal Dave) I have been a big supporter of the Activity Monitor capability inside SQL Server Management Studio. And I have written a number of articles before in this blog. Please take a moment to look at:

(Svetlana Golovko) Among all of the new SQL Server 2016 Database Engine features Query Store stands out as a great addition to the performance tuning tools currently available out of the box. In this tip, we will look at how you can use this new feature.

(Pinal Dave) In this world of change, the SQL Server product is also changing. One thing which is very clear is that Microsoft is listening to feedbacks from customers and enhancing the setup experience also. Some of the classic feedback implementation can be seen in the setup of the next version of

(Marcin Policht) While Azure SQL Database offers a number of advantages inherent to its Database-as-a-Service nature, there are scenarios where capacity or functionality requirements force you to resort to an alternative approach and deploy SQL Server in an Azure virtual machine.

(Daniel Farina) One of the new features of SQL Server 2016 is native support for Row Level Security. In this tip I will introduce you to the concept of Row Level Security and show you how to implement this new feature.

(Pinal Dave) There are a number of blogs around using SPARSE columns here. Here are few of them for reference and can be used as a great learning experience.

(Edwin Sarmiento) After deploying a SQL Server Analysis Services instance, I wanted to test application connectivity to make sure remote connections are allowed. However, I am having issues connecting to it from a remote machine. How do I troubleshoot connectivity issues to a SQL Server Analysis Ser

(Pinal Dave) I had recently gone to my hometown to visit my parents as it was holidays for my daughter because of festival. These are relaxing times and hardly try to get in front of my computer during these 2-3 days of family time.

(Ghanesh Prasad) In SQL Server Integration Services we don’t have an ISNUMERIC() equivalent function within the SSIS expression language. If you know C# or VB, you can code a script task to check if data is numeric or non-numeric, but if you don’t know how to code in C# or VB you might be in trouble