SQL Server Innovators Guild

Current Articles | Categories | Search | Syndication

Monday, July 16, 2007

August 7th Meeting: Designing a Dimensional Model
By pwaters @ 9:38 PM :: 646 Views :: 0 Comments :: Meetings

Agenda

6:00 - 6:30 - Pizza, Soda and Networking Sponsored by ApexSQL

6:30 - 6:45 - Announcements

6:45 - 8:20 - Presentations

ApexSQL Developer Studio

Designing a Dimensional Model

8:20 - 8:30 - Give-a-ways

Again we have some great SWAG for this meeting. As well as our usual free pizza, soda, and a great mix of people worth getting to know.

It has been awhile since our last meeting and even though it is hot and muggy outside summer is almost over. Some of our "regulars" might be on vacation, so make sure you tell a friend or colleague about this meeting. It is even manager and business analyst friendly, so do not exclude them.

You will especially want your manager to see the first segment. Our sponsor for this meeting is SQLApex and they asked me to give a 15 minute overview of one or two of the tools in their APEX SQL Developer Studio. In exchange for doing this they gave us a copy to give away at the meeting. This is about a $1300 value. I have been using the studio for about 3 weeks and I am kicking myself for not getting it sooner. If you bring your manager (make sure he or she has purchasing authority) , and they understand that time is money, you will greatly increase your chances of them buying this for at work.

Our main presentation; "Designing a Dimensional Model."

Business Intelligence (BI) is one of the fastest growing segments in information technology today. In large part due to demands placed on business to innovate fast and get information to the right people at the right time. Also fueling the trend is the sudden proliferation of BI and analytical tools at a price-point that even small and medium sized companies can afford. At the heart of an efficient , responsive and flexible BI solution is a dimensional model. Even if you just need to make your reporting system more efficient and do not have lofty goals of Business Scorecarding with Key Performance Indicators (KPIs) or creating forecasting models with data mining algorithms, knowing how and when to create a dimensional model is a must have skill in the 21st century.

This will be a manager and business analyst friendly presentation so invite one to come along.

Tuesday, May 08, 2007

June 5th Meeting - The Microsoft BI Dashboard
By pwaters @ 8:53 PM :: 1384 Views :: 0 Comments :: Meetings

This presentation by Jason Burton will feature the use of SharePoint and ProClarity to create Business Intelligence Dashboads for your organization.

More details to come.

Thursday, April 19, 2007

May 1st - SQL Server Replication
By pwaters @ 4:46 AM :: 894 Views :: 0 Comments :: Meetings

Learn about the different replication features that are available in SQL Server 2005

Presented by Denise Bice of Progressive Software Solutions

Agenda
6:00 - 6:30 - Pizza, Soda and Networking Sponsored by DP Professionals
6:30 - 6:45 - Announcements
6:45 - 8:15 - Presentations
8:15 - 8:20 - Give-a-ways

Monday, April 02, 2007

April 3rd, 2007 Meeting: Triple Feature
By pwaters @ 12:19 AM :: 801 Views :: 0 Comments :: Meetings

Not one, not two, but three presentations for your SQL Server skills enhancement pleasure.

Introduction to SQL Compact Edition – Al Gonzalez
Creating a PDF file from a stored procedure – Rick Casebere
Intoduction to HTTP Endpoints in SQL Server 2005 – Paul S. Waters

Agenda
6:00 - 6:30 - Pizza, Soda and Networking
6:30 - 6:45 - Announcements
6:45 - 8:15 - Presentations
8:15 - 8:20 - Give-a-ways

Tuesday, February 20, 2007

March 6th 2007 Meeting: Top 10 Tips for Performance Tuning
By pwaters @ 1:04 AM :: 855 Views :: 0 Comments :: Meetings

Top 10 tips for performance tuning of SQL server including index performance, isolating poor code, trend analysis and baselining using the native SQL 2005 tools.

To regester please go to http://ssig03062007.eventbrite.com/

In depth analysis of the top 10 performance tips for SQL Server including SQL 2005. We will explore best approaches for monitoring and obtaining information from SQL Server and considering hardware, benchmarking, approaches to collection of statistics, using the Index Tuning Wizard and the Database Engine Tuning Advisor, identifying poor performing code, and analyzing SQL Server jobs.

Presenter
Jeremy Gaige, Sr. Consultant, Idera
Jeremy Gaige has over 10 years experience in enterprise management frameworks, specialized monitoring tools and systems administration including SQL Server. Mr. Gaige has a wide variety of experiences including consulting, training, and worldwide implementations of framework tools like NetIQ AppManager, Microsoft Operations Manager, and Tivoli. More recently with Idera, Mr. Gaige has been working with SQL Server implementations worldwide in SQL performance monitoring and administration.
website http://www.idera.com/

Giveaways
Idera will give away Idera licenses, so make sure you come, you could be a lucky winner

50% Promotion
Idera will offer all attendees a 50% discount on one (1) license of each of the following products purchased by March 30, 2007:
SQL diagnostic manager, SQL change manager, SQLconfig, SQL compliance manager, SQLsecure, SQLsafe, SQL mobile manager,SQL schedule

OFFER EXPIRES MARCH 30, 2007 AND ONLY GOOD FOR ATTENDEES OF THE MARCH 6, 2007 SQL SERVER INNOVATORS GUILD (SSIG) MEETING

If you are interested in an Idera Sr. Consultant to present to your team; please email Shelby Barras at shelby.barras@idera.com.

Sunday, February 04, 2007

February 6th 2007 Meeting: CANCELED
By pwaters @ 12:12 PM :: 915 Views :: 0 Comments :: Meetings

The February meeting has been canceled. This is the first time we have canceled a scheduled meeting and I will do my best to make sure it does not happen again.

We have a great meeting shaping up for March, so I hope to see you then.

Friday, November 24, 2006

December 5th Meeting: SQL Server Mgmt Studio 2005 & TSQL Tips
By pwaters @ 12:57 PM :: 1707 Views :: 0 Comments :: Meetings

For our main event Billy Cooper from Tiba Solutions will be presenting SQL Server Mgmt Studio 2005 & T-SQL Tips. This presentation is similar to the one he gave at SC Code Camp 2.0. If you saw him present, I am sure you will want to come see him again, and if you missed him at Code Camp you will not want to miss your second chance to learn from Billy this time.

For our warm up Rick Casebere will give a 10 minute presentation titled "Generating Test Data Using SQL Server".

We will have more details on the December 5th meeting as the day gets closer.

Monday, July 31, 2006

August 1st, 2006 Meeting
By pwaters @ 10:38 PM :: 940 Views :: 0 Comments :: Meetings

6:00pm Pizza sponsored by MDI (http://www.mdigroup.com/ )

6:30pm Announcements
6:45pm Presentations begin

SQL Server Tips, Tricks, and Challenges (15 – 30 Minutes)

T-SQL PIVOT and UNPIVOT, Scott Klein (20 – 30 Minutes)

Report Viewer Control: The Trials and Tribulations of a Real World Implementation, Mark Essex and Paul S. Waters (30 – 40 Minutes)

8:30pm Close of meeting and give-a-ways