Monthly Archives: January 2012

Powershell script to run query against many servers and send combined output as email


This powershell script is sample code to run query against multiple SQL Servers and export the combined output to Excel. This Excel file is later sent as email attachment using hotmail. Related email thread: http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/987d48c0-a82d-4424-8699-cdd0b2bc9c51 # This posting is provided

Posted in SQL Power shell

SSIS in SQL 2012


http://blogs.msdn.com/b/mattm/archive/2011/11/17/what-s-new-in-ssis-for-sql-server-2012-rc0.aspx

Tagged with:
Posted in Uncategorized

SQL Server 2012 Express LocalDB


  Highlights: – Small download footprint – Very quick installation – Simple Installer – No installer options – (Just Accept EULA)   About LocalDB: http://blogs.msdn.com/b/sqlexpress/archive/2011/11/28/simple-installer-for-localdb-has-shipped.aspx   Download LocalDB 1) Goto : http://www.microsoft.com/sqlserver/en/us/editions/express.aspx , click on “Download 2012 RC0 EXPRESS”  

Tagged with:
Posted in LocalDB, SQL Server