The Server Draft
If you were given the chance to build the ultimate server, what would you draft first?
SQL Server Performance
Advanced Accidental Database Design
Next week (12th April, 2016) we will be doing a webinar for SolarWinds, Advanced Accidental Database Design, taking place at 9AM ET (13:00 UTC).
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.
SQL 2016 Perform Volume Maintenance Task
This is a welcome addition to the install for SQL Server 2016 that I had not seen mentioned previously (you can find lots of posts about the new tempdb options, for example).
HOW TO: Change the Compatibility Level of an Azure SQL Database
Here’s an example of something I came across for Azure SQL Database V12 that I don’t see documented anywhere (yet): You can change the compatibility level of an Azure SQL Database.
SQL Server Identity Values Check
Very few users have any idea how many SQL Server identity values they have remaining on a column.
