SQLNorthEast (NEWCASTLE) SQL SERVER USER GROUP
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 or use it as an opportunity to ask for help with any issues that may arise at work.
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:30pm Round Table discussion and Nuggets - ALL
6:30pm - 7:30pm - Steve Powell (BIML: Spend less time with SSIS and more time with your Kids)
7:30 - 7:50pm - Break
7:50pm – 8:50pm - Steve Powell (Automating your ETL/Cube documentation)
8:50pm - 9:00pm - Feedback and Close
Finally: Drinks on the Quayside :)
Not many people have heard of BIML, even less have used it. IN this session we will demonstrate how to automate the dull repetition out of ETL/SSIS projects with the free BIML tools that come with BIDS Helper and outline how you can build a meta data driven ETL solution that's flexible, reliable and will save you time, so you can do something more interesting.
About Steve:Steve has been working with SQL server for longer than he likes to admit and developing code for longer still. He works as a BI trouble shooter for a health care oriented technology consultancy. He spends far too much time wrestling with recalcitrant servers and swearing at developers who think documentation is something that happens to other people, but it’s the only way he can fund his son’s ongoing Lego addiction.
There are many tricks for reducing the pain of documenting your solutions. Powershell, XML, extended properties and the use of liberal amounts of meta data can help reduce the time it takes to produce and eliminate the effort of maintaining it (almost).