Big Brother is Watching -Monitoring your Servers
- How do you know your server is operating efficently?
- What is your backup/restore strategy?
- Have you really tested it
- Is the indexing strategy optimized for the changing workload?
- How do you identify sub-optimal queries?
- What kind of operational data can you provide the Dev teams so that performance can be improved?
This is intended to be a open discussion about free and home brewed solutions to monitor production SQL Servers. Arnie will demonstrate several built-in and free options, and also discuss the benefits of a few third party monitoring products. Please bring your experiences and suggestions to add to the conversation.
Arnie Rowland (Blog | LinkedIn) is an Independent Consultant and Trainer, working with Microsoft SQL Server. He hs been designated a Microsoft MVP for SQL Server for five years. He founded and regularly facilitates the Oregon SQL User Group and is a co-founder of Portland Code Camp. Arnie specializes in mentoring development teams on topics related to optimizing their efforts to access data stored in SQL Server. Arnie is a frequent speaker at user groups, SQLSaturdays, TechDays, and has spoken at many conferences, including SQL Pass and TechEd.
Show ‘n’ Tell on my SQL Server high-performance “Rabbit-out-of-the-hat” trick
Dennis will talk about a SQL coding technique he used recently in a high-volume messaging system for his company that improves performance and helps to optimize stored procedures requiring dynamic configurable settings. Hey, Scalar functions could be just the “Rabbit” you need for your next project or band-aid implementation.
Dennis will also cover a few differences between SQL 2005 and SQL 2008 and 2012 regarding reading execution plans and analyzing performance.
Dennis Parks currently works as a Senior Software Engineer at Kryptiq in Hillsboro, Oregon. He has worked as an independent consultant providing businesses in the Portland area with custom software and database solutions for over 30 years. Dennis graduated from Oregon State with a Bachelor of Science in computer science and holds the following Microsoft certifications: MCSE, MCSD, MCDBA, MCAD, and MCPD. He has been working with SQL Server since 1996.
Refreshments graciously provided by Apex Systems, Inc..
Jobs, Jobs, Jobs …
- The SQL Server related job market has really taken off in the past few months. Currently, there are approximately 20 open positions (Admins, Developers, BI -from entry to advanced skills) in the Oregon/SW Washington region. Check out the Oregon SQL Jobs page. Tell your friends and colleagues to regularly visit the Jobs page.
Featured Sponsor: Apex Systems, Inc.
- Apex Systems is an IT staffing and workforce solutions firm. We specialize in providing IT professionals for contract, contract-to-hire, and direct placements.
At Apex, you’ll find people you can trust, who will shoot straight with you. They will return phone calls, make courtesy calls, give closure, take you to lunch, walk you in on the first day, and give prompt response to issues. We put a lot of effort into hiring the right people for you to interact with, and we ensure you’ll notice the difference. For more information, visit Apex Systems, Inc.
We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously sponsoring the meeting venue.