Locking, Blocking, Latching, OH MY! 10/15 and 10/21

Update: This is one of those meetings where the 3rd Tuesday and Wednesday don't fall on the same week. 

CACTUSS Central is 10/15 and CACTUSS North is 10/21.

******************************************************************************************************************************

Daniel Janik, Principal Database Developer Multimedia Games

Have you run into problems with blocking or deadlocks? Are your transactions stepping on each other? Do you know what the difference between a latch and a lock is? Is your design optimal? This session is a hands-on, technical dive into SQL Server's isolation levels and locking mechanics. Whether you're a developer or DBA this session is for you. We will cover the various issues that a developer or DBA may run into and how to resolve them. Expect this session to be interactive, so come prepared.

About Daniel:
Daniel Janik has been supporting SQL Server for 18 years. Daniel is currently a Principal Database Developer at Multimedia Games. Daniel is also a former "Microsoftee". His time at Microsoft Corporation was spent supporting SQL Server as a Senior Premier Field Engineer (PFE). During his 6 years as a PFE, he supported over 275 different clients with both reactive and proactive database needs. Daniel has presented at many community events and at SQL Saturday.

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

CACTUSS Central:
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
Pleasant Hill Public Library
211 E. William Cannon Drive
Austin, TX, 78745
William Cannon just West of IH-35 /Free parking. 

Follow @CACTUSS_SQL for the lastest information.

CACTUSS - IS INDEPENDENT CONSULTING FOR ME?

IS INDEPENDENT CONSULTING FOR ME?
Presenter: Brian Moran & John Sterrett

Have you had dreams of striking it out on your own being an independent consultant? Have you wondered what it takes to make your dream a reality?
 
In this session, you will get lessons learned from the presenter's transition from corporate America to independent consulting. You will get a checklist that helps you do an assessment to determine if independent consulting is for you. We will debunk some common myths about independent consulting. Finally, we will cover some resources, tips and tricks that could help you get a successful start in independent consulting.
 
BIOS
 
Brian Moran is Chief Servant Officer at Linchpin People and has been active in the SQL Server community for more than 20 years. Brian co-founded one of the first SQL Server user groups in the world, was one of the first SQL Server MVPs, was on the SQL Server Magazine launch team, and has served on the PASS Board of Directors in two separate terms. Brian's roles in the SQL Server community include technologist, author, community leader, and entrepreneur.

John Sterrett is a Group Principal and Sr. Consultant at Linchpin People. Previously, he was a Sr. Database Admin Advisor for Dell, directly responsible for several mission-critical databases behind dell.com. John has presented at many community events, including PASS Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a PASS Regional Mentor and founded WVPASS user group and the HADR Virtual Chapter.
 
CACTUSS Central:
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
Pleasant Hill Public Library
211 E. William Cannon Drive
Austin, TX, 78745
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.
Upcoming Speakers: http://cactuss.org/pages/speaker-calendar

CACTUSS North 8/19 CACTUSS Central 8/20

This month we have two different speakers and presentations at the different meetings.

CACTUSS North 8/19

Mark Moore from Microsoft will be presenting...

New features of SQL 2014

Abstract:
New features of SQL 2014 including in memory OLTP along with improvements to resource governor and host of integration topics for SQL 2014 and Windows Azure.

Bio:
Mark Moore is a 20 year Microsoft veteran who started in 1994.  Mark has been working with SQL since version 4.2 just after the purchase from Sybase.  Mark lives in San Antonio Texas with his Wife Deanne, Their children are grown with three daughters living in Colorado Springs and one Son in San Antonio working for Apple.

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


CACTUSS Central 8/20

Shawn Weisfeld from Microsoft will present...

Leveraging the SQL Server Data Tools to ease Database development
 
Abstract:
Working with SQL schema is a chore for most developers. In this session we will take a look at the SQL Server Data Tools in Visual Studio and how we can leverage them to make your development life a bit easier.
 
Bio:
Shawn is passionate about building awesome applications and websites with .NET technologies. He is currently an Application Development Manager for Microsoft based in Austin TX and founder of http://UserGroup.tv. Read his full bio at http://about.me/shawnweisfeld

CACTUSS Central:
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
Pleasant Hill Public Library
211 E. William Cannon Drive
Austin, TX, 78745
William Cannon just West of IH-35 /Free parking.

Follow @CACTUSS_SQL on Twitter.
Upcoming Speakers: http://cactuss.org/pages/speaker-calendar

SQL Server Foreign Keys - De-mystifying the Rest of the Story

Special Note: Date change for CACTUSS North Thursday July 17th this month only

Speaking this month for Central (7/16) and North (7/17) is Mike Byrd.

SQL Server Foreign Keys - De-mystifying the Rest of the Story

Foreign Keys have a bad rap - they cause performance issues, they inhibit some inserts, deletes and updates, etc. This may be true, but let's further explore why we even have them and how they can benefit and maybe even improve performance. This session will concentrate on many demos including the attributes associated with foreign keys. The attendee will walk away from this session with a better understanding of Foreign Key utility and their maintenance.

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. Just completed teaching a Basic TSQL class (15 classroom hours, 17 students) with emphasis on query writing and performance.

CACTUSS Central:
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
Pleasant Hill Public Library
211 E. William Cannon Drive
Austin, TX, 78745
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.
Upcoming Speakers: http://cactuss.org/pages/speaker-calendar

Get in my Base - Part 2

This month Mike Burek will present  Data: Get in my Base - Part 2

Abstract: Part 2 takes a basic SSIS import package and shows how to add variables, loops, tracking, and summary emails.

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

CACTUSS Central:
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
Pleasant Hill Public Library
211 E. William Cannon Drive
Austin, TX, 78745
William Cannon just West of IH-35 /Free parking.

Follow @CACTUSS_SQL for the lastest information.

Fundamentals of SAN, NAS and IP Storage

This month Wes Brown will be presenting at CACTUSS North and Central.


Fundamentals of SAN, NAS and IP Storage
SAN's and NAS's have their own challenges but also open up a whole new set of tools for disaster recovery and high availability. We will touch on the basics that can be applied to most SAN's and talk about strategies for setting up your storage. We will also cover what makes up a Storage Area Network and what seperates Network Attached Storage from SAN's and how iSCSI fits into this picture.

Wes Brown is a PASS chapter leader and SQL Server MVP. He writes for SQL Server Central and maintains his blog at http://www.sqlserverio.com. Wes is Currently serving as a Database Administrator Consultant for Dell. Previous experiences include Product Manager for SQL Litespeed by Quest software and consultant to fortune 500 companies. He specializes in high availability, disaster recovery and very large database performance tuning. He is a frequent speaker at local user groups and SQLSaturdays.

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

CACTUSS Central:
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
Pleasant Hill Public Library
211 E. William Cannon Drive
Austin, TX, 78745
William Cannon just West of IH-35 /Free parking.

Follow @CACTUSS_SQL for the lastest information.

12 Steps to Workload Tuning

12 Steps to Workload Tuning

We might know how to tune a query for optimal performance or create additional indexes to ensure faster execution, but how do we ensure that our changes don’t hurt our total workload?  Do we know if the new 3rd Party application upgrade will make performance better or worse? Do we know if your application can scale due to unexpected stress? In this session, we will go over a process used to tune a workload and answer the common questions above. In this presentation we will also use RML Utilities to answer these questions and even give you a little insight into how you can document these changes to help you get that next raise.

John Sterrett is a Group Principal and Sr. Consultant at Linchpin People. Previously, he was a Sr. Database Admin Advisor for Dell, directly responsible for several mission-critical databases behind dell.com. John has presented at many community events, including PASS Member Summit, SQLRally, 24 Hours of PASS, SQL Saturday’s, PASS Chapters and Virtual Chapter meetings. John is a PASS Regional Mentor and one of the founders of the WVPASS user group and the PASS HA/DR Virtual Chapter.

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

CACTUSS Central:
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
Pleasant Hill Public Library
211 E. William Cannon Drive
Austin, TX, 78745
William Cannon just West of IH-35 /Free parking.

Follow @CACTUSS_SQL for the latest information.
Upcoming Speakers: http://cactuss.org/pages/speaker-calendar

SQL Server Query Plan Analysis

Presenting this month for CACTUSS North 3/18 and Central 3/19 is Daniel Janik. He will be presenting...

SQL Server Query Plan Analysis
Ever wonder what's wrong with a stored procedure? Had troubles tuning? Think the procedure is running "good enough" but not really sure how it scales? If yes, this is the talk for you! During this session, Daniel will show you how to effectively read and analyze the query plans for SQL Server. Showing tips and tricks that he has learned over his 16 years of SQL Server experience. 

Daniel Janik
Has eighteen years of experience in information technology and sixteen supporting SQL Server, which includes six years at Microsoft as a field engineer. Daniel has been a DBA, developer, consultant, and trainer. Daniel is currently the database architect at Multimedia Games.


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

CACTUSS Central:
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
Pleasant Hill Public Library
211 E. William Cannon Drive
Austin, TX, 78745
William Cannon just West of IH-35 /Free parking.

Follow @CACTUSS_SQL for the lastest information.

Data: Get in my Base - Part 1

CACTUSS Central and North are proud to present this month's speaker Mike Burek. Mike is a long time member of CACTUSS but a first time speaker. Come out to either meeting to see Mike talk about Data.

Data: Get in my Base - Part 1

Abstract: The "Data: Get in my Base" series is about various tools, tricks, and
tactics I've used though my trials and tribulations of getting various
types of data imported into MS SQL Server databases. "Part 1" is an
introductory level look at text files, Excel files, some command line
tools, SSMS import wizard, and simple, linear SSIS data flows.

Bio: Mike has worked for several marketing companies that store a
customer's purchase history, marketing preferences, and track the
customer's response to email, physical mail, and telephone marketing
campaigns. The two favorite areas of work are making dirty-data usable
and hacking a way around un-doable tasks.


/*****************************************************************/

Follow @CACTUSS_SQL for the lastest information.


CACTUSS North: 2/18
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

CACTUSS Central: 2/19
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
Pleasant Hill Public Library
211 E. William Cannon Drive
Austin, TX, 78745
William Cannon just West of IH-35 /Free parking.

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