Category Archives: SQL Server

QuickTip: Add Sql Server Module to PowerShell Console

To import the SQL Server PowerShell for SQL Server 2012 the following command can be typed:

Import-Module sqlps

For SQL Server 2008 the snap-ins have to be manually loaded as documented in the following the TechNet article: Running SQL Server PowerShell (2008).

It is important to note that when using the SQL PowerShell provider or any other non-filesystem provider that it is not possible to access network shares directly. For more information about this refer to my previous article:

SQL Server 2012 beta exams are available

Last week I received an invitation from Microsoft Connect for the beta exams and recently the promotional codes also have been posted on the Microsoft Learning Blog. So if you have been working with SQL 2012 and feel you have a shot at passing the exams you could try one of these promotional codes for a chance to participate in the Beta exam process. The exams run from the 23rd of March to the 13th of April. I have included the second unofficial list of codes in the table, so try both codes if it reports that the maximum number of seats has been booked.

Exam number

Promo code

2nd code

Exam 70-461: Querying Microsoft SQL Server 2012



Exam 70-462: Administering Microsoft SQL Server 2012 Databases



Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012



Exam 70-464: Developing Microsoft SQL Server 2012 Databases



Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012



Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012



Exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012