Upgrading to SQL Server 2016: Pre-upgrade tasks
Trust me when I tell you that the extra legwork now will save you headaches later. Here is my checklist of items for upgrading to SQL Server 2016 that you must review before any data is migrated.
SQL Server Performance
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.
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.
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.
What Does a DBA Do All Day?
It is clear to me that no one, except for database administrators, has any idea what a DBA does all day long:
The 5 Deadly Data Management Sins
So, while the world’s collective media shine a light on the never-ending list of security breaches, I suggest that there are actually more common, and dare I say, even bigger threats that data professionals need to guard against. Not all data professionals are guilty of every one of these sins; rather, the collection of individuals that comprise modern enterprise IT shops is culpable.
