(Ghanesh Prasad) Most SQL Server Reporting Services (SSRS) reports contain multi-value report parameters and sometimes there be a requirement to set “Select All” as the default. There is not a simple way to set “Select All” as the default for an SSRS report, but in this tip I will demonstrate how to

(Paul White) Back in January 2015, my good friend and fellow SQL Server MVP Rob Farley wrote about a novel solution to the problem of finding the median in SQL Server versions prior to 2012. As well as being an interesting read by itself, it turns out to be a great example to use to demonstrate some

(Pinal Dave) In recent past I have renamed my VM and wanted to make sure that everything is fine. This renaming process is also needed for changing the server names called inside of SQL Server too.

(Pinal Dave) In recent past I have renamed my VM and wanted to make sure that everything is fine. This renaming process is also needed for changing the server names called inside of SQL Server too.

(Marios Philippopoulos) Index-usage statistics get re-initialized when the SQL Server instance in question gets restarted and, starting with SQL Server 2012, after an index rebuild. This can obscure the true impact of indexes in day-to-day operations and lead to false determinations of used vs. unus

(Marios Philippopoulos) Index-usage statistics get re-initialized when the SQL Server instance in question gets restarted and, starting with SQL Server 2012, after an index rebuild. This can obscure the true impact of indexes in day-to-day operations and lead to false determinations of used vs. unus

(Vinoth Nm) Recently we had many issues due to one of our third party application using XA Transaction, We had 4 instances of SQL Server 2012 for this application set up on an active-active 4 node Cluster with Clustered DTC as a separate Role. Since the SQL instances were running XA Transactions the

(Pinal Dave) I enjoy spending time with my daughter almost every single day. It keeps me busy at home and most importantly, some quality time with her allows me to relax after a long day at work.

(Matt Bowler) After a data centre power outage a decision was made to switch the start up mode of a bunch of our SQL Servers to manual so that the on call DBA could manage the reintroduction of the servers in a controlled fashion.

(Denny Cherry) If you are planning on using Buffer Pool Extension (BPE) in SQL Server 2014 or SQL Server 2016 you need to think about where you want to put the BPE file on the SSD, especially as it relates to the Windows OS Security on the file system.