CACTUSS Central - 8/20

This month Jim Murphy will be presenting.

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. 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 fail-over using a real web app to see how well this 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., 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.

CACTUSS Central:
The meeting starts at 6:00 PM CST with food and open discussion.
Main presentation starts at 6:30 PM
Location Info:
*Parking is street parking, so anywhere you can find around the building
Experis IT
301 Congress Avenue, Suite 375
Austin, TX 78701

CACTUSS North and Central 7/16 and 7/17 Meeting

This month we have our very own Mike Byrd. He is presenting for Central Monday 7/16 and North Tuesday 7/17.

Partitioning: The Rest of the Story

There are many white papers and articles about table partitioning, but when it comes down to implementing partitioning there is little "real world" documentation. This presentation will cover definitions (so you will know what I am talking about), tips on what tables to partition, how to pick a partition key, and finally a real world scripts on implementation and ongoing maintenance (with tips) of the partitioned tables.


CACTUSS Central: 7/16
The meeting starts at 6:00 PM CST with food and open discussion.
Main presentation starts at 6:30 PM
Location Info:
*Parking is street parking, so anywhere you can find around the building
Experis IT
301 Congress Avenue, Suite 375
Austin, TX 78701


CACTUSS North: 7/17
The meeting starts at 5:30PM CST with food and a QA session.
Main presentation is at 6:00PM CST.
Location Info:
Address:
Quarry Oaks II
10900 Stonelake Blvd., Suite 225
Austin, TX 78759


Speaker Calendar: http://cactuss.org/pages/speaker-calendar
We introduced a speaker calendar on the CACTUSS web site in an effort to keep you more informed of up coming speakers for our meetings. If you are interested or know someone who would like to present contact either Wes (wes.brown@sqlposse.com), Jim (jim.murphy@sqlposse.com) or myself (aj.mendo@sqlposse.com).

Cheers!

CACTUSS Central and CACTUSS North 6/18 and 6/19

We have a special guest speak this month for CACTUSS Central and CACTUSS North.

Ryan Adams will be presenting

Manage your shop with CMS and Policy Based Management

In this presentation we talk about Central Management Server and how it can help you manage a disperse environment. We will also cover what Policy Based Management is and how you can leverage its power to better manage your environment. With PBM we'll see what it can and cannot do to help you enforce standards in your enterprise. We will cover and demonstrate PBM for the beginner from creating and evaluating policies to receiving alerts on policy violations.

Ryan has worked for a Fortune 100 company for 14 years. He is the sole SQL Server DBA for his group. His primary focus is database design and performance, but also works with SSRS and SSIS. He enjoys being involved in the SQL community and serves on the Board of Directors for the North Texas SQL Server User Group and the PASS Performance Virtual Chapter. He also serves as a Regional Mentor for PASS and holds the following certifications: MCP MCSA MCSE MCDBA MCTS MCITP



CACTUSS Central: 6/18

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

Location Info:
*Parking is street parking, so anywhere you can find around the building
Experis IT
301 Congress Avenue, Suite 375
Austin, TX 78701


CACTUSS North: 6/19

The meeting starts at 5:30PM CST with food and a QA session.

Main presentation is at 6:00PM CST.

Location Info:
Address:
Quarry Oaks II
10900 Stonelake Blvd., Suite 225
Austin, TX 78759


Speaker Calendar:

We introduced a speaker calendar on the CACTUSS web site in an effort to keep you more informed of up coming meetings. If you are interested or know someone who would like to present contact either Wes (wes.brown@sqlposse.com), Jim (jim.murphy@sqlposse.com) or myself (aj.mendo@sqlposse.com).

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

Come on out and get your SQL Learn On!

CACTUSS Central - 5/21 - Introduction to SSIS

Nathan Wimberley will be presenting this month

Introduction to SSIS

SQL Server Integration Services is an amazing technology for moving and transforming data blazingly fast.  Plus, the BIDS environment makes it so easy to design and edit your ETL solution.  Come learn where to start with SSIS.  This session is full of demos to give you a practical introduction and show you some of the great features of SSIS.

Nathan has been a software developer for about a decade working with .NET, web and database development.  He works at SQLWatchmen, LLC. where he enjoys architecting, designing and implementing solutions for corporate database systems large and small.  Over the years, he has taken the lead to develop the SQLWatchmen Health Check tool, various SSIS packages, designing databases and working with many other aspects of SQL Server.

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

Location Info:
*Parking is street parking, so anywhere you can find around the building
Experis IT
301 Congress Avenue, Suite 375
Austin, TX 78701

CACTUSS - North 5-15

Tonight's presentation will be from AJ Mendo.

The session is titled "
Without A SQLTrace - Getting To Know Extended Events

If you have wanted to learn how to use Extended Events and have had a hard time trying to figure out where to start then this session is for you. This session is designed for someone that has never used Extended Events before. After this session you will know the basics of how to setup and use this highly scalable and configurable architecture to trouble shoot server issues. You will see how to use them in SQL 2008 and how they have been beefed up in SQL 2012. This will be a demo rich session so come prepared to finally get to know Extended Events.

The meeting starts at 5:30PM CST with food and a QA session.

Main presentation is at 6:00PM CST.

Location Info:
Address:
Quarry Oaks II
10900 Stonelake Blvd., Suite 225
Austin, TX 78759

Hope to see you there!

CACTUSS - North 4/17

Steve Ormrod will be presenting this month.

Losing your memory is never fun. 
Well, I can't help you with that, but I can help show you how SQL Server is using its memory and some things to look at with regards to performance problems.

When I started as a DBA I didn't know much about SQL Server internals.  I inherited quite a few servers and they were experiencing performance problems.  Over time I learned more about the internals and how to troubleshoot systems.  I'll share some stories with you and talk about some of the methods I use to look at how SQL Server is using its memory.  Then we'll look at some examples and demo code.

Steven is a Database Administrator for a global provider of orthotics and prosthetics. He focuses on clustering and consolidation projects, with a dash of performance tuning thrown in for fun. His environments contain hundreds of servers spread across multiple countries. In a previous life, he has been a Software Developer, SysAdmin, and a Teacher. Once upon a summer, he hitchhiked and bartended his way across Europe. When not breaking technology, he enjoys cooking, traveling, and snorkeling. He has a Bachelors of Science in Computer Science and a Masters in Educational Administration. Certifications include MCITP SQL 2008: Database Administration, Development; MCTS SQL 2008: BI Development.

The meeting starts at 5:30PM CST with food and a QA session.

Main presentation is at 6:00PM CST.

Location Info:
Address:
Quarry Oaks II
10900 Stonelake Blvd., Suite 225
Austin, TX 78759

Hope to see you there!

CACTUSS Central - 4/16

Jim Murphy will be presenting this month.

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 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., a managed DBA service provider for smaller companies who do not need a full-time DBA. He has been in technology and programming for over 20 years and a consultant for over 10 years. Jim's background is in database administration and .NET development. SQLWatchmen has a staff of DBA's for round-the-clock part-time monitoring.

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

Location Info:
*Parking is street parking, so anywhere you can find around the building
Experis IT
301 Congress Avenue, Suite 375
Austin, TX 78701

CACTUSS North - March 20th

Tonight AJ Mendo will be presenting

Work Smarter Not Harder
Standardize Your Environment With Best Practices

Are all your servers standardized across your environment? Do you manually click the next button when installing SQL Server? Do you manually create and configuring your routine maintenance? Are your SQL Agent Jobs owned by other DBAs in your group? Do you know when jobs fail? Or discover them accidentally? Do you have a standardized way to deploy updates?

We will discuss all these things and some others during this session and hopefully when we come out the other side some of this will make your life easier.

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

 Location Information

Address:
Quarry Oaks II
10900 Stonelake Blvd., Suite 225
Austin, TX 78759

Hope to see you there!

CACTUSS Central - March 19th

This month Steven Ormrod will be presenting on

Clustering, without the Charlie Foxtrot

So you wanna do the Cluster, but you're afraid all your moves look more like the Charlie Foxtrot?  Relax, take some dancing lessons, and learn some tips and tricks for managing SQL Failover Clusters. 

Doing the Charlie Foxtrot may be all the rage at the club, but in your data center, that's another matter. Building Clusters is a multi-discipline process that requires cooperation from multiple teams.

There is a lot of confusion about what SQL Clusters are and what they can do for you. We'll talk about some of the myths and realities. Then, we'll discuss how Clusters can help your environment.

Next, we'll discuss some of the resources you need to have laid out ahead of time to help ensure you have a successful clustering project.

I will share some of my own practices and tips for setting up and configuring the Cluster and the SQL Instances.

Bio

Steven is a Database Administrator for a global provider of orthotics and prosthetics. He focuses on clustering and consolidation projects, with a dash of performance tuning thrown in for fun. His environments contain hundreds of servers spread across multiple countries. In a previous life, he has been a Software Developer, SysAdmin, and a Teacher. Once upon a summer, he hitchhiked and bartended his way across Europe. When not breaking technology, he enjoys cooking, traveling, and snorkeling. He has a Bachelors of Science in Computer Science and a Masters in Educational Administration. Certifications include MCITP SQL 2008: Database Administration, Development; MCTS SQL 2008: BI Development.

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 - Meeting 2/21

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

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

Location Information

Address:
Quarry Oaks II
10900 Stonelake Blvd., Suite 225
Austin, TX 78759