June PASSMN Meeting – Filegroups

Sponsored by Virteva

Meeting Details

• Location: 3601 West 76th Street, Suite 600 Edina, MN  55437
• Date: June 19, 2012
• Time: 4:00 PM – 6:00 PM
• Live Meeting:
• URL:  https://www.livemeeting.com/cc/usergroups/join?id=C2HWT7&role=attend&pw=Jf%25GD%3D9%5EJ
• Meeting ID: C2HWT7
• Entry Code: Jf%GD=9^J

Please click here for meeting details and to RSVP

The What, Why, and How of Filegroups

Jes Schultz Borland, Brent Ozar PLF

Every DBA must know how to create and maintain filegroups because they affect performance, maintenance, and security of your data. What are filegroups, and how do you use them? In this session, I’ll show you how to create filegroups, create objects in them, move objects to them, perform maintenance, and walk through piecemeal restores.

Jes Schultz Borland (B/T) is a Consultant with Brent Ozar PLF, and a Microsoft SQL Server MVP. She holds an AAS – Programmer/Analyst degree, and has worked with SQL Server since 2007, focusing on Reporting Services and day-to-day administration. She is an active member of PASS, Director of Communication for MADPASS, founder of Tech on Tap, and LessThanDot.com blogger. She’s a frequent presenter at user groups, SQL Saturdays, and other community events. She is also an avid runner and chef.

Managing Daylight Savings without CLR

Rick Krueger, Premier Applications Inc

Dealing with Daylight Savings is often an afterthought, but can cause major system issues if ignored. Learn how an SSIS package can keep a lookup table with TimeZone information up to date, allowing DateTime conversions as needed.

Rick Krueger, President, Premier Applications Inc (B/T)is a SQL Server indie based in the Twin Cities with 17 years of software and database development experience, working with SQL Server since 1998 (6.5). Don’t let his developer credentials (MCPD) and background fool you, he knows a thing or two about SQL, and is currently focusing on Development DBA work. Rick has recently started tweeting as @DataOgre to get more involved in the SQL Community.