(Marcin Policht) In our recent article published on this forum, we have described the principles of using Azure Active Directory to authenticate to Azure SQL Database. We also provided a high-level overview of the multi-step procedure that allows you to implement this functionality. In this article,

(Nakul Vachhrajani) It’s a well-known fact that using T-SQL cursors have a significant overhead on the query performance.

(sqlkris) The INSERT statement is used to add rows to a SQL Server data table. In this article we’ll explore how to use the INSERT statement. We discuss some best practices, limitations, and wrap-up with several examples.

(Chris Webb) Since my last post on the Excel cube functions proved to be very popular, I thought I’d write a follow-up that shows off some more little-known but interesting functionality: how to use the CubeSet() function to combine selections from multiple slicers.

(Daniel Mellor) This is the final post in the SQL Server Storage line of blog posts I’ve made. First we discussed Pages & Extents, then how to Read A Page using T-SQL, and finally this post will be about Disk Partition Offsets and Allocation.

(Greg Larsen) Sometimes the SQL Server ERRORLOG file can become very large. This happens typically when you have turned on auditing for successful and failed logins.

(Murilo Miranda) Active Geo-location is powerful magic for ensuring the high availability of a Azure SQL database, and for disaster-recovery.

(Kenneth Fisher) So to start, what’s a BACPAC?

(Greg Larsen) There are times when you might want to read backup / restore history information for a SQL Server database. This information is stored in the backup / restore metadata tables within the msdb database.

(Jack Vamvas) Question: I’m experiencing some strange behaviour with response from the SQL Server DMV sys.dm_db_index_usage_stats.