Welcome to the Salt Lake City SQL Server Users Group!
We are based in Salt Lake City and meet once a month for 2 hours. We meet on the 2nd Monday of the month at the Doty education center at the Intermountain HealthCare hospital complex in murray. When: 2nd monday of every month 3:00-5:00p.m. Location: Doty Family Education Center 5121 So. Cottonwood Street Murray, Utah Contact: Pat Wright Sqlasylum@gmail.com If you have any questions about the group/site
This is our new home and if you are a member of our old site, you will need to quickly re-register so that we can have the new list and this will be maintained for the newsletter and announcements.
Thanks for your support of the group.
May Meeting
The SLC SQL Server User Group meeting for May
Event Date: Monday, May 13, 2013
Schedule: 3:00 pm - 5:00pm
SQL Byte Topic: Row Count Addiction: Getting a Good Fix, Fast
Speaker: Dandy Taylor
Description: When we start with SQL, we learn the ubiquitous COUNT (*) option, which I like to call a Scan Count. For most of us, it is the method we fall back on whenever we need a quick count. However, there are other ways to get a row count. A couple of years ago, Kendal Van Dyke (blog|twitter) posted a piece about getting row counts off of the sys.indexes system view. Then last month, Ritesh Shah (blog|twitter) posted how to do a similar count off of the sys.partitions and sys.allocation_units system views. Since both methods use the system views, let’s call these System Counts. For fun, I tested both Scan Counts and System Counts for speed and accuracy, so let’s look at the results.
Main Presentation: SMO Internals for High Performance PowerShell
Speaker: Ben Miller
Description: Ever wanted to know what happens in SQL Server when you use PowerShell and SMO to manage a SQL Server? How fast can your automation really go? I will take you through the most common objects in SMO and the internals of what happens when you use those objects. We will examine the TSQL that is generated, and learn techniques that lead to high efficiency. We will dive deep through the collections that make SMO the powerful tool it is. Combining the flexibility of PowerShell and SMO Internals is a recipe for awesome sauce. Come peek behing the curtain and squeeze the speed out of your automation scripts using PowerShell and SMO. You'll be glad you did.
Doty Family Education Center
5121 So. Cottonwood Street
Murray, Utah
Location on a map:
http://binged.it/pyD5xu
Recent Content
-
Speaker: Dandy Taylor Description: When we start with SQL, we learn the ubiquitous COUNT (*) option, which I like to call a Scan Count. For most of us, it is the method we fall back on whenever we need a quick count. However, there are other ways to get a row count. A couple of years ago, Kendal Van *** (blog|twitter) posted a piece about getting row...