SQL Server 2008 R2

Systems Engineering and RDBMS

SQL Server 2008 R2 Editions MSFT has introduced two new editions in SQL Server 2008 R2: SQL Server 2008 R2 DataCenter, and SQL Server 2008 R2 Parallel Data Warehouse You can read more on these here: http://www.microsoft.com/sq...

Systems Engineering and RDBMS

SQL Server 2008 R2 Utility SQL Server 2008 R2 has introduced SQL Server utility as part of it’s multi-server administration enhancements – it is the center of operations for consolidating and monitoring the managed ...

Journey to SQL Authority with Pinal Dave

SQL SERVER – StreamInsight and SQL Server 2008 R2 I was recently called into create POC (Proof of Concept) for a project which was being planned for use StreamInsight. When I was there, I was also asked to give overview of the this feature to their C...

Systems Engineering and RDBMS

SQL Server 2008 R2 BPA SQL Server 2008 R2 Best Practices Analyzer is available now and can be downloaded from here.  Here is the overview information from that page: The Microsoft SQL Server 2008 R2 BPA is a diagnostic tool...

Systems Engineering and RDBMS

SQL Server 2008 R2: DAC SQL Server 2008 R2 has a lot of new features and we will be covering some of them in the upcoming posts.  One of those features is DAC – Data Tier Applications.  This is not to be confused with ...

DotNetShoutout - Latest published stories

Restoring SQL Server 2008 R2 Backup file with SQL Server 2008 Recently i had to restore a SQL Server 2008 R2 Database to a Database in another machine and i ended up getting the message “The Database was backed up on a server running version 10.50.1600. That ver...