Manchester SQL Server User Group

Manchester (UK) SQL Server User Group

Network, learn, ask a question, meet fellow SQL Server Professionals and have some pizza - these are all things that happen at user group events. These events are a really great opportunity to socialise in an informal learning experience. Remember to tell your friends and the people you work with.

For details of all up and coming meetings and to register for events, please see our Eventbrite page here  https://manssug.eventbrite.co.uk

Follow us on  Twitter manssug or Facebook Manchester User Group

Next Meeting: Wed, Sep 14 2016

Manchester PASS Chapter

Register Here : https://www.eventbrite.co.uk/e/pass-manchester-sql-server-user-group-14th-september-2016-tickets-26930657321?aff=es2

Network, learn, ask a question, meet other folk, get fed - these are all things that happen at PASS Chapter events. These events are a really great opportunity to socialise in an informal learning experience.

Remember to tell your friends and the people you work with; make sure you register as soon as you can.

 

17.30 – 18:00 Registration and networking

18:00 – 18:30 Round Table discussion and Nuggets - ALL Take stock and get the latest news in the SQL Server and Azure Data Platform field. This is also a great opportunity to ask any burning questions you have, may be a problem at work.

18:30 - 19:30 - First Session.

19:30 - 19:50 - Break. Time for pizza.

19:50 - 20:50 - Second Session.

20:50 - 21:00 - Feedback, Prize Draw and Close.

Finally: Drinks down the pub


Session 1

IoT Real-time Data Using Raspberry Pi Sensors

Speaker: Paul Andrew

Summary: The Internet of Things is the new kid on the block offering a wealth of possibilities for data streaming and rich analytics. Using a Raspberry Pi will we take an end to end look at how to interact with the physical world collecting sensor values and feeding that data in real-time into Azure services for manipulation and consumption. This will be a heavily demonstrated session looking at how such an environment can be setup using the Microsoft offerings including; Windows 10 IoT Core, Universal Windows Platform applications, an IoT Event Hub, Stream Analytics, Azure Table Storage and Power BI.

Session 2

Getting started with Powershell

Speaker Matthew Darwin

Summary: Do you spend your day running the same routine tasks?  Does it irk you when you do the same thing more than once?  I (sadly) still have to answer yes to one of those questions.  However, whilst I do still carry out some of the same routine tasks, learning Powershell has enabled me to automate the majority.

The potential for automation that Powershell brings, can have a huge impact on regaining precious time for a busy DBA.  The ability to create a codebase of cmdlets that sits outside your SQL Server instances allows you to introduce easy frameworks for standardisation, inventory collection and access to external processes that would be clunky in SSIS or require using the dreaded xp_cmdshell.

In this presentation, I’m going to demonstrate some of the features I use to make my life easier, from the basics of creating a Powershell profile and how different objects and inbuilt cmdlets work, to creating my own cmdlets and modules.  We’ll look at using the .NET SMO classes to create an all-singing-all-dancing-one-liner-dynamic-super-CREATE-DATABASE function; because, let’s face it, the CREATE DATABASE syntax sucks.  Lastly, we’ll look at some functions that will use the SMO to script up objects in your database, with twiddly annoying things like filegroups and partition schemes taken into account.  

Anyway, now you’ve got all this extra time, isn’t it your turn in the brew round?

Attachments

PASSChapterLogo.jpg

sql_micro_sm.gif

 rg-logo.png

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids