Topic: SQL Server Administration
Date: August 13, 2009 @ 6:00pm
Speaker: Bill Graziano
This session walks through a SQL Server installation, the post setup configuration, a basic security review, configuring a maintenance plan and basic performance monitoring. All with no PowerPoint slides. Instead we’ll walk through my SQL Server setup and configuration checklist and I’ll demonstrate everything I’m talking about. This session is great for new database administrators or part-time DBAs or anyone looking for a refresher. Experienced DBA’s will learn something too! You’ll get a copy of the checklist during the session and you’ll get a link to download a copy for later. Some of the interesting things you’ll learn during the session are:
- Why the Shrink Database maintenance plan task doesn’t really shrink the database. And why you shouldn’t shrink a production database anyway.
- Which database always needs its recovery model changed after installation?
- What free utility you can use for maintenance on the free Express Edition of SQL Server
- What is the most common mistake people make when configuring SQL Server Agent to send job notification failures
About Bill:
I’ve been a SQL Server consultant for ten years. During that time I’ve helped companies large and small solve SQL Server problems. I do production support, performance tuning and application development around SQL Server. This session covers the steps I go through to configure and maintain a SQL Server. I’m a SQL Server MVP. I serve on the Board of Directors for the Professional Association for SQL Server and I’m a regular presenter at their conference. I started a web site for SQL Server professionals at SQLTeam.com that 20,000 people visit every day. And I like to speak at user groups.
Location: Johnson County Community College (JCCC) Regnier Center
Sponsor: TBD
Topic: Changing Landscape of Data Security
Date: January 8, 2008 @ 6:00pm
Speaker: David Mertz
David is managing Partner with Compliance Security Partners, LLC, has spent the last six years immersed in compliance and data security issues. Whether the data security requirements are Federal - HIPAA, FACTA, FCRA, FTC, GLBA, State – 40 states have followed California’s lead, or industry based – PCI DSS, BITS, ISO 27000, Mertz has worked with clients in building and implementing efficient and cost effective information security programs. Mertz has been panelist on webinars discussing a wide variety of PCI related issues on behalf of Tripwire. Mertz has written article for a number of trade journals and speaks regularly at national and regional seminars regarding compliance and data security issues.
Location: Johnson County Community College (JCCC) Regnier Center
Sponsor: Power I.T.
Topic: Foundations for SSIS
Date: February 12, 2008 @ 6:00pm
Speaker: Matthew Crouch
Matt specializes in building Business Intelligence systems on Microsoft SQL Server platforms. Matt has over fourteen years of database management experience. Over the last 7 years has been architecting data warehouse and business intelligence solution. He is currently the Business Intelligence Architect at Midland Loan Services. His background includes SQL Server DBA, instructor at DeVry University, VB.Net, ASP, and ASP.Net; SQL Server Integration Services (SSIS); data warehouse development using SQL Server 2000 and 2005; IBM Websphere Datastage (ETL Tool); MicroStrategy (BI Tool), Oracle Business Intelligence Enterprise Edition OBIEE (BI Tool).
Location: Johnson County Community College (JCCC) Regnier Center
Overview:
Presentation "Establishing a framework in SSIS using templates and configurations" Moving to SQL Server Integration Services (SSIS) can be a daunting task, but setting up a framework before you start helps development. Understanding SSIS Configurations and some best practices on how to use them will assist in faster development. Using templates will also help establish standards and keep consistent audit functionality. Matt will review the different SSIS configurations, templates and standards he has developed on his latest SSIS Project.