Event Archive

Meeting Archive

 Meeting Archive

May 2013 Meeting

Topic:        

Locks, Blocks & Isolation Levels, Oh My!

Date:

Friday, May 10, 2013

 

 

Speaker:

 

 

 

 

Keith Tate

Keith Tate is a Senior Database Administrator with over 14 years of experience as a data professional. During Keith's professional career he has been a developer, DBA and data architect. Keith is also active in the SQL Server community and is currently the chapter leader of the Albuquerque SQL Server User Group. 
   

 

Overview:

 

 

 

 


 

Have you ever seen or used “WITH (NOLOCK)” in T-SQL? Do you know what it does and its side effects? Is SQL Server optimistic or pessimistic when it comes to locking? Can it be both? In this session we will cover these questions and discuss how and why SQL Server takes locks and how that affects other users. We will go over alternatives for using NOLOCK and discuss when it is appropriate to use. In addition, we will discuss what are the ACID properties and how to monitor locks and blocks.

Locks, Blocks & Isolation Levels, Oh My!

Demo Scripts

October 2012 Meeting

Topic:        

Common Issues with SSRS

Date:

Friday, October 12, 2012

 

 

Speaker:

 

 

 

 

Malek Annabi

Malek Annabi started his IT Career on the front lines in customer support almost 20 years ago, bounced around a few different areas of focus within IT and ended up as a Business Intelligence Developer.  Among other things, he’s been working with Microsoft SQL Server for the last 5 years and with SSRS for the last 3.

 

 

   

 

Overview:

 

 

 

 


 

Do you find yourself fielding questions about SSRS report problems?  Errors?   Slowness?  Formatting Issues? This presentation will examine some of the more common problems you might encounter with an SSRS report and give you the information needed to troubleshoot them.  The focus will be on 2008R2 with SSRS in Native mode for most of the talk and will be presented via PowerPoint.

September 2012 Meeting

Topic:  Slowly Changing Dimensions

Date:  Friday, September 14, 2012

 

 

Speaker:  Ron Beatty

Ron Beatty is currently a Business Intelligence Developer with Sun Healthcare Group in Albuquerque, NM. Ron has been in the trenches developing software solutions with Microsoft technologies for over 10+ years, with 7 years spent as a SQL Server developer. Ron has been working with the Microsoft BI Stack since SQL Server 2005, specializing in SQL Server Analysis Services, data warehousing, and MDX.
Ron has a Bachelor’s degree from UNM in mathematics and a Master’s degree from UT in BiomedicalSciences.

 

 

Overview:

How to handle and track changes in a dimensional is an important dimensional modeling consideration.  The dimension tables in the data warehouse need to be designed to appropriately store a history of changes as they have occurred.  The ETL processes need to detect changes and correctly update the dimensional table while preserving historical accuracy.  Finally, fact records need to be associated with the correct historical version of the dimension member for consistent reporting.  In this presentation, a brief introduction to the types of Slowly Changing Dimensions (SCD) will lead to a sample dimensional table design.  This will be followed by an in-depth demonstration employing SQL Server Integration Services (SSIS) to create an ETL data flow which will load a dimensional table with both Type 1 and Type 2 dimensional attributes.

 

 

 

August 2012 Meeting

Topic:  Make Your Voice Heard

Date:  Friday, August 10, 2012

 

 

Speaker:  Jes Shultz Borland

Jes Schultz Borland is a Consultant with Brent Ozar PLF, and a Microsoft SQL Server MVP. She holds an AAS - Programmer/Analyst degree, and has worked with SQL Server since 2007, focusing on Reporting Services and day-to-day administration. She is an active member of PASS, President of FoxPASS, founder of Tech on Tap, and a LessThanDot.com blogger. She's a frequent presenter at user groups, SQL Saturdays, and other community events. She is also an avid runner and chef.

 

 

Overview:

 SQL Server professionals like to talk - a lot. We blog, we tweet, we answer forum questions, and more. Add your voice! Learn about the different ways you can share your experience and knowledge. Once you start teaching others, you'll realize how much knowledge you have! 

 

July 2012 Meeting

Topic:  Eating the Elephant: SQL Server Table Partitioning

Date:  Friday, July 13, 2012

 

 

Speaker:  Mike Fal

Mike Fal is a musician turned SQL Server DBA, with 10+ years of experience as a database administrator. He has worked for several different industries, including healthcare, software development, marketing, and manufacturing and has experience supporting databases from 1 GB to 4 TB in size. Mike received his a Bachelor's Degree from the University of Colorado at Boulder in 1996 and has been caught playing trombone in public on more than one occasion.

 

 

Overview:

 

 Is your table fat? Do you need to manage a table that has billions of rows within it and are overwhelmed by index rebuilds that take more than 12 hours? SQL Server's table partitioning gives the DBA the tools to manage this beast and support very large tables in a way where index management and data retrieval does not become unwieldy. This presentation will take you step by step through choosing an appropriate partitioning key, setting up the partitioning on the table, and finally maintaining the partitions.

 

 

June 2012 Meeting

Topic: Exploring PowerPivot for Excel and Power View in SQL Server 2012

Speaker: Peter Myers

Overview:  

This presentation will deliver what’s new in PowerPivot for Excel and explores Reporting Services Power View.
PowerPivot, first released with SQL Server 2008 R2, is an add-in for Excel 2010 that empowers business users to create their own tabular data models. In this session, you will learn how the add-in has been enhanced to include a new designer experience and new modeling features.
Power View is an interactive data exploration, visualization, and presentation experience that provides intuitive ad-hoc reporting for business users. It delivers this experience via SharePoint in the web browser, and must be based on a tabular BI Semantic Model (either a published PowerPivot workbook or a tabular database). Ordinarily, the tabular BI Semantic Model will need to be optimized for the Power View experience, and the theory on how to achieve this will be demonstrated in this session. This presentation is suitable to those with experience using PowerPivot and those new to PowerPivot.

 

 

Presentation Resources: Power Pivot 2012

 

May 2012 Meeting

Topic: Characteristic Functions: T-SQL

Speaker:  Paul Springer

Overview:  

Paul Springer has been working in the IT industry for the past 25 years. He has a BS in Computer Science from Chapman University.

As a developer, Paul has created client server and web applications using SQL Server, Sybase and other database back ends.

For the past 4 years, Paul runs his own computer consulting company, Key Data Solutions LLC.

 

Presentation Resources: Characteristic Functions

 

April 2012 Meeting

Topic: Choose your Own Adventure

Speaker:  Thomas LaRock

Overview:  

Thomas LaRock is a seasoned IT professional with over a decade of technical and management experience. Currently serving as a Senior DBA for Confio Software, Thomas also holds a MS degree in Mathematics from WSU. Thomas currently serves on the Board of Directors for the Professional Association for SQL Server (PASS) and is also a SQL Server MVP. Thomas can also be found blogging at http://thomaslarock.com and is the author of DBA Survivor: Become a Rock Star DBA (http://dbasurvivor.com).”

 

 

March 2012 Meeting

Topic: 10 Ways to Improve Performance (over the weekend)

Speaker:  Keith Tate

Overview:   I will cover 10 different ways to improve performance with some simple solutions. Most do not even require code changes and they are things that you can do in a few hours (or over the weekend). Come in to work on Monday with happy end users and a happy boss.

Presentation Files: LinkClick.aspx

February 2012 Meeting

Topic: Monitoring with the SQL Agent

Speaker:  Ben Reye

Overview:   How to use the SQL Server Agent and a monitoring server to report on the basic status/health of your environment.  This covers basic setup of Operators,  Alerts, Notifications, and Job setup.  Including a few sample jobs such as monitoring cluster failover, server drive space, and server down situations.

 

 January 2012 Meeting

Topic:        Ten Things Every Developer Should Know

Date:         Friday, January 13, 2012

Speaker:   Kevin Kline

 

Kevin Kline is the technical strategy manager for SQL Server Solutions at Quest Software. A Microsoft SQL Server MVP since 2004, Kevin is a founding board member and past president of the international Professional Association for SQL Server (PASS). He has authored many books, including "SQL in a Nutshell" (O’Reilly & Associates); "Pro SQL Server 2008 Relational Database Design and Implementation"; “SQL Server MVP Deep Dives” (Manning); and "Database Benchmarking: Practical Methods for Oracle & SQL Server" (Rampant). He is a top-rated speaker at such worldwide conferences as Microsoft TechEd, the Best Practice Conference, the PASS Community Summit, and DevConnections.

Kevin writes regular columns in SQL Server Magazine and Database Trends & Applications magazine. You can follow him on Twitter using @kekline, and read his blogs at KevinEKline.com (syndicated at SQLServerPedia.com, SQLBlog.com, and SQLServerCentral.com) and his “Tool Time” blog at SQLMag.com.

 

Location:

Sun Health Care 101 Sun Ave, Albuquerque NM

 

Overview:


Stereotypes abound for different types of people in the IT world. Developers think DBAs are control freaks.  DBAs think developers are unruly cowboys. How do we overcome these differences?  If you’re a developer, your best strategy is to manage your DBAs’ anxieties and demonstrate your competence and credibility.  Attend this session to learn about 10 techniques that developers can apply to their code which will calm your DBAs’ fears and earn their admiration.   
This session will answer questions like:

  • What’s the most common Transact-SQL programming mistake and how do I fix it?
  • How do database designers cause problems for future generations of application developers and database administrators?
  • Why do inexperienced database administrators make their own job more difficult and less efficient?



There are a short list of mistakes that, if you know of them in advance, will make your life much easier.  These mistakes are the “low hanging fruit” of application design, development, and administration.  Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before.


Presentation resources:  LinkClick.aspx