SQL Northeast SQL SERVER USER GROUP (#SQLNorthEast @sqlne)
**Register On Eventbrite Here**
Network, learn, ask a question, meet other folk, get fed - these are all things that happen at user group events. These events are a really great opportunity to socialise in an informal learning experience - if you want your own exposure then come and do a 1 - 5 minute nugget in front of your peers - Optional.
Remember to tell your friends and the people you work with; make sure you register as soon as you can.
5.30pm – 6:00pm Registration and networking
6:00 – 6:15pm Round Table discussion and Nuggets - ALL
6:15pm - 7:15pm - PowerShell Box of Tricks with Rob Sewell
7:15 - 7:40pm - Break
7:40pm – 8:40pm - Easier SQL Server Migrations using PowerShell with Stuart Moore
8:40pm - 9:00pm - Feedback and Close
Finally: Drinks on the Quayside :)
PowerShell Box of Tricks
The life of a SQL Server
DBA is a busy one. A fount of all knowledge, the SQL Server DBA is often
interrupted with small questions and routine tasks. This session will show you
some functions that you can use to save time spent on this and hopefully
inspire SQL DBAs to explore PowerShell further by showing how easy it is to
explore SQL Server properties with it.
Rob is a SQL Server DBA currently supporting several hundred databases ranging from SQL 2000 to SQL 2012 and including Ingres and Oracle for a government organisation. Rob has a fabulous beard and loves to use Powershell to make his life easier.
Easier SQL Server Migrations using PowerShell
MIgrating SQL Server to new hardware (real or virtual) can always be a challenge. Remembering to migrate all those little settings and critical objects can be a tricky task. Luckily PowerShell and SMO offer plenty of help.
In this sessions we'll look at using PowerShell to do the simple tasks like migrating your databases automatically, ensuring that all your logins and roles have moved across, and also scripting out objects like SQL Agent jobs and Linked Servers which often get forgotten.
Stuart has been working with SQL Server since 1998 and version 7, splitting the years between roles as a DBA and a Developer.
View http://www.sqlne.com for more information