PASSMN August 18, 2009 Monthly Meeting
Posted by denglishbi on August 4, 2009
Update (8/11/2009): Meeting moved back to 9th Floor 8300 Building
The next PASSMN Minnesota SQL Server User Group meeting is coming up. The meeting is on Tuesday, August 18 from 3:00 PM to 5:15 PM. You can visit the local site to get registered at http://www.mnssug.org or click the link to Register Here. This month the meeting is in a different location –> 2nd Floor Classroom – 8000 Building 8000 Norman Center Drive, Bloomington, MN.
This month the topics are:
Discover and Manage SQL Server in the Enterprise (Speaker: Lara Rubbelke, Microsoft) – Do you know where SQL Server is installed in your enterprise? Are you absolutely sure you know? Really? Are you looking for a free tool to help you learn where SQL Server is installed? Once you know, are you looking for a better way to manage all of the instances in your enterprise? Learn how to leverage SQL Server 2008 features and enhancements complemented with free tools to discover and centrally manage all of the SQL Server in your enterprise. This session will dive deep into the Microsoft Assessment and Planning Toolkit and the Central Management Server, with a special focus on configuring, securing and leveraging the CMS for multi-instance management and configuration.
Lara Rubbelke brings her passion for architecting, implementing and improving SQL Server solutions to the community as a Technology Specialist for Microsoft. Her expertise involves both OLTP and OLAP systems, data management, performance tuning, encryption, ETL, and the Business Intelligence lifecycle. She is an active board member of the local PASS (Professional Association for SQL Server) chapter and regularly delivers technical presentations at local, regional and national conferences, user groups and webcasts. Lara authored the Microsoft whitepaper detailing SQL Server 2005 Enterprise Edition features and was a contributing author of "Expert SQL Server 2005 Development". Prior to joining Microsoft, Lara was a Microsoft Most Valuable Professional (MVP).
Syntactic Sugar Sweetens the SQL Server Pot (Speaker: Mark Knutson, Hennepin Faculty Associates) – Among the many new features of SQL Server 2005 were some SQL additions that both improve performance as well as simplify complex queries. I have used these countless times and found them quite handy. These include Common Table Expressions, the analytical ranking functions, and aggregations. I will discuss how these work and provide some SQL examples.
Mark Knutson is the Senior Internet Architect at Hennepin Faculty Associates. In this capacity, he administers SQL Server and Oracle database servers, SharePoint Services, IIS, and Hyper-V virtualization server. He also leads a small development team which creates web applications using .NET and C#, and is working on the Cisco CCENT/CCNA certifications.