September PASSMN Meeting &Newsletter
Sponsored by vRad
Checklists for Better Coordination and Performance of SQL tasks
Abstract: Complex, repeated tasks, from flying an airplane and removing an appendix to monitoring your SQL Server or installing an upgrade. Use checklists to ensure better and more consistent outcomes. Can checklists help get better results on something you do? The answer is probably YES. Given that, how do you develop an effective checklist and what should you include in it? Should you just google for the "best" checklist?
About Paula Merns: I have been working in IT since 1995 starting with help desk for Compaq Computers. In 2000, by way of Oracle, I switched to SQL Server support and database management. Since then I have worked as a developer primarily in SQL Server. Programming is a constant both scripting tasks and creating interfaces to databases for non-technical customers. I now work as Instructor and Programmer/Database Analyst for Dunwoody College of Technology. I also continue to take classes toward a Master's in Data Science at the University of St. Thomas.
Correlated Concatenation with XML
Abstract: Since SQL Server 2005, a popular method for concatenating values across multiple rows has been to use the built-in XML functions. Of course they work well for the simple case involving a single field, but with one small trick, they can be used to make multiple, correlated lists based on different fields.
About Riley: Riley Major is an Enterprise Architect at Manna Freight Systems, Inc., of Mendota Heights, MN. He’s been in the trenches with SQL Server for 14 years, focusing mostly on development and architecture. Riley cut his teeth on SQL Server 7, but has been on a syntactical sugar high since SQL Server 2005. He’s written or architected over a half million lines of SQL still in active use. Riley is particularly grateful that technology has saved him from having to use his law degree.
PASS Summit 2014
The countdown to the world's largest gathering of SQL Server and BI professionals starts now. Seattle, WA Nov 4-7
PASS Summit is your conference – planned and presented by the SQL Server community for the SQL Server community.
Join 5,000 SQL Server and BI Professionals from over 50 countries and 2,000 different companies to take your SQL Server skills to the next level!!
Save $150 using the PASSMN discount code. [USNCS28]
Questions for presenters
If you have any questions you would like our presenter to answer in the meeting, feel free to submit them ahead of time to email@example.com or to any of the board members before the meeting. All questions will be kept anonymous. read more ...