Changing Default Database File Locations in SQL Server 2016
At some point in your career as a data professional you will need to change the default database file locations in SQL Server 2016.
Database Design
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.
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.
SQL Server Identity Values Check on GitHub
Last year I blogged about a script that Karen López (blog | @datachick) and I wrote together to help you determine if you were running out of identity values.
How To View Always Encrypted Data in SQL Server Management Studio
One of the shiny new features in SQL Server 2016 is Always Encrypted. Here’s how you can view the plain text data inside of SQL Server Management Studio.
How To Survive A Database Disaster
I am here today to share with you my FOOLPROOF method that allows you and your business to SURVIVE any database disaster.
