A collection of 26 free stand-alone tools, components and frameworks has been released. This collection is designed to enhance using and developing for SQL Server 2008 as well as other versions of SQL ...

Support for SQL Server 2008 and 2008 R2 ended on July 9, 2019. That means the end of regular security updates. However, if you move those SQL Server instances to Azure or Azure Stack, Microsoft will ...

Comparing cursor vs. WHILE loop performance in SQL Server 2008 Your email has been sent Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option ...

Note that you always need CommandExecute; DatabaseBackup, DatabaseIntegrityCheck, and IndexOptimize are using it. You need CommandLog if you are going to use the ...

Ahead of Microsoft Build (and a possible SQL Server announcement), let's break down what we know and speculate about what we don't. One topic that has come up in several conversations with customers ...

Sometimes we need to change database name because the original name was based on the project that has become irrelevant to the data stored into the database or you had given temporarily name before ...