System and database administrators are now being forced to do something about legacy SQL Server 2008 and 2008 R2 database applications. The reason is the end of Extended Support in July 2019. Extended ...

To take advantage of SQL Server 2008's new features, you need to plan ahead and prepare to make sure your database servers are ready. Migrating to a major platform like SQL Server 2008 takes ...

The first upgrade to SQL Server 2008 R2 is now available for download from Microsoft. Customers running Microsoft’s data platform can head over to the Download Center and grab SQL Server 2008 R2 ...

Officially launched in February 2008, but released to manufacturing in early August, SQL Server 2008 is already at the top of the data warehousing and transaction processing game worldwide. The ...

Because SQL Server manages security identifiers (SIDs) for any user logging into SQL Server, you risk "orphaning" users when you do a restore. It's a common problem, and here's why. Typically, ...

SQL Server has supported VLDBs (very large databases) for some time now. Back in the SQL Server 2000 days, I recall hearing multi-terabyte databases were unusual but doable. Now, they are commonplace, ...

Joel Snyder, Ph.D., is a senior IT consultant with 30 years of practice. An internationally recognized expert in the areas of security, messaging and networks, Dr. Snyder is a popular speaker and ...

Microsoft will end Extended Support for SQL Server 2008 and SQL Server 2008 R2 on July 9, 2019. IT teams still running either version should start planning their migration strategies now to ensure ...

Early discussions on SQL Server 2008 seemed to suggest that it would really only be a point release, quite unlike what occurred with SQL Server 2005. Anyone looking at the new and upgraded features in ...

Microsoft has made some big promises for SQL Server 2008, a major update of its enterprise database product. No precise date has yet been announced for the launch, but the new features have caught the ...

.NET database syncronization component for MS SQL Server 2008 includes the library of components and the utility created for developers and administrators working with MS SQL Server 2008. According to ...