- Home
- Subcribe to Newsletter
- Sponsors
- SQLSaturday Austin
- Meeting Location and Directions
- Speaker Calendar
-
CACTUSS Central - 5/21 - Introduction to SSIS
Nathan Wimberley will be presenting this monthIntroduction to SSISSQL 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 PMLocation Info:
*Parking is street parking, so anywhere you can find around the building
Experis IT
301 Congress Avenue, Suite 375
Austin, TX 78701CACTUSS - 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 78759Hope 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 78759Hope 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 PMLocation Info:
*Parking is street parking, so anywhere you can find around the building
Experis IT
301 Congress Avenue, Suite 375
Austin, TX 78701CACTUSS North - March 20th
(download)
Tonight AJ Mendo will be presenting
Work Smarter Not Harder
Standardize Your Environment With Best PracticesAre 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 78759Hope 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.
Location InformationParking is street parking, so anywhere you can find around the buildingThe meeting starts at 6:00 PM CST with food and open discussion. Main presentation starts at 6:30 PM
Address:
Experis IT
301 Congress Avenue, Suite 375
Austin, TX 78701CACTUSS North - Meeting 2/21
Eric Cox will be presenting this month at CACTUSS Central.Hold that thought...short term storage200 LevelI suffer from short term memory loss. It runs in my family... At least I think it does... Where are they?-- Dory, Finding NemoThere 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 warehousingThe meeting starts at 5:30PM CST with food and a QA session. Main presentation is at 6:00PM CST.Location InformationAddress:
Quarry Oaks II
10900 Stonelake Blvd., Suite 225
Austin, TX 78759CACTUSS Central - Meeting 2/20
Eric Cox will be presenting this month at CACTUSS Central.Hold that thought...short term storage200 LevelI suffer from short term memory loss. It runs in my family... At least I think it does... Where are they?-- Dory, Finding NemoThere 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 warehousingLocation InformationParking 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
Address:
Experis IT
301 Congress Avenue, Suite 375
Austin, TX 78701CACTUSS North - Tuesday January 17th
Wes Brown will be speaking this month on Benchmarking, Baselines and Monitoring StorageBenchmarking, 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 5:30PM CST with food and a QA session.(download)
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-8498VISITOR 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 Central - Monday January 16th
Wes Brown will be speaking this month on Benchmarking, Baselines and Monitoring StorageBenchmarking, 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 PMRemember, 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 -
Welcome to CACTUSS
The Capitol Area, Central Texas Users of SQL Server
Capitol Area Central Texas Users of SQL Server. Based in Austin, Texas we are here to serve and educate the SQL Server community!
