This discussion will cover how to troubleshoot performance issues on SQL Server 2005 and SQL Server 2008. In this discussion I cover performance impact analysis using DMVs, SET options in SQL Server, and Profiler and perfmon analysis. In this discussion I will cover SQLNexus, PAL (Performance Analysis of Logs), RML Utilities, SQLDiag, and other tools. Finally I discuss reading query plans graphically and what you can learn from reading the XML plans. 

SQL Azure is a true relational database in the cloud.  Joe will be talking about SQL Azure firewall, logins and passwords, Database creation, deployments and migrations, Database management using SQL Management Studio and Programming against SQL Azure databases. 

SQL Saturday is this Saturday in Tampa. Are you going to? Need a ride? Contact one Chris or Bonnie for more information. Hope to see you there! 

We had a great turn out for Scott's presentation on Entity Framework. Lot's of questions from the crowd and some good discussions. We gave away a wireless mouse and a copy of Windows 7. We're looking forward to seeing even more folks next month for Joe Healy on SQL Azure. 

Scott Klein is a SQL Server MVP with a passion for all things SQL Server and .NET. Scott has authored several books including Professional SQL Server 2005 XML and Professional LINQ by Wrox, and is currently authoring a book on the ADO.NET 4.0 Entity Framework for APress. Scott runs the South Florida SQL Server User groups and the South Florida SQL Saturday. His focus (besides the Entity Framework) is SQL performance tuning and BI/DW. He also is heavily involved in the SQL Azure area. 

Interested in speaking? First time speakers welcome. Got a presentation for SQL Saturday in Tampa and need a dry run? Please contact us! 

We've decided to use Pizza Gallery for the Christmas Social on Thursday December 10, 2009.  We've got a bar inside and outside plus a good menu.  We'll show up and see how many people we have.  We can decide then on hanging in the bar or getting tables.  Hope to see everyone there at 6:30pm.

 

SQL Saturday #23 is set for January 23rd in Tampa and they're looking for speakers.  So!  Sign up and represent the Space Coast! It's a great opportunity to share your expertise and gain speakin experience.  Not ready to do it on your own?  Partner up with somebody or propose a mini-session.  Regardless, we'll see you there!

 read more ...

The November meeting with James McAuliffe and sponsored by Catapult Systems was a huge success.  There was ample Pizza and a presentation that felt more like a converation with your SQL 2008 friend.  Plus some nice swag (1GB Key drives) was given away and some reserved for later meetings. 

 

 

 

Joe Healy sat down with Andy Warren at SQL Saturday #21 for this interview & recap.  See if you can spot the Space Coast SQL User Group members in the video. http://channel9.msdn.com/posts/dpeeast/SQL-Saturday-21-Orlando-October-2009/

 

Over a half dozen folks from the Space Coast SQL User Group attended SQL Saturday #21 in Orlando.  The presentations were great along with plenty of swag.  There were world class speakers along side your local community members presenting over 50 sessions.  Local Microsoft Developer Evangelist Joe Healy (aka DevFish) snapped some photos and has shared them with us here.  He manged to capture a bunch of the Space Coast folks togeather.  Thanks to Group President Bonnie for driving her van.  It was appreciated by those who participated in the post-event social at Jax 5th Ave.

 

James McCauliffe will be talking about the new features and data types in SQL Server 2008 and how they will change your life.

James McAuliffe is a Senior Consultant for Catapult Systems. He has been working as a professional software developer since 1993, using a variety of database development tools on the Microsoft stack, and has worked with clients of all sizes, from local businesses to Fortune 500 companies. James has been using SQL Server since 1999, with a recent concentration on the Business Intelligence methodologies. He is excited to share about the capabilities that the Team Foundation System brings to database design and deployment.

 

Want to go to SQL Saturday in Orlando on October 17th? Don't want to drive? Space Coast SQL User Group is forming a car pool! Chip in a few bucks for gas and enjoy a worry free ride (unless Bonnie is driving). For more information email spacecoast@sqlpass.org.

 

Slowly Changing Dimensions (SCDs) are a common in BI implementations, however they still manage to confound many developers when they come to implement them. This presentation takes a look at what SSIS does to help us handle them more effectively followed by a demonstration of implementing varios types of SCD's in SSIS.

Chris Loris is a Software Engineer currently working in Data Warehousing, BI and BizTalk middleware at Harris Corporation.  In the past  Chris has worked as an ASP.Net developer, Engineering Manager, Professional Services Engineer, Test Engineer and a Technical Writer.  He's been active in the Microsoft Developer Community for over 6 years and enjoys giving whatever free time he has to it.  He lives in Viera, Florida with his wife, daughter and no dogs because he's allergic. Register Here!

 

Christian Loris has been appointed the Director of Communications for the Space Coast SQL User Group.  Christian is a local Software Engineer and speaks at local community events on topics ranging from Software Development to Data Warehousing.  He'll be responsible for maintaining the group's web site and facilitating communication with members.

 

Beginning with SQL Server 2005 Microsoft included a Default Trace auditing many events. This trace is used by many of the reports included with SSMS and can be mined for information about who has logged into your server, who created/changed/dropped objects, and much more! Learn how to use this resource to audit and manage your SQL Servers!

Jack has been working with SQL Server since 1999 and have worked with versions 6.5 - 2005. He is experienced in VB 6 and .NET (ASP.NET, VB.NET, C#). He is currently working as a Software Developer for New Tribes Mission (www.ntm.org). He has spoken at OPASS, TBBSUG, SQLSaturday #8 - Orlando, and SQLSaturday #14 - Pensacola, written several articles for SQLServerCentral and is one of the more active forum participants. He is also the author of a video series on Profiler available on JumpstartTV. Check out his blog at: http://www.wiseman-wiseguy.blogspot.com.