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 :)
Making PowerShell useful
SQL DBAs should be using Powershell. It will significantly aid them to make life easier. Knowing where to start and how to easily use Powershell in a Team setting can seem complicated at first.
By the end of the talk you will:
- Have learnt some good tricks to help you to start learning Powershell
- Gained some ideas of tasks you can use Powershell to assist you with
- Identified further resources
- Enabled your entire team to easily use the results of your learning.
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