Posts by Arthur Daniels

Upgrading your database to vNext

Target Audience: DBAs and developers who want to prepare for the database changes in vNext Abstract: Moving an old database to a new SQL Server version enables improvements that Microsoft’s SQL Server team has added over time. Before you explore the new T-SQL features, take a look at how your database will change as it’s…
Read More

The Perfect Index

Target Audience: Database Administrators or Developers who want to create useful and thoughtfully designed indexes Abstract: Creating indexes is one of the most powerful ways to improve performance in your SQL Servers. It’s not easy to form indexes for a large and complicated query, and things only get more complicated when queries can come from…
Read More