One thing I have noticed in all my years as a data professional: few users understand (or care) how far away they are from their data. Quite often they expect instant results from their queries. They don’t understand the upper bounds of resources like network bandwidth, the speed of light, and that the data is … Read more
Azure SQL Database does not support the WITH ENCRYPTION option for objects such as stored procedures, user defined functions, triggers, or views.
I’ve been involved in a virtualization projects for almost ten years now. In that time I’ve had the opportunity to track my own list of “best practice” items. It’s a list I share freely with clients and customers that seek me out for virtualization advice. I can tell that virtualization (and Cloud) efforts are on … Read more
Database disasters happen from time to time. I have a method that allows you and your business to survive any database disaster. Have backups. This isn’t rocket surgery. You are only going to be able to fully recover from any disaster to the point of your last good backup. No backups mean you can’t recover. … Read more
I am truly honored to have received my fifth straight SQL MVP award today. Two years ago I wrote these words and they still ring true today: The past two years have been very good to me as a database professional and I know that a big part of that is because I have been … Read more
Many novice administrators make the common mistake of believing that the SQL Server upgrade process for a database server is as easy as pressing a few buttons.
