Welcome - You are not logged in
Announcements
Next oPASS Meeting is Sep 9, 2008 (From opass.org)
Our next meeting will be held September 9, 2008, from 6-8 pm at the offices of End To End Training, 225 S Westmonte Dr, Ste 2010, Altamonte Springs, FL. Our featured speaker will be oPASS member and frequent SQLServerCentral.com contributor Jack Corbett who will be explaining the basics (and a few power user techniques) of SQL Profiler. Whether you're a developer or DBA having a basic understanding of what Profiler does, how to make sense of the information it gives you, and how to use it for debugging are valuable skills!
Pizza and drinks to be provided by a sponsor yet to be determined - but there will be pizza!
SQLSaturday #8 in Orlando on October 25, 2008 (From opass.org)
Our second annual SQLSaturday! Click the links for more details.
TekSystems to Sponsor September 2008 oPASS Meeting (From opass.org)
Many thanks to Erin & TekSystems for sponsoring our September meeting. Thanks to them we'll be able to enjoy a great technical presentation by Jack Corbett AND pizza too!
Cross Tabs and Pivots, Part 1 ? Converting Rows to Columns (From SQLServerCentral)
The purpose of this article is to provide an introduction to Cross Tabs and Pivots and how they can be used to "rotate" data...
I looked for a definition of what a "Cross Tab" actually is and, after a slight modification, couldn't find a better one than what's in SQL Server 2000 Books Online...
"Sometimes it is necessary to rotate results so that [the data in] columns are presented horizontally and [the data in] rows are presented vertically. This is known as creating a PivotTable®, creating a cross-tab report, or rotating data."
By Jeff Moden, 2008/08/19
Presenation Files From Top 10 Storage Problems at the Aug 2008 Meeting (From opass.org)
Files from the presentation by Amy Styers of EMC
Access Presentation from Dolores Tofel (Aug 2008 oPASS Meeting) (From opass.org)
Presentation files from Dolores
Minutes of the Aug 5, 2008 oPASS Meeting (From opass.org)
Minutes of our Aug 5, 2008 meeting
Investigating SQL Server 2008 Wait Events with XEVENTS (From www.simple-talk.com)
Investigate the concepts of performance analysis based on wait events. The idea behind this concept is to take the response time of a SQL statement (or a batch or a user session) and split it up into CPU time and Wait time..
Earlier versions of SQL Server only maintain wait time (aggregated) on the server level, or you can see the wait times and the wait reasons, and when they actually occur in views like sysprocesses or sys.dm_os_waiting_tasks. Starting with SQL Server 2005, the wait events are finally documented in the SQL Server BOL, and more and more background is provided in blogs, KB Articles, forums etc.
Avoid Untrusted Constraints in SQL Server (From www.mssqltips.com)
Some time ago, I loaded a large set of data into one my tables. To speed up the load, I disabled the FOREIGN KEY and CHECK constraints on the table and then re-enabled them after the load was complete. I am now finding that some of the loaded data was referentially invalid. What happened?
Rebuilding the SQL Server master database - Part 1 (From www.mssqltips.com)
I recently found myself in a situation where I had to rebuild the master database on one of the nodes of our development SQL 2005 cluster. The process itself is quite simple, the proof is in the preparation however. The chances things will go wrong are low, but you still need to be prepared for the possibility that your quick rebuild is anything but. The need to prepare is also critical because once you rebuild the master database you'll notice that there is a little issue involving NO LOGINS!
PASS Community Summit 2008 - Get Your Discount Now! (From summit2008.sqlpass.org)
The new Summit web site is available at http://summit2008.sqlpass.org/. Feel free to publicize this in blogs, articles, presentations, etc. Right now our biggest source of traffic is SQL Server Central. Certainly some of our Board members have lots of readers on their blogs?
The chapter member discount code is: CHM3D. You get $100 off for any chapter member that goes to the summit.
SQLSaturday#4 Reminder - Event is June 7/8 2008 (From opass.org)
Final reminder, the event is this weekend - you can still register!
Second Presentation Added to August 2008 Agenda (From opass.org)
Dolores Tofel is answering the call for more local speakers - click the link for details.
Minutes from the June 2008 oPASS meeting (From opass.org)
Minutes from the June 2008 oPASS meeting that featured Steve Lasker & Ginny Caughey doing a presentation on SQL Compact
SQL admin toolset Beta - Incredibly useful tools for SQL Server people (From www.idera.com)
24 essential desktop tools for monitoring, troubleshooting, administering and reporting on your SQL Servers. Reduces administrative tasks from hours to minutes. Eliminates time spent developing , testing and maintaining custom scripts. Value priced at $495 for all 24 tools - less than $25 a tool!
Download a free copy of the SQL admin toolset, give Idera your feedback and you'll be given the chance to purchase the final product with all 24 tools at $195.
Lengthy SQL Server Queries Will Consume Your CPU (From www.mssqltips.com)
"I suspected that long text queries (with much less than 256 MB) will create some challenge for the server's CPU. So I thought this should be tested and published in this tip. So for the scope of this tip we are trying to address these items..."