Data MulchYou have a new assignment – you must write code that will import data into your elegantly designed, highly sophisticated and simply beautiful database. You take one look at the design of the source system – the one you need to import - and tell your boss “This data stinks!” Later that day your boss paraphrases your feelings to corporate executives. “He said it is fertilizer and the flowers will smell wonderful.” Your job now is to be the Fabreeze to this outhouse of data. If your job involves any sort of data transfer, sooner or later you will come across a system filled with bad data, errors and simply awful design that you need to move into your well designed database. This talk, aimed at junior and mid-level developers, will examine just some of the tools that are useful for mulching the contents of this Augean stable and turning it into a wonderful garden.
This month's speaker is sponsored by Pragmatic Works.
What Are We Waiting For? SQL Server captures and records wait statistics data for passive and active tasks. Specific Waits can be considered acceptable in one environment yet can be a point of contention in another. This presentation will help guide you to the use of SQL Waits and Queues to monitor your environments and to research potential performance problem areas of an instance.
Kimberly Hathaway is a senior database consultant with experience across several database management systems platforms. She specializes in troubleshooting errors and performance, managing multiple clients in Database services, provisioning SQL Health Assessments, Developing project plans, Upgrading SQL platforms, recommending and implementing High availability solutions, and developing SQL solutions for business needs. She also has hands on experiences with aspects of the Microsoft BI stack including SSIS, SSRS, and Excel Reporting. She is committed to providing quality end to end solutions to each and every business problem. She is continually expanding her skillset with new technologies and gives back to the community through speaking at events.
As usual, we will make time for question and answer sessions, networking, and eating. Prizes will be awarded at the conclusion of the meeting.
Location:Microsoft7595 Technology Way, Suite 400Denver, CO[masked])[masked]
Meeting Agenda:17:30 - 18:00 - Food / Socializing18:00 - 18:15 - User Group Business18:15 - 18:30 - Open Panel/Questions & Answers18:30 - 19:00 – Warmup presentation19:00 - 20:00 – Main presentationGive Away / Wrap-Up to follow
Pass it on:If you feel that a friend or colleague would benefit from our user group, please feel free to forward on this notice. If you received this notice from a friend or colleague, please consider becoming a member of our user group. There are no dues to membership but you will have the added benefits of receiving event reminders and attendance to members only meetings. Becoming a member is quick and painless, simply go to the user group web site and register. http://denversql.org/ That’s it!
SpeakerRate:We're now using SpeakerRate to help our presenters get feedback on their presentation! Sign up is not required to participate! The Denver SQL Server User Group can be found at http://speakerrate.com/series/199-denver-sql-server-user-group. Both the board and the speakers thank you in advance for your help in developing our speaker base!