Registering multiple servers in Central Management Server (CMS) using PowerShell Script

  Below are the steps using PowerShell script (learned from another Kalyan Yella, Microsoft): Step 1: Open notepad and copy and paste below PowerShell script and save the file as “RegisterServers.ps1”  at c:\scripts\   — you can save anywhere you want – just make a note of it as you will use this in next step…

1

Importing Data from MS Access 2010 64-bit .accdb database into SQL Server using SSIS

  Problem: You can’t connect using Native OLEDB \Microsoft Jet 4.0 OLEDB Provider.  It fails with following error message: Test connection failed because of an error in initializing provider. Unrecognized database format ‘C:\Users\vishah\Documents\myDB.accdb’. Solution: Download 2007 Office System Driver: Data Connectivity Components from here – http://www.microsoft.com/downloads/en/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en then choose Microsoft Office 12.0 Access Database Engine OLE…

6

Visio Forward Engineering to SQL Database

From SQLBI.com Visio Forward Engineer is an Office 2010 add in that provides Visio the ability to script the database creation of a data model. Even if it contains several limitations, it helps Office Visio users to create simple data models using the Visio interface without the need to install the older 2003 Enterprise Architect…

3