(Scott Murray) I heard Power BI Desktop now allows the use of parameters; how can I make use of this feature?

(Dinesh Asanka) When ever we execute stored procedure script, we always drop the existing one and recreate it.

(Jen Stirrup) Microsoft are retiring Azure DataMarket due to a lack of sustained customer interest in DataMarket. Why is that, and where do we go from here?

(Pinal Dave) One of my blog readers reported a strange issue to me. As per the issue described, they were unable to bring SQL Server resource in cluster online, only on one node of the cluster.

(Arun Sirpal) I am in the middle of some research regarding CHECKDB and learnt something new. From SQL Server 2014 onwards the database snapshot that is used to get to a transactionally-consistent point-in-time is no longer hidden.

(Brien Posey) SQL Server is a CPU-intensive technology, which can make it tricky to run in a virtualized environment. Keep your SQL Server virtual machines running smoothly with these tips on using Hyper-V.

(Krishnakumar Rukmangathan) In this blog, I would like to show you how we can connect to a SQL Server Instance using PowerShell cmdlets.

(Pinal Dave) When SQL Server 2016 was released, there were a number of enhancements that were discussed around how InMemory OLTP removed which were as limitations. I personally saw some real boot to some of the capabilities coming into InMemory OLTP especially around the concept called as Operationa

(Prashanth Jayaram) The Dynamic Management View (DMV) named sys.dm_db_index_usage_stats that track index usage details of the database. This DMV gives an information about an index which is being updated but not used in any seeks, scan or lookup operations.

(Melissa Coates) This is part 1 of 2 about Azure Analysis Services (Azure AS) which was announced a few days ago. Azure AS is a Platform-as-a-Service (PaaS) offering which is currently in public preview mode at the time of this writing (late October 2016).