CACTUSS North - Evaluate your daily checklist against 100+ instances of SQL Server while you get a cup of coffee

Hello All!

You will walk away from this session with an understanding of how to use the Policy Based Management and Central Management Server to complete a daily checklist against your whole SQL Server farm. We will cover the basics to evaluate, monitor and apply best practice policies, which are included out of the box with SQL Server 2008. We will also make custom policies to cover additional best practices to evaluate daily checklist items. Finally, we will combine Policy-Based Management and Central Management Server with the Enterprise Policy Management Framework on codeplex to automate the monitoring process and create manager friendly reports to monitor your checklist items against the whole SQL Server farm.

Bio: John Sterrett is a database administrator at Orrick Herrington & Sutcliffe, an international law-firm, and is responsible for over 100 instances of SQL Server.  John has been active within the SQL Server community, including hosting the first SQL Saturday in West Virginia. John also presented a lightning talk and chalk-talk at the SQL Server 2010 Member Summit , presented sessions at three SQL Saturday's, and presented to the Pittsburgh SQL Server User Group.  John is a syndicated blogger at SQLServerPedia and contributes tips at MSSQLTIPS. You can find his blog at www.johnsterrett.com

The meeting starts at 6:00 PM CST with food, Introduction by Experis and a QA session. 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 - March 19 - Power to the Pivot

This month we have a special guest speaker Hope Foley
She is making her way through the area presenting here in Austin and Wednesday in San Antonio. 
Tomorrow night Hope will be presenting
Power to the Pivot - Practical Application Intro to PowerPivot 2012
Want to create snazzy reports to impress the boss but aren't a BI expert?  Don't climb the clock tower just yet, go get yourself PowerPivot 2012 and come to my session.  We'll go over some very real world issues and ways PowerPivot can help solve it.  Demos will be filled with many of the new features in 2012 at same time giving you a good base to get you started using this great tool.  And this session wouldn't be complete without covering BISM.  We will definitely will cover how the BI world is all coming together as one to have hold and cherish in the BI Semantic Model. We will work through demos together covering 10 different functional uses within this tool to help start you down the path of self- service BI. 
 
Hope has over 12 years experience in the IT world, and  has worked across many industries including small business enterprises, startups, and Fortune 500 companies, and has a vast knowledge of database design, administration and support, data warehousing and data mining, and custom database solutions. She  joined PTI in 2007 as a SQL Server Database Administrator/Analyst consultant and in 2009 took over as Principal Microsoft Consultant, where she now leads a team of expert Database Administrators and Developers. Hope is a SQL Server MVP and an active member within the SQL Server community.  Hope blogs at http://www.hopefoley.com/ and http://lessthandot.com/.  You can follow her on Twitter @hope_foley.

CACTUSS NORTH:
We meet every third Tuesday at the Microsoft South Central District offices.
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
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.
Come out and give Hope a warm welcome to Texas.
 

 

CACTUSS Central 2/18 and North 2/19 - Temporal Data and Tricks in SQL

 This month Joe Celko will be presenting Temporal Data and Tricks in SQL 

Joe will present to CACTUSS Central on Monday 2/18 and CACTUSS North on Tuesday 2/19

Temporal Data and Tricks in SQL
  • The Nature of Time
  • The ISO Model of Time
  • The ISO-8601 Standards
  • The Calendar Table
  • Report Periods Table 
  • Contiguous Time Periods with New Aggregate Functions
Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards.  He is author of nine books on SQL for Morgan-Kaufmann. He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.

CACTUSS CENTRAL:
We meet every third Monday at the Experis Austin offices
www.bing.com/maps/

The meeting starts at 6:00 PM with the main presentation starting 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:
We meet every third 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.
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.

CACTUSS Central - Monday 1/21

As we all know CACTUSS meets on the 3rd Monday and Tuesday each month. This is a weird month in which they are in different weeks. So CACTUSS Central in this Monday 1/21/2013 with John Sterrett presenting. John has recently moved to the area and is now a member of CACTUSS so come on out and welcome him.

Performance Tuning for Pirates

If you follow baseball you will notice that the Pittsburgh Pirates (this speaker's favorite team) has to do more with less to be successful. This trend can also exist within IT shops. If you need to improve the performance of your SQL Server instances and cannot purchase 3rd party tools this session is for you. You will learn how to improve your performance tuning process by using several free tools. This session will cover wait stats, dynamic management objects, perfmon, PAL, SQL Trace, ClearTrace, SQL Nexus and SQLDiag. 

John Sterrett has been active within the SQL Server community. He is a PASS Regional Mentor for the South Central Region, co-founded the West Virginia SQL Server User Group and hosted two PASS SQL Saturday events in West Virginia. John has presented at several SQL Server events including PASS SQLRally Orlando, PASS Summit 2011, SQL Server 2010 Member Summit, many PASS SQL Saturday events, code camps, and, user groups. John is a syndicated blogger at SQLServerPedia, contributes tips at MSSQLTIPS.

CACTUSS CENTRAL:
We meet every third Monday at the Experis Austin offices
www.bing.com/maps/

The meeting starts at 6:00 PM with the main presentation starting 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 - January 15 - Performance Tuning for Pirates

This month we are pleased to announce John Sterrett will be presenting. John has recently moved to the area and is now a member of CACTUSS so come on out and welcome him.

Performance Tuning for Pirates

If you follow baseball you will notice that the Pittsburgh Pirates (this speaker's favorite team) has to do more with less to be successful. This trend can also exist within IT shops. If you need to improve the performance of your SQL Server instances and cannot purchase 3rd party tools this session is for you. You will learn how to improve your performance tuning process by using several free tools. This session will cover wait stats, dynamic management objects, perfmon, PAL, SQL Trace, ClearTrace, SQL Nexus and SQLDiag. 

John Sterrett has been active within the SQL Server community. He is a PASS Regional Mentor for the South Central Region, co-founded the West Virginia SQL Server User Group and hosted two PASS SQL Saturday events in West Virginia. John has presented at several SQL Server events including PASS SQLRally Orlando, PASS Summit 2011, SQL Server 2010 Member Summit, many PASS SQL Saturday events, code camps, and, user groups. John is a syndicated blogger at SQLServerPedia, contributes tips at MSSQLTIPS.


CACTUSS NORTH:

We meet every third 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.

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.

CACTUSS North - Tuesday December 18

We have a special treat this month with the one and only Wes Brown speaking.

Wes will be talking about, Whats new in 2012 
This presentation will be a high level overview of all the new features and enhancements shipping with 2012.

Wesley Brown 
Senior Lead Consultant, Catapult Systems

Wesley Brown is a SQL Server MVP and PASS Chapter Leader who loves to teach others about SQL Server. He writes for SQL Server Central and maintains his technical blog at http://www.sqlserverio.com. Wes specializes in high availability, disaster recovery, and large-scale database performance tuning and is currently a Senior Lead Consultant for Catapult Systems. His previous experience includes serving as Product Manager for Quest Software's SQL Litespeed and as consultant to several Fortune 500 companies. You can find Wes frequently speaking at local user groups and SQLSaturdays.

Hope to see you there.

CACTUSS NORTH:

We meet every third 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.

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.

CACTUSS Central Monday 11/19 and CACTUSS North Tuesday 11/20

Eric Cox will be presenting this month on T-SQL Window Functions

Window Functions 101
What are they and why should I care?


If I had to name one concept in standard SQL that I thought was the most important one...
I'd say window functions, hands down, without a doubt.
-- Itzik Ben-Gan

My goal is for everyone to leave with both the knowledge and passion to use window functions in your current projects. Since most people haven't upgraded to 2012 all the examples will be in SQL Server 2008 R2.
We won't begin to cover all the nuances and syntax but rather will focus on a few simple and useful examples with broad application.

Note:  In a future talk I'll expand on this to discuss SQL Server 2012's additional functions and the syntax variations.

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

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

The meeting starts at 6:00 PM with the main presentation starting 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:

We meet every third 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.

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.

CACTUSS Central Monday 10/15 and North Tuesday 10/16 - PowerShell and SQL Server

John Rutherford will be presenting this month on 

PowerShell and SQL Server

PowerShell is a powerful tool that Microsoft is committed to integrating into all of it's server products and SQL Server is no exception. This presentation will not spend too much time on basic PowerShell commands but rather show you how you can use it to help administer and maintain multiple SQL Servers. I will show you some demos of how you can start using PowerShell to talk to your existing SQL servers. You do not need any previous PowerShell experience to understand the concepts and demos in this presentation.

John Rutherford is an IT Manager/Database Administrator for a mid-sized Orthopedics company and currently maintains 75 MS SQL Servers . He has been working with Database Systems since he started in IT over 14 years ago and has been working with MS SQL Server for the past 3 years. He has been working with various programming/scripting languages his entire career but has only this year discovered PowerShell and started to use it in conjunction with SQL Server.

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

The meeting starts at 6:00 PM with the main presentation starting 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:

We meet every third 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.

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.

CACTUSS Central Monday 9/17 and North Tuesday 9/18 - Database Mirroring 101

This month's presentation is on Database Mirroring and will be presented by Paul LaGrone

Database Mirroring 101:

1) the concepts for setting up a two node mirroring environment, with and without a witness;
2) demonstrate how to configure a mirror, with witness, through the GUI and through T-SQL;
3) discuss some of the pros and cons of database mirroring versus database clustering;
4) do my best to field questions along the way. :)

Paul has been working with SQL Server since version 6.5, and other microcomputer databases since well before that. He earned MCT in 2003, and used it to teach SQL Server to new developers and administrators for the City of Fort Worth. In 2006, Paul started a SQL Server user's group in Fort Worth, which still thrives today.
Currently, he work as a DBA for Marketvine by Dell, which is a social e-commerce site incubated within Dell.

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

The meeting starts at 6:00 PM with the main presentation starting 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:

We meet every third 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.

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.

Hope to see ya'll there!

Cheers!

CACTUSS North - Meeting tonight 8/21

Wes Brown will be presenting tonight on 

"Fudging the numbers, playing with benchmarks to get the best results"

CACTUSS North:
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