Ramblings of a DBA

Tara Kizer
posts - 165, comments - 832, trackbacks - 75

My Links

Advertisement

News

Subscribe
Search this Blog

Archives

Post Categories

Work

September 2005 Blog Posts

PASS 2005: Session notes/comments Part 3

Once again, I attended 3 sessions today (Friday): Kevin Kline's "Performance Baselining, Benchmarking, and Monitoring", Tom Davidson's "SQL Server 2005: Dynamic Management Views", and Ross LoForte's "Optimization Considerations for Designing Very Large SQL Server Database Systems". Kevin is a great speaker.  He went into detail on how to do proactive monitoring.  You start with a baseline, which is what is normal for the server.  It includes number of concurrent users, Performance Monitor counter averages, system processes, and much more.  He also showed us some exception monitoring, which is exceptions to the baseline.  It uses limited performance monitoring, more alerts, and heavy...

posted @ Friday, September 30, 2005 3:49 PM | Feedback (5) | Filed Under [ SQL Server - PASS ]

PASS 2005: My Experience

Wow, what a great experience! Everyone here has been so friendly.  It was nice to put faces to names even for people I didn't actually meet.  I hope that I can attend another PASS conference some time in the near future and perhaps finally meet up with Nigel Rivett (I never did find him). The only negative that I have about the conference is that some of the sessions weren't advanced enough even though I attended the ones in the 400 Series.  Overall though, it was truly an amazing event.  I certainly would recommend it to anyone who wants to go to...

posted @ Friday, September 30, 2005 3:32 PM | Feedback (3) | Filed Under [ SQL Server - PASS ]

PASS 2005: Session notes/comments Part 2

At the "General Session" today (Thursday), we saw a demo of the Upgrade Advisor tool which is used to prepare for the SQL Server 2005 upgrade.  It'll show you what you need to change prior to the upgrade and what you can change after the upgrade.  An example of something that you can change after the upgrade is the use of *= and =* for OUTER JOINs.  This syntax has been deprecated in the 90 compatibility mode.  Upgrade Advisor requires .NET Framework 2.0. We also saw a demo of the reports available in Management Studio.  I really like the schema change...

posted @ Thursday, September 29, 2005 7:18 PM | Feedback (2) | Filed Under [ SQL Server - PASS ]

PASS 2005: Session notes/comments Part 1

On Tuesday, I attended Kimberly Tripp's "The Next Generation DBA: Critical New SQL Server Features NEED to Learn!" pre-conference seminar.  It was awesome!  She is a fantastic speaker.  She covered database snapshots and database mirroring amongst many other DBA topics.  I see my company using database snapshots so that developers can quickly query production data without querying the production database and also without having to copy the database to a development server.  Even though log shipping still exists in SQL Server 2005, I think we'll be switching over to database mirroring to sync our disaster recovery site.  Database mirroring won't...

posted @ Thursday, September 29, 2005 6:22 PM | Feedback (5) | Filed Under [ SQL Server - PASS ]

PASS 2005: Exhibits, Swag, and SQLTeamers

During the "General Session" today (Wednesday), they threw out SQL Server 2005 t-shirts.  Almost everyone got one.  All of the t-shirts were black and had a verb on the back.  Mine says "Replicate".  I would have preferred "Analyze" or "Query" due to my disdain for replication.  Maybe I'll be able to swindle someone into a trade. I saw a demo of Red-Gate's SQL Log Rescue.  For that, I got a free t-shirt.  The product looks interesting enough that I'll probably download the free trial.  We are already using SQL Compare and SQL Data Compare. I also got a free t-shirt from HP,...

posted @ Wednesday, September 28, 2005 4:13 PM | Feedback (7) | Filed Under [ SQL Server - PASS ]

Powered by:
Powered By Subtext Powered By ASP.NET