CACTUSS Central - Meeting 2/20

Eric Cox will be presenting this month at CACTUSS Central.
Hold that thought...short term storage
200 Level

I suffer from short term memory loss. It runs in my family... At least I think it does... Where are they?
-- Dory, Finding Nemo

There are a number of ways to temporarily hold data in T-SQL.  
This month we'll discuss many of them along with use cases and limitations.
We'll probably include your favorite go-to solutions, some you remember seeing but have never used and some you will probably want to try once you see them.

I plan on covering the old-timers like pound tables (#) along with some of the newer ideas like CTEs (Common Table Expressions) and Row Value tables.

We'll keep it as simple as possible for the newbies but will cover enough info that even the most experience data professional will leave with some techniques to try.
Eric Cox is a Microsoft Certified Software Developer with over 20 years 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, Java and Oracle
-- Types: From video game development to commercial application to multi-year, enterprise data migrations to data warehousing

Parking is street parking, so anywhere you can find around the building

The meeting starts at 6:00 PM CST with food and open discussion. Main presentation starts at 6:30 PM

Location Information

Address:
Experis IT
301 Congress Avenue, Suite 375
Austin, TX 78701

CACTUSS North - Tuesday January 17th

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

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

VISITOR 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.

Wes Brown will be speaking this month on Benchmarking, Baselines and Monitoring Storage

Benchmarking, Baselines and Monitoring Storage There are several steps in the life cycle of your storage systems. We have several tools to help us understand our storage systems from initial deployment through its useful life. We will cover: SQLIO, a specific SQL Server benchmarking tool. Iometer, a general IO benchmarking tool and simulator. SQLIOSim a specific SQL Server base lining tool and simulator. TPC style testing focused on TPC-C, TPC-E and TPC-H. Monitoring your system using WMI and virtual file stats. Finally, what it all really means, how to read these results and compare them with each other. With these tools you can plan, deploy and manage your storage for years to come!

CACTUSS Central - Monday January 16th

Wes Brown will be speaking this month on Benchmarking, Baselines and Monitoring Storage

Benchmarking, Baselines and Monitoring Storage There are several steps in the life cycle of your storage systems. We have several tools to help us understand our storage systems from initial deployment through its useful life. We will cover: SQLIO, a specific SQL Server benchmarking tool. Iometer, a general IO benchmarking tool and simulator. SQLIOSim a specific SQL Server base lining tool and simulator. TPC style testing focused on TPC-C, TPC-E and TPC-H. Monitoring your system using WMI and virtual file stats. Finally, what it all really means, how to read these results and compare them with each other. With these tools you can plan, deploy and manage your storage for years to come!

The meeting starts at 6:00 PM CST with food and open discussion.
Main presentation starts at 6:30 PM

Remember, parking is street parking, so anywhere you can find around the building.

Location:
Experis Austin offices
Address:
Experis IT
301 Congress Avenue, Suite 375
Austin, TX 78701

CACTUSS Central - Meeting Monday 12/19

Eric Cox will be presenting this month at CACTUSS Central.

Upserting: Solving the problem you didn't know you had
200 Level

One of the most overlooked aspects of data management is Upserting (Inserting/Updating).
In this short talk we'll cover why this is problem, some of the things to consider and a few approaches (including MERGE).

Even the most experience data professional will leave with some ideas to consider.

Eric Cox is a Microsoft Certified Software Developer with over 20 years 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, Java and Oracle
-- Types: From video game development to commercial application to multi-year, enterprise data migrations to data warehousing

Parking is street parking, so anywhere you can find around the building

The meeting starts at 6:00 PM CST with food and open discussion. Main presentation starts at 6:30 PM

Location Information
Experis Austin offices
Address:
Experis IT
301 Congress Avenue, Suite 375
Austin, TX 78701                                                                    

                       

CACTUSS Central - Meeting tomorrow night

Hello All,

Our own Mike Byrd will be presenting at this month's meeting!

Titled SQL Server Hodge Podge

A different approach to a presentation, going over some issues I've encountered in last couple weeks including string lengths, datetime, statistics, query tuning, row compression.


POSSE Elections

The Secretary of POSSE, Richard Heim, is accepting nominations for elections to the POSSE Board of Directors. The positions to be filled are President, two year term, two Directors, two year terms, and two Directors, one year terms.  Each candidate must be nominate by another member.  A candidate may not nominate himself or herself.   Please email your nominations to Richard at richard.hiem@sqlposse.com.  Nominations must be submitted by December 13, 2011.  The annual meeting will be held on January 17, 2012.

Parking is street parking, so anywhere you can find around the building

CACTUSS CENTRAL:

The meeting starts at 6:00 PM CST with food and open discussion. Main presentation starts at 6:30 PM

Location Information
Experis Austin offices
Address:
Experis IT
301 Congress Avenue, Suite 375
Austin, TX 78701

CACTUSS North Meeting tonight

Greetings!

Our Own Mike Byrd will be presenting this evening.

Titled SQL Server Hodge Podge

A different approach to a presentation, going over some issues I've encountered in last couple weeks including string lengths, datetime, statistics, query tuning, row compression.

As usual, we will have pizza and drinks for you!

The meeting starts at 5:30PM CST with food and a QA session.
Main presentation is at 6:00PM CST. We may even talk about what some of us did last week. :)

Cheers!


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

VISITOR 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.

CACTUSS North - Tonight

Howdy!

This evening Wes will be covering the basics of executions plans and how to read them.
He will also look at some free tools to make your life easier as well.

As usual, we will have pizza and drinks for you!

The meeting starts at 5:30PM CST with food and a QA session.
Main presentation is at 6:00PM CST. We may even talk about what some of us did last week. :)

Cheers!


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

VISITOR 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.

Meeting Monday Oct 17th CACTUSS Central: Execution Plans Basics

Hello everyone!

We are meeting today at the Experis offices at 3rd and Congress at 6pm.

Today I will be covering the basics of executions plans and how to read them. We will also look at some free tools to make your life easier as well.

As usual, we will have pizza and drinks for you!

CACTUSS CENTRAL:

We meet every third monday at the Experis Austin offices
www.bing.com/maps/

The meeting starts at 6:00 PM CST with food, Introduction by Experis and a QA session. Main presentation starts at 6:30 PM

Location Information

Address:
Experis IT

301 Congress Avenue, Suite 375
Austin, TX 78701

 

See you there!

CACTUSS - Central and North Meeting

CACTUSS - Central

Reminder Meeting Tonight at the Experis Austin offices   ( www.bing.com/maps/)

The meeting starts at 6:00 PM CST with food, Introduction by Experis and a QA session. Main presentation starts at 6:30 PM

THIS MONTH

Jim Murphy will be presenting his SQL Saturday session Denali AlwaysOn - Finally, A usable 'mirror'! So if you won't be at SQL Saturday next month here is your chance to see Jim's session.

Denali AlwaysOn - Finally, A usable 'mirror'!

In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. Denali AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic ConnectionString fail-over using a real web app to see how well that feature works.


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. and has been a consultant for over 10 years. Jim's background is in database administration and .NET development. Before becoming a full-time consultant, he worked in Software Engineering for Packard Bell/NEC for 9 years and also for a small dot com in California at the turn of the century. SQLWatchmen has a staff of DBA's for round-the-clock part-time monitoring. Jim is also the Treasure for POSSE (Professional Organization of SQL Server Educators).

Location Information
Experis IT
301 Congress Avenue, Suite 375
Austin, TX 78701

VISITOR 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

Meeting tomorrow night Tuesday at the Microsoft South Central District Offices. www.bing.com/maps/

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

This Month

We will be a SQL Saturday preview.

Hope to see you all there!

- AJ


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

VISITOR 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.

Volunteers Are The Life Blood

Without volunteers events like SQL Saturday 97 in Austin (October 1st in case you forgot) would not be possible. Heck the PASS Summit in all its glory and pageantry would not be possible without the help of the volunteers. I am part of the team from CACTUSS planning and organizing this event and we need your help to make this event happen.

What Volunteers Do

In short, they do everything. Do you remember looking at the event page for SQL Saturday 97? No, well, here is a link, http://www.sqlsaturday.com/97/eventhome.aspx go take a look. What is the 6th word in the 2nd paragraph? One of the main reasons we can provide events as this at this price is because of volunteers on the front line and down in the trenches.

Here are a few things we will need help with. Registration desk when attendees first arrive. Room monitors to hand out speaker evaluations and collect them at the end and to help keep the speaker on track. Greeters and General Information Dispensers, Vendor Area setup/takedown, Breakfast Server setup/takedown, Lunch Server setup/takedown , Room Proctors /Monitors.

What Do You Get As A Volunteer?

Well first off you get a really cool shirt! What else do you need? No seriously, when I volunteered I was a room monitor and I used that opportunity to meet and talk with the speakers a little more closely than might be able to right after a sessions. It also helped me break the ice with other speakers and attendees later at the networking party (a must).

There is also the opportunity to get fame and fortune. Well O.K. maybe not, but at least you can say you hung out with a @SQLRockstar, Thomas LaRock ( twitter | blog ) or Jen and Sean McCown the @MidnightDBA dynamic duo ( twitter | blog ) or our very own @SQLServerIO, Wes Brown ( twitter | blog ) or any number of other up and coming local speakers.

What Do We Get From You?

Believe it or not you are giving back by volunteering. When you volunteer you are helping to keep the SQL Community alive, moving forward and continually growing. You are helping to provide a free training event to people that may be just starting out working with SQL Server or any of its related components. You are also helping to save some of the rest of us some sleepless nights and reducing our stress levels.

Final Thoughts

Volunteers are the backbone of these events without them we would not be able to host SQL Saturday 97 or any SQL Saturday events. Volunteering can be rewarding in many different ways. It's up to you how you approach the opportunity and what you make of it. I have volunteered for several SQL Saturday events now with SQL Saturday 97 being the first I am helping to organize. I can tell you each one is different and each one has been very rewarding from the new things I learned to the people I met.

I will go out on a limb and say if you volunteer to help, even a little, you will also get this warm, fuzzy feeling that only comes from volunteering and helping make an event such like SQL Saturday 97 a success.

If you want to volunteer after reading this email me at aj.mendo@sqlposse.com or signup to attend here and check the box to volunteer.

See you there.

Cheers!

SQLAJ