Tag Archives: SQL

Recap of DuPSUG 11 – New Year edition


For us at DuPSUG, the Dutch PowerShell user group, 2018 is our sixth year and to start off the year we organized our first iteration of DuPSUG this Wednesday at Tools4ever in Baarn.

At the Dutch PowerShell User Group we are ready to kick off 2018 in style, by organizing another iteration of our user group. We have an evening crammed with sessions ready for you, and we look forward at seeing you there.


For this event we had the following three speakers:

  • Jaap Brasser
  • Sander Stad
  • Tjeerd Seinen
18:30 19:00 Jaap Brasser Implementing Chat Automation with PowerShell
19:00 19:30 Sander Stad Simplifying Log Shipping using dbatools
20:00 20:30 Tjeerd Seinen  Identity and Access management


To give you an impression of the event, here are some photos we have taken during the event and gathered from social media:


Slides & Code

The code and presentations have been shared on the DuPSUG GitHub in the DuPSUG 11 repository:
DuPSUG 11 – New Year edition


MS Cloud Summit Paris – Slides and Code

On the 23rd of January I had the opportunity to speak at the MS Cloud Summit Paris pre-conference. Together with the dbatools / dbareports legends, Chrissy LeMaire and Rob Sewell we covered an entire day of PowerShell, Azure and SQL Server. The event itself has been really great and well organized, so I would like to thank the organization for putting together such a fantastic event for the European technical community!

As always I have made the code and slides available on GitHub, so if you are interested in the content that I delivered have a look over here:

GitHub – Jaap Brasser – Events – MSCloudSummitParis2017

For more information about the event please visit the following links:

MS Cloud Summit Paris 2017
GitHub – Slides and code
MS Cloud Summit Paris website
MSCloudSummit – Speaker page – Jaap Brasser
MSCloudSummit – Twitter



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