I realized after reviewing the past few posts that I omitted a new piece of functionality introduced in SQL Server 2008 R2. This feature, known as Extended Protection for Authentication (Extended ...

One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or ...

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 ...

The company is rolling out in early 2017 Windows Server Premium Assurance and SQL Server Premium Assurance , which add six more years of support beyond the current 10. During the six years of Premium ...

Whether you call it Windows Server 2008 R2 or Windows Server 7, there's no doubt that this is a major Server product release for Microsoft. I'm not sure why Microsoft decided to deviate from the ...

I had the opportunity to work with Windows Server 2008 R2 for over 2 years before its release at the end of 2009 implementing the product in a couple dozen very large early adopter enterprises, and ...

Lansweeper has issued a stark warning to enterprise administrators regarding the looming issue of outdated Microsoft SQL Server instances. Company Chief Strategy Officer Roel Decneut revealed (via The ...

Microsoft complements its relational database engine, SQL Server, with several add-on services that manage different aspects of enterprise business intelligence and information processing such as data ...

SQL Server Management Studio or SSMS allows you to connect to the SQL server and execute queries. In this tutorial, we will see how you can install and configure SQL Server Management Studio in ...