www.sqlpass.org    Professional Association for SQL Server

SQLPASS in Detroit (SPID)

 Looking for the Detroit IT User Group? Their site has moved to: http://detroititug.sqlpass.org

Thanks to all who attended SQLSaturday Detroit!

We have meetings on the second Thursday of every month.  Our group meets at the Microsoft Heartland District Office in the Southfield Town Center.  The office is on the 19th floor of the 1000 Building, and there are signs directing you to the conference room where the meeting will be held.

In an ongoing attempt to make the content presented useful to our members we start each meeting with a short Q&A session.  Unless noted in the meeting notes the schedule for each meeting will be:

6:00 - 6:30 - General Q&A session & Announcements
6:30 - 7:30 - Presentation(s)
7:30 - ?? - Door prizes and Question & Answer session

 Next Meeting


Top 10 Issues Identified by SQL Health Checks











Thursday, July 10, 2014

6:00 PM to 8:00 PM


Microsoft Southfield Office
1000 Town Center
Suite 1930
Southfield, MI 48075
Directions found clicking here.

Register at EventBrite - so we know how much food to order.

This meeting is sponsored by Datavail and Microsoft.




Andy McDermid


Andy is a MCITP certified MS SQL DBA who delivers and manages delivery of DBA services to many diverse clients. He enjoys helping his clients by finding and deploying pragmatic and practical solutions for their database issues. He has conducted dozens of health checks on a variety of client databases. Andy is always working to improve and expand his DBA skills and he likes to share the experience via writing. You can read more about his work here http://www.datavail.com/author/andy-mcdermid.








In a complex database environment, keeping tabs on the health and stability of each system is critical to ensure data availability, accessibility, recoverability, and security. Through performing thousands of health checks for clients, Datavail has identified the top 10 issues affecting SQL Server performance. From misconfigured memory settings to missing backups, Datavail has gathered evidence from client health check history that identifies the most common issues DBA managers must correct for optimal database performance. Datavail’s SQL Health Check is used not only as a diagnostic tool but also a road map of the work that needs to be performed. From there, routine health checks have proven to improve database performance. SQL Server Senior DBA for Datavail Andy McDermid will share the top 10 issues, the consequences of not taking action, and why consistent use of a SQL Server Health Check in conjunction with ongoing database management can lead to improved database environments and maximize the investment of time and resources
 Contact Info

I have set up an e-mail address for SEMSSUG related issues, so it doesn't  generate as much traffic to my work e-mail account.  Please send any questions, concerns, etc to Joseph.Fleming@sqlpass.org 

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.











  Intertech .NET and Java Training