Upgrading to SQL Server 2016: Upgrade tasks
Let’s look at the steps involved in upgrading to SQL Server 2016.
Featured
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.
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).
The Top 5 Most Common Problems With SQL Server
Over the years I’ve been able to compile a list of issues that I would consider to be common with SQL Server (and other database platforms like Oracle, no platform is immune to such issues). These are the issues that are often avoidable but not always easy to fix once they have become a problem. The trick for senior administrators such as myself is to help teams understand the costs, benefits, and risks of their application design options so as to avoid these common problems. So, here is my list of the top 5 most common problems with SQL Server.
Upgrading to SQL Server 2014: A Dozen Things to Check
I’ve witnessed 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.
HOW TO: Connect To A Windows Azure VM Using SQL Server Management Studio
In 2013, right before I was helping to deliver a precon seminar at TechEd on Windows Azure SQL Database, Microsoft made available the ability for customers to use virtual machines running in Windows Azure. This allowed for users to run on-premises version of SQL Server but have the instance hosted in the cloud. The natural … Read more
