SIOS SANless clusters

SIOS SANless clusters High-availability Machine Learning monitoring

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

by 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 16, 2015: SIOS is Proud to Sponsor The Detroit SQL Server User Group

by 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 13, 2015: SIOS is Sponsoring SQL Server User Group Atlanta — Atlanta MDF

by Leave a Comment

SIOS is proud to sponsor the Atlanta SQL Server User Group’s April meeting. If you’re in the area, I highly recommend checking out this month’s session “Dr. DMVs Troubleshooting Toolkit” presented by SQL Server MVP, Glenn Berry.

Register Now

Location: Microsoft – 1125 Sanctuary Pkwy. Suite 300 Alpharetta, GA 30009
Date: April 13, 2014
Time: 6:30 – 9:00 PM Eastern

Session Abstract

Dr DMVs Troubleshooting Toolkit

Dynamic Management Views and functions allow you to easily see exactly what is happening inside your SQL Server instances and databases with a high level of detail. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session presents, demonstrates and explains numerous DMV queries that you can quickly and easily use to detect and diagnose configuration and performance issues in your SQL Server instances and databases.

About Glenn Berry

Glenn works as a Principal Consultant at SQLskills in Parker, CO. He has been a SQL Server MVP since 2007. He is also an Adjunct Faculty member at University College – University of Denver, where has been teaching since 2000. He has completed the Master Teacher Program at Denver University – University College. He is the author of the book SQL Server Hardware. Glenn blogs regularly at http://sqlserverperformance.wordpress.com. He is active on Twitter as @GlennAlanBerry.

 

UPDATE: April 8, 2015: SIOS Sponsors San Francisco SQL Server User Group

by Leave a Comment

SIOS is proud to sponsor the San Francisco SQL Server User Group’s April meeting. If you’re in the area, I highly recommend joining month’s speaker Joel Champagne. He will be presenting, “Pretty Big Data in the Real World.”

Register Now

Date: April 8, 2014
Time: 6:30 – 8:30 PM
Location:

Microsoft Office
Bank of America Building
555 California Street, 3rd floor
San Francisco, CA

Cost: This is a free event – Food and Drinks will also be provided at no cost.

Note: This is the Bank of America building. If you have RSVP’d, the guard will give you access to the 3rd floor. In order to be approved by Microsoft security, you must RSVP with your first and last name, and bring photo ID with you.

March 11, 2015: SIOS is Proud to Sponsor the New England SQL Server User Group

by Leave a Comment

SIOS is proud to sponsor the New England User Group’s February meeting. If you’re in the area, I highly recommend checking out this month’s session “Do More With Less: SQL Central Management Server and SQL Agent” presented by SQL Server MVP and Database Administrator, Mike Hillwig.

Register Now

Location: Microsoft Technology Center, One Cambridge Center, Cambridge, MA
Date: March 11, 2014
Time: 6:00 PM

Session Abstract

Do More With Less: SQL Central Management Server and SQL Agent
Two of the of the most under-utilized management features of SQL Server are the Central Management Server and the SQL Agent Multi-Server Administration tools. The CMS is a powerful little tool creates a catalog of servers that allows you to execute any query or script against multiple servers at the same time. The SQL Agent Multi-Server Administration (MSX) tool allows you to create a SQL Agent job on one server and then deploy it to multiple servers instantly. When used in conjunction with each other, you have a powerful set of features that make managing your enterprise a lot simpler.

SQL Server MVP Mike Hillwig will show you how to to deploy these two powerful features right out of the box without writing a single line of new code.

About Mike Hillwig
SQL Server MVP and Boston resident Mike Hillwig is a senior DBA for a global financial institution. He’s been working with SQL Server since version 7. He’s got a background in infrastructure and networking. In his current role, Mike’s portfolio of SQL servers grows weekly, sometimes daily. He’s quite passionate about automating administrative tasks. You can follow him on Twitter (@mikehillwig) and at his blog, mikehillwig.com.