Archives for April 2015

April 21, 2015: SIOS Sponsors Baltimore SQL Server User Group

April 1, 2015 by Margaret Hoagland Leave a Comment

SIOS is proud to sponsor the Baltimore SQL Server User Group’s April meeting. If you’re in the area, I highly recommend checking out this month’s session “Performance Troubleshooting Using Wait Statistics” presented by SQL Server MVP, Paul Randal.

Register Now

Location: Howard Community College — Charles I. Ecker Business Training Center
6751 Columbia Gateway Drive, Columbia, MD
Date: April 21, 2014
Time: 6:30 – 9:00 PM Eastern

Additional Information: Baltimore SQL Server User Group

Session Abstract

Title – Performance Troubleshooting Using Wait Statistics

One of the first things you should check when investigating performance issues are wait statistics – as these can often point you in the direction for further analysis. Unfortunately many people misinterpret what SQL Server is telling them and jump to conclusions about how to solve the problem – what is often called ‘knee-jerk performance tuning’. In this session, you will learn what waits are, how to analyze them, and potential solutions to common problem patterns.

April 18, 2015: SIOS Sponsoring and Presenting at SQLSaturday Boston

April 1, 2015 by Margaret Hoagland Leave a Comment

Register Now for SQLSaturday Boston
When: Saturday, April 18, 2015
Where: Microsoft Conference Center, Kendall Square, 1 Cambridge Center, Cambridge, MA 02142
Cost: $10 to cover the cost of lunch, the event itself is free

SIOS is proud to sponsor SQLSaturday Atlanta. Be sure to visit the SIOS table for your chance to learn more about our SAN and #SANLess solutions, enjoy some candy and drop off your raffle ticket for your chance to enter our end of day $100 Amex raffle. There are a number of great tracks so be sure to plan your schedule well in advance (schedule). Also be sure to join our “Clusters Your Way™” lunch session presented by Microsoft Cluster MVP Allan Hirt.

April 16, 2015: SIOS is Proud to Sponsor The Detroit SQL Server User Group

April 1, 2015 by Margaret Hoagland Leave a Comment

SIOS is proud to sponsor the Detroit SQL Server User Group’s April meeting. If you’re in the area, I highly recommend checking out this month’s session, “Updating Statistics Affects Query Performance More Than You Think,” presented by Erin Stellato, Principal Consultant SQLskills.com. Visit detroit.sqlpass.org for additional information.

Register Now

Location: Microsoft, Southfield Town Center, 1000 Town Center Dr., Suite 1930, Southfield, MI 48075
Date: April 16, 2014
Time: 6:00 PM – 8:00 PM
Cost: This is a free event, food and refreshments will also be provided at no cost courtesy of SIOS Technology.

Session Abstract

Stop me if you’ve heard this one, “This query is slow, let’s update statistics.” But what does updating statistics *really* do to your query performance? And is it the right solution? While updating statistics may provide a short-term solution, it can bury the true root cause. If you’re not familiar with what happens to query plans when you update statistics, then don’t miss this session. We’ll set the stage with a review of what statistics are, how the optimizer uses them, and discuss the various ways you can update them. Then we’ll explore what happens to plans when you *do* update statistics, and you’ll see why that might not always be the right long-term solution

About Erin Stellato

Erin Stellato is a Principal Consultant with SQLskills and lives in Cleveland, OH. She has over 12 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include internals, performance tuning, and high availability and disaster recovery. Erin is a SQL Server MVP and an active member of the SQL Server community. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.

April 14-15 2015: SIOS is Sponsoring and Attending POSSCON 2015

April 1, 2015 by Margaret Hoagland Leave a Comment

SIOS is proud to sponsor Palmetto Open Source Software Conference (POSSCON). If you’re in the area, I highly recommend joining this two day event. POSSCON brings a lineup of leading IT leaders to the Southeast for 3 days to discuss the latest issues for developers, executives, government leaders and educators. In addition to the educational value, this is also a fantastic place to network, learn and meet leading technology leaders and companies.

Stop by the SIOS booth to say hello, learn about new job opportunities with SIOS, and take part in our SIOS iQ UI usability study. Study participants will receive a Starbucks gift card and be entered into our usability final prize draw for a chance to win something great!