Upgrading to SQL Server 2016: Reasons for upgrading
There are new performance features, new security features, and new scalability features in SQL Server 2016 that make it worth the time and effort to upgrade.
MSSQL
View BACPAC Files Using This One Weird Trick
I did not think it was possible to view the contents of a BACPAC file. However, last month while at SQL Bits I was reminded about this one weird trick to view the contents of a BACPAC file.
Install-Module dbatools
At some point in my career, I had been bitten enough times by linked servers failing to connect that I built a way to automate the checking of the linked server connections.
SQL Server 2016 Updated Privacy Statement
I want to help clear up any confusion around how SQL Server collects, stores, and uses data. I have some thoughts I want to share regarding the updated statement as well as the End User License Agreement (EULA).
KPIs For DBAs to Show Their CIOs
It is perfectly valid for a DBA (or their manager) to assign KPIs to the servers and databases they administer. KPIs are unique for every shop, and for every role.
HOW TO: Solve General SQL Server Connectivity Issues
Recently, Microsoft published a page for solving general SQL Server connectivity issues. This page is perfect for you or anyone you know that has suffered from one of the following error messages in the past.
