Change Tracking: An near bullet proof ETL synchronization control

CACTUSS North speaker this month will be Mike Byrd.
Change Tracking:  An near bullet proof ETL synchronization control

Abstract:  Change Tracking came out with SQL Server 2008, but SS2012 almost eclipsed it with Change Data Capture. Change Tracking is now the red-headed step child, but in many cases may be a better solution for data ETL movement from an OLTP database to a data warehouse database. This session will provide a review of change tracking syntax and implementation with detailed demos. It will then dive into an actual ETL subset implementation from the AdventureWorks database to a data warehouse solution (modified AdventureWorksDW) with detailed code discussion and demos.

Bio: Former rocket scientist, retired USAF fighter test pilot; now a database geek. Former CTO for Texas Windstorm Insurance Association (9 years) and now part-time SQL Server consultant for several companies in greater Austin, TX area. Expertise is performance tuning. 

CACTUSS North: 
The meeting starts at 5:30PM CST with food and a QA session. The main presentation is at 6:00PM. 
Quarry Oaks II
10900 Stonelake Blvd., Suite 225
Austin, TX 78759
Phone: (512) 795-5300

Follow @CACTUSS_SQL for the lastest information.

Upcoming Speakers: http://cactuss.org/pages/speaker-calendar

Mission Possible: Interactive Performance Troubleshooting - Indexes

CACTUSS Central - Wednesday January 15, 2014

Jim Murphy will be presenting
Mission Possible: Interactive Performance Troubleshooting -  Indexes

Abstract: 
Performance troubleshooting is detective work. We'll have a lab system being assaulted by PowerShell scripts  (to simulate live users), and simulated performance problems like those that can make your on-call cell phone ring too much! Do you think you have what it takes to find these "needle in the haystack" issues and resolve them quickly?  This will be a highly interactive session where we will locate the rogue queries together, work through solutions, implement them and measure the results.  In this episode we'll focus primarily on improper indexing as a common underlying problem. We'll go through as many scenarios as will fit in 1.5h, and all will walk away with much better troubleshooting skills and an upgraded knowledge of performance tuning!  200-300 Level. Skills Used: DM's, Exec Plans, Perfmon, etc. 

Bio:
Jim Murphy has been using Microsoft SQL Server since version 6.0 back in the 90's. He is the President/CEO of SQLWatchmen, LLC., a managed DBA service provider for smaller companies who do not need a full-time DBA. He runs the Austin SQL Server User Group: CACTUSS Central and sits on the board of SQLPOSSE.com. He has been a professional DBA and developer for over 20 years and has run a consulting company full-time for over a decade.

** MEETING TIME/DATE CHANGE FOR CACTUSS CENTRAL **

Since the meeting is normally on Monday and the next two month's holiday's fall on Monday, we booked the library but for the 3rd WEDNESDAY of each month.  What is more, since we've talked about changing the date with the theory being Monday nights are hard to get away from work on time, we went ahead and booked ALL 2014 for the 3rd WEDNESDAY of every month.    

We meet the third Wednesday of each month. The meeting starts at 6:00 PM with food, and a QA session and the main presentation starts at 6:30 PM

Address:
Pleasant Hill Public Library
211 E. William Cannon Drive
Austin, TX, 78745
It is located on William Cannon just West of IH-35

Visitor Parking:
Free parking.

CACTUSS North - Architecting large scale Azure services 12/17

This month for our North meeting we have a guest speaker, Conor Cunningham Principal Architect Azure Data Platform Group. He will be presenting 

Architecting large scale Azure services
This is a primer on building a SaaS solution on Windows Azure/SQL Azure.

Conor Cunningham is a Principal Software Architect at Microsoft on the SQL Server Query Processor Team.  He's worked on database technologies for Microsoft for over 10 years and is holds numerous patents related to Query Optimization and Query Processing.  Conor is the author of a number of peer-reviewed articles on query optimization techniques.  Recently, he authored a chapter for the book "Microsoft SQL Server 2008 Internals" on how the Query Optimizer works.  He publishes a blog called "Conor vs. SQL" (http://blogs.msdn.com/conor_cunningham_msft/default.aspx)  where he answers questions about databases.

CACTUSS North
We meet the third Tuesday each month. The meeting starts at 5:30PM CST with food and a QA session. Main presentation is at 6:00PM CST.

Address:
Quarry Oaks II
10900 Stonelake Blvd., Suite 225
Austin, TX 78759
Phone: (512) 795-5300
Fax: (512) 343-8498 

CACTUSS Central - Performance Root Cause Analysis in 10 Minutes 12/16

This month for our Central meeting John Sterrett will be presenting on 

Performance Root Cause Analysis in 10 Minutes

Have you ever been confronted by the business with performance problems and didn't know what to do? I did when I started out as a DBA and it was an experience I will never forget. I don't want to see this happen to you. If you are new to performance tuning or being a DBA please check out this presentation. I hope it arms you with the knowledge and the scripts needed to help you find the root cause to your performance problems.

BIO:

John Sterrett is a database administration senior advisor for Dell, directly responsible for several mission-critical databases. Previously, he was a senior DBA focused primarily on performance tuning at a Remote DBA service company with over 200 SQL Server clients. He has presented at many community events, including PASS Summit, SQLRally, 24 Hours of PASS, SQLSaturday, and local PASS Chapter and Virtual Chapter meetings. He is a PASS Regional Mentor for the South Central US region, co-founded the West Virginia SQL Server User Group, and hosted the first and second SQLSaturday in West Virginia. He is a syndicated blogger at SQLServerPedia and SQLServerCentral.com and a writer for MSSQLTips.com.

Scripts and notes for this presentation: http://t.co/hAjMrf7GAS

CACTUSS Central
We meet the third Monday of each month. The meeting starts at 6:00 PM with food, and a QA session and the main presentation starts at 6:30 PM

Address:
Pleasant Hill Public Library
211 E. William Cannon Drive
Austin, TX, 78745
It is located on William Cannon just West of IH-35

Speeding Up Aggregations with Indexed Views

This month's presentation will be given by one of our very own members Steven Ormrod. Steven will present at both our Central and North meetings. So, come to the meeting to connect, share, and learn from a Microsoft Certified Master. 

Speeding Up Aggregations with Indexed Views

Do you have a report that’s taking too long? Is the CEO standing over your desk asking when it will be done? If your queries rely on complex aggregations then you may be able to speed things up with a few well-placed indexes and indexed views. In this demo-centric session, we’ll look into query plans to identify the tell-tale signs of an Aggravating Aggregation. First, we’ll see how we can use standard indexes in order to speed things up. Then, we’ll take it up a notch by adding Indexed Views to make things even faster. On Monday, you’ll be armed with CEO Kryptonite that will leave you plenty of time to read blogs all day.

Bio

Steven is a Senior Consultant for Catapult Systems where he focuses on SQL Server and Business Intelligence. Previously, he worked as a Senior Database Administrator with hundreds of servers located internationally; focusing on High-Availability Architectures, Troubleshooting, and Index Tuning. He is a board member for the Austin, Texas PASS Chapter. Steven holds a BS in CS and a M. Ed. He enjoys cooking, traveling, and snorkeling. MCITP SQL 2008: DBA & Dev; MCTS SQL 2008: BI Dev.

Locations/directions: http://cactuss.org/pages/meeting-location-and-directions

Upcoming Speakers: http://cactuss.org/pages/speaker-calendar


SQL Server: Monitoring Disk Usage - September 16 and 17

This month's presentation is on SQL Server: Monitoring Disk Usage presented by Daniel Janik.

Daniel will be presenting for both for CACTUSS Central and North

Abstract:

Storage is the number one bottle neck in SQL Server. Take a moment to learn how Microsoft analyzes performance issues in todays world. This session will cover performance monitor, xperf, SQL Server internals  and much more! Learn from the author of the Books Online article for monitoring disk usage!!

Bio:

Daniel has seventeen years’ experience supporting and developing software solutions on the Microsoft platform and fourteen years with Microsoft SQL Server. Over the past six years he has supported over 280 Microsoft Premier customers across every industry.

CACTUSS Central:
The meeting starts at 6:00PM CST with food, and QA session. The main presentation starts at 6:30PM.
Pleasant Hill Public Library
211 E. William Cannon Drive
Austin, TX, 78745
It is located on William Cannon just West of IH-35
Free parking.

CACTUSS North:
The meeting starts at 5:30PM CST with food and a QA session. The main presentation is at 6:00PM.
Quarry Oaks II
10900 Stonelake Blvd., Suite 225
Austin, TX 78759
Phone: (512) 795-5300

Follow @CACTUSS_SQL for the lastest information.

Table Partitioning: Secret Weapon for Big Data Problems CACTUSS Central 8/19 and CACTUSS North 8/20

This month John Sterrett is presenting at CACTUSS Central on Monday 8/19 and CACTUSS North on Tuesday 8/20. Come get a first hand look at his Summit 2013 session.

Table Partitioning: Secret Weapon for Big Data Problems

Big Data starting to slow you down? Data growth putting your maintenance tasks in danger of not meeting your SLAs? Wish you could archive old data with minimal impact to your tables during the archive process or that you could eliminate most of the data in your tables when you query them? If so, it's time you consider implementing table partitioning to help with general performance and reduce your window for completing maintenance tasks.

Come learn how table partitioning works and when it should be implemented. You'll see how to initially configure partition functions and partition schemes to have a rock-solid partitioned table. And you'll learn how to implement an automated sliding window to maintain your partitioned tables and ensure optimal performance.

BIO:
John Sterrett is a database administration senior advisor for Dell, directly responsible for several mission-critical databases. Previously, he was a senior DBA focused primarily on performance tuning at a Remote DBA service company with over 200 SQL Server clients. He has presented at many community events, including PASS Summit, SQLRally, 24 Hours of PASS, SQLSaturday, and local PASS Chapter and Virtual Chapter meetings. He is a PASS Regional Mentor for the South Central US region, co-founded the West Virginia SQL Server User Group, and hosted the first and second SQLSaturday in West Virginia. He is a syndicated blogger at SQLServerPedia and SQLServerCentral.com and a writer for MSSQLTips.com.

Reminder: Please make note of the new meeting location for CACTUSS Central. 
The new address is also posted here: http://cactuss.org/pages/meeting-location-and-directions  

CACTUSS Central: 
The meeting starts at 6:00PM CST with food, and QA session. The main presentation starts at 6:30PM. 
Twin Oaks Branch - Public Library 
1800 S 5th St. Austin, Texas
512-974-9980
On the corner of S 5th and Mary St., a little north of Oltorf.

CACTUSS North: 
The meeting starts at 5:30PM CST with food and a QA session. The main presentation is at 6:00PM. 
Quarry Oaks II
10900 Stonelake Blvd., Suite 225
Austin, TX 78759
Phone: (512) 795-5300

Follow @CACTUSS_SQL for the lastest information.

CACTUSS Central 7/15 AND CACTUSS North 7/16

Change Tracking:  A Near Bullet-Proof ETL Synchronization Control
will be presented by our very own Mike Byrd.

Abstract:
 
Change Tracking came out with SQL Server 2008, but SS2012 almost eclipsed it with Change Data Capture.  Change Tracking is now the red-headed step child, but in many cases may be a better solution for data ETL movement from an OLTP database to a data warehouse database.  This session will provide a review of change tracking syntax and implementation with detailed demos.  It will then dive into an actual ETL subset implementation from the AdventureWorks database to a data warehouse solution (modified AdventureWorksDW) with detailed code discussion and demos. 

Reminder: Please make note of the new meeting location for CACTUSS Central. 
The new address is also posted here: Meeting Locations and Directions
(http://cactuss.org/pages/meeting-location-and-directions)

CACTUSS Central: 
The meeting starts at 6:00PM CST with food, and QA session. The main presentation starts at 6:30PM. 
Twin Oaks Branch - Public Library 
1800 S 5th St. Austin, Texas
512-974-9980
On the corner of S 5th and Mary St., a little north of Oltorf.

CACTUSS North: 
The meeting starts at 5:30PM CST with food and a QA session. The main presentation is at 6:00PM. 
Quarry Oaks II
10900 Stonelake Blvd., Suite 225
Austin, TX 78759
Phone: (512) 795-5300

Follow @CACTUSS_SQL for the lastest information.

CACTUSS Central 6/17 and North 6/18 - Better, Faster, Stronger

This month Eric Cox will be presenting Better, Faster, Stronger for Central (tonight) and North (tomorrow night) meetings.

Better, Faster, Stronger
A quick overview of top 5 tools you're not using but should be.

In this fast-paced talk we'll cover a selection of powerful tools which could change the way you do things. I'll give a quick overview of the tool along with a use case for database professionals. Simple working demos and power tips will fill in the gaps as we roll through the top 5 and based on time and interest I'll go over additional tools.  Everyone bring a list of your favorite tools, tips, and techniques to share with the group.

Eric Cox is a Microsoft Certified Software Developer with over 20 years of experience building data driven solutions.
His work experience has included a large range of solutions:
- Geography: Texas, Florida, Ohio, California, Alaska (North Slope), Washington DC, Germany
-- Industries: Healthcare, Government, Defense, Petroleum, Non-Profit, Bio-medical Research
-- Tools: C#, SQL Server 2008 R2 / 2012
-- Types: From video game development to commercial application to multi-year, enterprise data migrations to data warehousing

REMINDER: Please make note of the new meeting location for CACTUSS Central. The new address is also posted here: http://cactuss.org/pages/meeting-location-and-directions  

CACTUSS Central:
Twin Oaks Branch - Public Library
1800 S 5th St. Austin, Texas
512-974-9980
On the corner of S 5th and Mary St., a little north of Oltorf.


CACTUSS North:
Quarry Oaks II
10900 Stonelake Blvd., Suite 225
Austin, TX 78759
Phone: (512) 795-5300

CACTUSS 5/21/2013

This month we have a special guest speaker Vicky Harp. She will be speaking at both the Central and North meetings so come on out.


Vicky will be presenting


Care and Feeding of Your System Databases


Master, model, msdb, tempdb. You see them on all of your servers, but what do you really know about them? If you ever wanted to learn about the SQL Server system databases, their purpose, and the maintenance and configuration required to keep your server running its best, then this session is for you! Learn best practices and techniques, including how to restore master and how to configure tempdb to reduce contention. You'll leave with a better understanding of these shared resources and how they affect your database applications.


Bio:

With 12 years of professional software development experience, Vicky is always interested in learning new ways to improve performance and maintainability of database code. Vicky is a product manager with Idera, where she has worked for the past 9 years creating software to make DBAs' lives easier. She speaks frequently at PASS events and is active on Twitter.


Note: 

Vicky mentioned she is interested in dinning locally after each meeting and just hanging out with some Austin SQLPeople. If you are interested we will figure the details after the meeting. 



CACTUSS CENTRAL:

The meeting starts at 6:00 PM CST with food, Introduction by Experis 

and a QA session. The main presentation starts at 6:30 PM


Address:

Experis IT

301 Congress Avenue, Suite 360

Austin, TX 78701


Parking:

Upon arriving at Experis, you may part on the street for free after 5:30PM CST. 

We will not validate parking in the building garage. 



CACTUSS NORTH:

The meeting starts at 5:30PM CST with food and a QA session. The main presentation is at 6:00PM CST.


Address:

Quarry Oaks II

10900 Stonelake Blvd., Suite 225

Austin, TX 78759

Phone: (512) 795-5300

Fax: (512) 343-8498


PARKING: 

Upon arriving at Quarry Oaks II, you may park on the surface lot in the front of the building or in parking garage at the back of the building.