Welcome - You are not logged in
Announcements
Our Next Meeting is August 5, 2008 (From opass.org)
Our next meeting will be held August 5, 2008, at the offices of End to End Training. Dolores Tofel will be giving a mini presentation on using Access as a front end to SQL Server, followed by EMC presenting on SAN performance tuning. As always we'll send out reminders prior to the event!
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..."
August 2008 Speaker Announcement (From opass.org)
We've scored a coup! Two speakers from EMC will visit to talk about SAN performance and SQL Server.
Mass SQL Injections (From www.f-secure.com)
There's another round of mass SQL injections going on which has infected hundreds of thousands of websites.
Microsoft Confirms SQL Server 2005 SP3 (From www.crn.com)
Microsoft (NSDQ:MSFT) on Tuesday confirmed that it plans to release a third service pack for SQL Server 2005 by the end of the year.
In a Tuesday blog post, Francois Ajenstat, Microsoft 's director of SQL Server marketing, announced that Microsoft will deliver SQL Server 2005 SP3 after the release to manufacturing of SQL Server 2008, which is currently slated for Q3.
oPASS June 2008 Meeting Announcement (From opass.org)
Our next oPASS meeting will be Jun 3rd, 2008, from 6-8 pm at the offices of End to End Trainig, 225 S Westmonte Dr Ste 2010, Altamonte Springs, FL. We'll be discussing the upcoming SQLSaturday #4 and our guest speaker will be Steve Lasker on SQL Server Compact - something that we DBA's need to know more about!
Cumulative Update 7 for SQL 2005 SP2 Available (From support.microsoft.com)
Cumulative updates have all the fixes since the last service pack - download it today!
SQLSaturday #3 Jacksonville Recap (From pragmaticworks.com)
Link to Brian Knights blog with comments about the recent SQLSaturday in Jacksonville.
SQLSaturday #4 - Tweener Orlando (From opass.org)
It's the great event with the strange name! Click the link to find out how to get TWO days of free training in June.