Ramblings of a DBA

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

My Links

Advertisement

News

Subscribe
Search this Blog

Archives

Post Categories

Work

SQL Server - PASS

PASS Summit 2011 – Part IV

This is the final blog for my PASS Summit 2011 series.  Well okay, a mini-series, I guess. On the last day of the conference, I attended Keith Elmore’ and Boris Baryshnikov’s (both from Microsoft) “Introducing the Microsoft SQL Server Code Named “Denali” Performance Dashboard Reports, Jeremiah Peschka’s (blog|twitter) “Rewrite your T-SQL for Great Good!”, and Kimberly Tripp’s (blog|twitter) “Isolated Disasters in VLDBs”. Keith and Boris talked about the lifecycle of a session, figuring out the running time and the waiting time.  They pointed out the transient nature of the reports.  You could be drilling into it to uncover...

posted @ Friday, November 11, 2011 2:04 PM | Feedback (2) | Filed Under [ SQL Server - Database Administration SQL Server - PASS ]

PASS Summit 2011 – Part III

Well we’re about a month past PASS Summit 2011, and yet I haven’t finished blogging my notes! Between work and home life, I haven’t been able to come up for air in a bit.  Now on to my notes… On Thursday of the PASS Summit 2011, I attended Klaus Aschenbrenner’s (blog|twitter) “Advanced SQL Server 2008 Troubleshooting”, Joe Webb’s (blog|twitter) “SQL Server Locking & Blocking Made Simple”, Kalen Delaney’s (blog|twitter) “What Happened? Exploring the Plan Cache”, and Paul Randal’s (blog|twitter) “More DBA Mythbusters”.  I think my head grew two times in size from the Thursday sessions.  Just WOW! I...

posted @ Friday, November 11, 2011 12:22 PM | Feedback (1) | Filed Under [ SQL Server - Database Administration SQL Server - PASS ]

PASS Summit 2011 – Part II

I arrived in Seattle last Monday afternoon to attend PASS Summit 2011.  I had really wanted to attend Gail Shaw’s (blog|twitter) and Grant Fritchey’s (blog|twitter) pre-conference seminar “All About Execution Plans” on Monday, but that would have meant flying out on Sunday which I couldn’t do.  On Tuesday, I attended Allan Hirt’s (blog|twitter) pre-conference seminar entitled “A Deep Dive into AlwaysOn: Failover Clustering and Availability Groups”.  Allan is a great speaker, and his seminar was packed with demos and information about AlwaysOn in SQL Server 2012.  Unfortunately, I have lost my notes from this seminar and the presentation...

posted @ Tuesday, October 18, 2011 8:54 PM | Feedback (1) | Filed Under [ SQL Server - PASS ]

PASS Summit 2011 – Part I

What an amazing week I had at PASS Summit 2011 in Seattle, WA!  I hadn’t attended a PASS conference since September of 2005 when it was in Grapevine, Texas.  It has grown so much since then.  I am not sure how many people attended back then, but I’d guesstimate about 1500.  They announced that at this year’s conference there were 4000 attendees.  WOW! Here are my favorite aspects of this conference: Networking! – Not only did I meet a lot of new people, but I also got to meet people in person that I’ve known...

posted @ Tuesday, October 18, 2011 10:34 AM | Feedback (0) | Filed Under [ SQL Server - PASS ]

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