sqlsat269_webHaving had such a great time at last years SQL Saturday in Exeter, I was very happy to see the SQL Southwest team announce another one for 2014 on Saturday 22nd March (Register here).

So, I’ve been offered the chance to present 2 consecutive sessions covering 1 topic, 100 minutes to fill with something new. I’ve decided that based on feedback and questions from my “Using PowerShell for Automating Backups and Restores with PowerShell” presentation I’ll be filling the 100 minutes with:

PowerShell for the curious SQL Server DBA

These sessions will be aimed at the SQL Server DBA who’s head of PowerShell but never really explored it. Perhaps you’ve been trying to follow examples online but not quite following it all. Or perhaps you want to be able to check those scripts a little better before you run them, or a little more insight on how to adapt them for your own environment and usage.

Current thinking is that the session will start from the basics of general PowerShell usage, with the following topics

  • What is PowerShell?
  • Do I have it?
  • What tools and Development Environments are there?
  • Basic CmdLets
  • The Pipeline
  • Variables and Objects
  • Control Structures
  • PowerShell Providers and Drives
  • Adding functionality via modules and .Net assemblies

Don’t worry, there’s still a coffee break after 50 minutes! And then we’ll come back and cover some more SQL Server focused topics:

  • What SQL Server support does PowerShell offer, and vice versa.
  • SQL Server access via PS drives
  • SQL Management Objects (SMO) access to SQL Server
  • Server Reports
  • Backups
  • Restores
  • Migrations

By the end of both sessions you’ll have a better understanding how PowerShell works, how it fits into Microsoft’s vision and how it works with SQL Server. Anyone who attends will be able to take the examples, and feel confident that on Monday morning they could put them to use at work understanding what they’re doing, and with enough knowledge to extend them to more complex examples.

Remeber, as it’s a SQL Saturday event, all the sessions on the Saturday are Free! And there’ll be lots more top quality speakers and subjects to fill up the rest of your day. Spaces are limited, so please register as soon as possible to avoid disappointment (SQL Saturday Exeter 2014 Registration)

If you’ve any questions about the session, please just drop me a comment here or over on twitter.

Would also be glad to hear about the sort of things you’d like to see, or perhaps share the areas you wish you’d had some more information about when you started with PowerShell and SQL Server. Everyone starts from a different background and I’d like to be as inclusive as possible.