August 25, 2011 News Thursday: CTP of Hadoop Connectors for SQL Server and Parallel Data Warehouse, and more Server and Tools News!

 

 

by STB Blogger

Microsoft ships CTP of Hadoop Connectors for SQL Server and Parallel Data Warehouse
Today, Microsoft is announcing the availability of the Community Technology Preview (CTP) of two connectors for Hadoop: The first is a Hadoop connector for SQL Server Parallel Data Warehouse (PDW) that enables customers to move large volumes of data between Hadoop and SQL Server PDW. The second connector empowers customers to move data between Hadoop and SQL Server 2008 R2. Together, these connectors allow customers to derive business insights from both structured and unstructured data.  To learn more about these connectors or give them a test drive, visit the SQL Server Team blog today!

How to Recreate the SBSMonitoring Database
In SBS 2008 and SBS 2011 standard, a service called the Windows SBS Manager, is responsible for a number of tasks around monitoring, alert reporting and maintenance. This service relies on a SQL Server database running on a SQL Server Express instance called SBSMonitoring. Under certain circumstances, the database may become unusable; when this happens you can experience behaviors like the SBS console crashing, or incorrectly reporting the status of machines. As such, there might be a need to create a new, blank, database to regain functionality. For more tips and tricks on recreating these steps, visit The Official SBS blog.