(Greg Larsen) The installation process for SQL Server has changed slightly with the release of SQL Server 2016. You now have a couple of new installation options available when you install SQL Server 2016.

(Ghanesh Prasad) You created a SQL Server Reporting Services report and the requirement is to output to Excel format. As you may know, SQL Server Reporting Services (SSRS) provides functionality to export a SSRS report into Excel, but for long reports the column headers disappear in Excel when you s

(Pinal Dave) One of the blog followers asked this question “The code written by my colleague has WHERE 1=1. What does it mean?”

(Pinal Dave) One of the blog followers asked this question “The code written by my colleague has WHERE 1=1. What does it mean?”

(Jeremy Kadlec) Time is of the essence when SQL Server is down or when pressure is mounting from multiple project deadlines. So finding accurate information quickly is difficult at best. When you are not sure where to turn for valuable information stress levels only increase.

(Jeremy Kadlec) Time is of the essence when SQL Server is down or when pressure is mounting from multiple project deadlines. So finding accurate information quickly is difficult at best. When you are not sure where to turn for valuable information stress levels only increase.

(Michael J. Swart) About eight years ago, Dan Guzman wrote a post called Use Caution with Explicit Transactions in Stored Procedures. In it, he talks about error handling and transactions, specifically with respect to the XACT_ABORT setting.

(Chris Webb) One unadvertised – but still very welcome – feature of Excel 2016 is that it is now possible to do a drillthrough in a PivotTable when there is a multiselect on a filter or a slicer. It only works if you are using SSAS 2016 on the server, or if you’re querying the Excel Data Model/Power

(Rohit Garg) Data Compression is feature of Microsoft SQL Server to reduce the size of table on the basis of Duplicates, Null & Zeroes. It’s a process of reducing size of database & its objects by increasing CPU cycle and reducing I/O effort.

(Pinal Dave) The more you read the more you learn. But some of the best learnings need not come from known sources. These can be accidental too. These learnings in my opinion involves tons of exploration which you would have never done before.