I am very happy, honored and missing words to thanks my good friend Andre Kamman (and all the SQLRally Amsterdam board) by the invitation to present a Pre-Conference in SQLRally Amsterdam on October, 2th.
The SQLRally will be on 2th,3th and 4th October. My pre-con will be on 2th. 8 hours of pure PowerShell and SQL Server.
It will be just AMAZING return to the Wonderful Amstedam and the gentle people live there, also see the #sqlfamily Europe again. I am very excited
Hope to see you there.
Mastering PowerShell for SQL Server
Some people say magic, others say supernatural. I’d prefer to say top technology. That’s what PowerShell is today for the Microsoft stack. An Advanced technology built into the top of the operability of windows based operating systems , which allow us to a complete automation platform based, or not, on scripts. But what’s its relationship with SQL Server ? What can I really run , automate and manage in the SQL Server using PowerShell ?
If you are looking for those answers, this course is for you .
It will be split into 2 parts : The first with basic / intermediate fundamentals of programming in PowerShell , as using variables, what are hashtables , custom tables , custom objects , pipeline, script modules , functions , advanced functions and their attributes and many other concepts .
In the second part , we will see the host of PowerShell in SQL Server ( SQLPS ) , what is SMO, how to use it and how to create your framework to SQL Server using the concepts we’ve seen .
Prepare yourself for a full day of deep PowerShell coding, concepts , fundamentals and lot, but a lot of magic.