Last week we completed another SQL Server Magazine/SQLConnections conference and already, it's time to start planning for the Fall show. Once again, Paul and I will be managing the SQL side of the conference and we'd like to invite you to submit abstracts for sessions at the conference. The Fall 2010 SQL Connections conference will be held in Las Vegas from November 1st through 5th (2010).

The conference will focus heavily on SQL Server 2008. Abstracts are still welcome on best practices for SQL Server 2005 and how to upgrade and migrate applications from SQL Server 200x to SQL Server 2008. However, we will consider all topics - from design to performance to troubleshooting to architectures to programming. Also, we're likely to closely follow our past conference format with three primary themes/tracks: Infrastructure and Scalability, Programming, and Business Intelligence. You should aim for the intermediate to advanced audience for any SQL Server 2005 materials and for SQL Server 2008 we'll consider any level - especially depending on the newness of the release. We're also looking at creating a "Foundations" track. It's titled: .NET Foundations but I think there's much that can be said for SQL topics and/or best practices in SQL for .NET developers.

For submitting session abstracts, please use this URL: 
http://www.deeptraining.com/devconnections/abstracts

The tool will be open from now until to April 26th (yes, just one week!), after which we won't accept any abstracts - no exceptions. If you have used this site before and have forgotten your password, you can have your secret word mailed to you. It's better to do this then to create a new account.

Please keep each abstracts under 200 words and in one paragraph. Please do not use bulleted items or line breaks, and please use a spell-checker. If you have an issue with the site, please follow up with an email to paul@sqlskills.com. Comments are disabled for this post.

Please create a new speaker record (if you haven't submitted before) and submit at least 3 abstracts; however, it will help your chances of being selected if you submit 5 or 6 abstracts. Please do not submit abstracts for sessions that you have previously presented at the Fall show.

What you will get if selected:
- $500 per conference talk. (Additional compensation for pre/post conference workshops.)
- Coach airfare and hotel stay paid by the conference
- Free admission to all of the co-located conferences
- Speaker party
- The adoration of attendees
-
etc.
 
Thanks for your continued support for our SQL Connections conference and we look forward to seeing your bright and shiny *new* abstracts!

Thanks,
Kimberly L. Tripp & Paul S. Randal
SQL Connections Conference Chairs

Coming up quickly, there are some great events to help you with best practices, tips and tricks and learning SQL Server 2008 R2 (which has just been announced to release in May this year). You can read about the upcoming R2 release on the "Data Platform Insider" blog post here.

So, how do you keep up?

A great way is through conferences (for broad tips/tricks and new features) and/or workshops/classes (for deeper content - usually with more focus) - where you can spend 3-5 days to completely focus on learning, networking and creating your new work ToDo list!

As for where we're going to be, here's our upcoming list:

March 8 - 12: Toronto, Canada - DevTeach

Here we have a precon (Indexing for Performance) and postcon (Developers Can't Ignore Database Maintenance) and 2 sessions (Optimizing Procedural Code and Tips/Tricks for Proper Table Design). This conference will be packed full of real-world advice on a variety of topics - with some SQL (more developer-oriented) - and has a lot of recognized speakers from around the world.

March 29 - April 2: Boston, MA - SQL Server Immersion: Internals, Performance, and Availability 

This is a full five day Immersion Event where we get to "make your brains hurt" (that's a quote :) with content. We delivered a similar event in Ireland (and Australia) last Fall and you can read the event report by clicking through the photo to get to the pdf. And, we're currently in the planning stages for heading back to Ireland and Australia this year as well! As for Boston - we can't wait to get back there. I lived there in the early 90s (but only for a short while before moving to Redmond) and Boston is where Paul and I met. It's a great city, we're really looking forward to it.

April 12 - 16: Las Vegas, NV - Microsoft SQL Server Conference and Expo (SQLConnections)

This year is a part of DevConnections where we have a full set of tracks solely focused on SQL Server and this year - specially focused on best practices, tips and tricks - and SQL Server 2008 R2. This conference is also focusing on the Visual Studio 2010 launch. 

We hope to see you there!
kt

Categories:
Conferences | Events

This is a bit overdue as Kevin Kline tagged me in a meme post to help people get ready for their travel to PASS. However, we were too busy with travel (we were in Australia at the time) to get to it. And, while this year's PASS has past, it's not too late for travel in general OR for next year! I suspect that a few folks are already planning for PASS, or Connections, or other business travel! So, here we go - my travel recommendations/tips.

Travel tips:
  • Join the frequent flyer program even if you're not a frequent flyer. As long as you travel within another 12 months (and sometimes even longer) your miles won't expire... Miles (for upgrades or free tickets) are always good :) and even if you're only a 2 or 3 times a year flyer - they'll add up (again, as long as you keep traveling).
  • Try to pick an airline and stick with it. The more you fly, the higher the bonuses. In fact, I'm so focused on flying just one airline that I'll often fly two flights (for example, SEA -> DEN, DEN->MCO [Orlando]) even when another airline (like American) has a direct SEA->MCO. This happens more than I would like but it also means that I get things like extra bonuses as the end of the year. For example, as I hit each 25K after 100K (ah, I really do fly *A LOT*), I get 2 extra systemwide upgrades. These allow me to upgrade (at the time of booking) for any international flight from departure to destination. So, I can upgrade SEA->MEL (even though that's actually SEA->LAX, LAX->SYD and SYD->MEL). But, systemwides are only given at the highest levels... so, you really have to fly a lot and you MUST stick with the same airline. My airline of choice: United. Also, to help you earn points faster - be sure to check the airline promotions REGULARLY. For example, many airlines offered a "double your EQM (Elite Qualifying Miles)" for Sept to Dec flight... all solely for registering. This might get you to the next level with little work! Here's United's page on promotions: http://www.united.com/page/article/1,,52102,00.html?navSource=Dropdown07&linkTitle=earnmiles.
  • When you book, start by doing some research online. Try general travel sites (Expedia, Travelocity, etc.) first but be sure to check the specific airlines as well. And, you *might* need to get creative if your itinerary is messy. Paul and I recently had to travel to Dublin and then Warsaw on the same trip but when we booked the entire set of flights the tickets were OUT OF CONTROL expensive. We ended up booking SEA->DUB and then WAW->SEA (it's called an open jaw) and we saved over 60% (no, I'm NOT kidding). Now, don't get me wrong - we spent something like 5 hours coming up with different options/combinations both online and on the phone. And, in many cases this kind of thing costs more not less so it can get tricky; it really isn't all that common but can really help. One thing of which to be aware is that connecting flights on a different ticket may cause you A LOT of grief (even though they can save you $$$). If your final destination if DUB and you purchase one RT ticket (let's say SEA to LHR) and then a separate RT ticket LHR to DUB but you plan to connect in LHR to fly immediately to DUB... some airlines/partners do NOT allow the baggage to be checked all the way through - this means that you'll need to pick up baggage in LHR and check-in again (and since this is international - it means going through customs/immigration). What this means is that you'll need more time (so pick those connections with 2-3 hours - maybe more). And, if there are any delays, etc. you won't be a high priority for them... this is where it can get messy. But, I have to admit this is something I do OFTEN. I always *try* to fly on partner airlines (meaning Star Alliance) as I have "Gold" privileges BUT, this doesn't always help (when checking in). However, it can help while en route. Again, fly the same airline/group and it does have its benefits.
  • Seats – when you book, try and get your seats assigned. And, be sure to check out your seat on SeatGuru (http://www.SeatGuru.com). If you book online (which can often offer discounts) be sure to follow up by calling the specific airline to get your seats assigned. In fact, if the price isn’t all that much better you might be MUCH better off using the specific company’s website and/or phone system so that you CAN get your seats assigned. And, in the worst case, if you can’t get your seats assigned – get to the airport EARLY (really target the 1.5-2 hour rule) and then be VERY nice to the folks that check you in… see if you can get an exit row or bulk head. Hmmmm, bulkhead seating is debatable. On some planes, bulkhead
Getting ready for travel:
  • A couple of weeks prior – go through all of your dates and itineraries and double-check everything. Once, I arrived at an airport for a flight and I had been booked on the wrong day. I remember the phone call well – I had been going back/forth about specific dates (and costs) and in the end, my E-ticket was wrong. Had I double-checked it, it wouldn’t have been a problem… Luckily, seats were available and all was well (and, I had elite status) otherwise, it could have been a nightmare!
  • Is there anything special you’re taking? Does it need to make it to the cleaner, etc.? Are you going to remember to pick it up in time? Really, planning a bit for this is important. I’ve forgotten to go to the cleaner the night before a trip only to realize that my flight is so early that I can’t even stop on the way to the airport. Now I need to go to plan b. This is why Paul creates a comprehensive “Pack List” and he’s got it online. When he thinks of something he wants to take on a trip, he updates this doc. Then, the day before he packs – he double-checks it, prints it and then starts packing. I’m pretty good at remembering most things so I haven’t done this but I have forgotten a few things over the years and travels. So, I’d really recommend this and I’m probably going to do this moving forward too!
Making the travel less painful:
  • Sleeping. Does melatonin work for you? Or, have you even tried it? If you’re crossing many time zones, you might want to pick up a bottle of this. It’s an anti-stress/herbal sleep aid and taking it right before bedtime might help you sleep better and adjust more quickly.
  • Sinus rinse. I swear by this and I honestly think this helps me avoid getting sick on some flights. I rinse my sinuses twice daily regardless of travel but given that you’re traveling with so many other folks and breathing recycled air – rinsing your sinuses can’t hurt. And, you might want to pick up some saline solution for in-flight moisture. Here's a link for the specific sinus rinse I recommend: http://www.neilmed.com/usa/products.php#isotonic. And, they have a nasal moisturizer as well: http://www.neilmed.com/usa/products.php#nasogel.
  • Flight socks. Honestly, I just recently found out about these and I LOVE them. My feet can swell up a bit while flying (I just recently had foot surgery) and now, I wear these even for shorter flights.
  • Slippers. Yes, I actually travel with wool slippers. Seriously, I get cold...really cold... And, when I travel with these they make a HUGE difference. Especially for long haul flights. These aren't hard slippers - more like thick socks (easy to pack).
  • Snack. Even if you do get an upgrade – having a snack with you might make an otherwise hungry time a lot more bearable.
  • Water. I buy water in the airport prior to boarding so that I’m never without. Flying can be very dehydrating and that will only help you get sick.
  • Entertainment. Have something ready for you to read, watch, work-on… whatever. This is always my excuse to buy the trashy mags at the airport before I board. However, I have to admit that I know fewer and fewer of the stars referenced. Not sure how I’m supposed to feel about that?! J

Well… I’ll plan to come back to this and update it with other tips/tricks as I think about them!

Safe – and happy – travels to all! And, I look forward to seeing you at an event sometime soon…if not, at PASS, or Connections again next year.

Thanks for reading!
kt

Categories:
Conferences | Opinions

Well... it's finally been released and last week was the book launch. This book came together first as a goal by Paul Nielsen who was motivated by Steve Ballmer's request that MVPs "give back" even more and even outside of the direct technical community. Paul had the idea of a book - written for charity - and contributed to by MVPs. Well, here it is!

The book contains content from 53 MVPs with Paul Nielsen, Kalen Delaney, Greg Low, Adam Machanic, Paul S. Randal and I as editors. It was great fun going through all of the content and we're really happy that it's now available!

To purchase, click on the book (to the left) and purchase directly from Manning. When purchased through Manning a larger amount of the proceeds go to WarChild.

Finally, many of us were able to get together at PASS and "launch" the book. We gathered around a long table and people (if interested) had their copies signed. It was great fun! When it was all done - we took the group shot below.

Thanks for a great week (to all that were at PASS) and for great fun working on this title!

UPDATE November 16, 2009: After a few comments, I realized that a few people were tagged incorrectly in my facebook post of this photo and as a result, I had a few names switched around too. So, I just completely started over again and double-checked all the names... Also, I've added links to their websites so you can find out more information about the authors and editors of this title. Finally, I added that purchases should be made through the Manning website instead of other sites (so that more money goes to WarChild). And, finally, I added the entire chapter list with as many links as possible to everyone's websites. I'll keep this up-to-date as folks send me corrected lnks, etc. ENJOY!!

 

Present for the photo

Here's the full chapter list from the book - along with links to the authors/editors websites:

PART I

DATABASE DESIGN AND ARCHITECTURE
Paul Nielsen, Editor

 1. Louis and Paul's 10 relational database design rules by
Paul Nielsen and Louis Davidson 
 2. SQL Server tools for maintaining data integrity by Louis Davidson
3. Finding functional dependencies by Hugo Kornelis


PART II

DATABASE DEVELOPMENT
Adam Machanic, Editor
4. Set-based iteration: the third alternative by Hugo Kornelis 
5. Gaps and islands by Itzik Ben-Gan
6. Error handling in SQL Server and applications by Bill Graziano
7. Pulling apart the FROM clause by Rob Farley
8. What makes a bulk insert a minimally logged operation? by Denis Gobo
9. Avoiding three common query mistakes by Kathi Kellenberger
10. Introduction to XQuery on SQL Server by Michael Coles
11. SQL Server XML frequently asked questions by Michael Coles
12. Using XML to transport relational data by Matija Lah
13. Full text searching by Robert C. Cain
14. Simil: an algorithm to look for similar strings by Tom van Stiphout
15. LINQ to SQL and the ADO.NET Entity Framework by Bob Beauchemin
16. Table-valued parameters by Don Kiely
17. Build your own index by Erland Sommarskog
18. Getting and staying connected—or not by William Vaughn
19. Extending your productivity in SSMS and Query Analyzer by Pawel Potasinski

20. Why every SQL developer needs to have a tools database by Denis Gobo
21. Deprecation feature by Cristian Lefter
22. Placing SQL Server in your pocket by Christopher Fairbairn
23. Mobile data strategies by John Baird



PART III

DATABASE ADMINISTRATION
Kimberly L. Tripp and Paul S. Randal, Editors

24. What does it mean to be a DBA? by Brad McGehee
25. Working with maintenance plans by Tibor Karaszi
26. PowerShell in SQL Server by Richard Siddaway
27. Automating SQL Server management using Server Management Objects by Allen White
28. Practical auditing in SQL Server 2008 by Jasper Smith
29. My favorite DMVs and why by Aaron Bertrand
30. Reusing space in a table by Joe Webb
31. Some practical issues in table partitioning by Ron Talmage
32. Partitioning for manageability (and maybe performance) by Dan Guzman
33. Faster, smaller, and more energy-efficient backups without indexes by Greg Linwood
34. Using database mirroring to become a superhero! by Glenn Berry
35. The poor man's SQL Server log shipping by Edwin Sarmiento
36. Some understated changes found in SQL Server 2005 replication by Paul Ibison
37. High performance Transactional Replication by Hilary Cotter
38. Successfully implementing Kerberos delegation by Scott Stauffer
39. Running SQL Server on Hyper-V by John Paul Cook

PART IV

PERFORMANCE TUNING AND OPTIMIZATION
Kalen Delaney, Editor
40. When is an unused index not an unused index? by Rob Farley
41. Speeding up queries with index covering by Alex Kuznetsov
42. Tracing the deadlock by Gail Shaw
43. How to optimize tempdb performance by Brad McGehee
44. Does the order of columns in an index matter? by Joe Webb
45. Correlating SQL Profiler with Windows Performance Monitor by Kevin Kline
46. Using correlation to improve query performance by Gert-Jan Strik
47. Dr. DMV: how to use Dynamic Management Views by Glenn Berry
48. Query performance and disk I/O counters by Linchi Shea
49. XEVENT: the next event infrastructure for SQL Server by Cristian Lefter



PART V

BI DEVELOPMENT
Greg Low, Editor
50. BI for the relational guy by Erin Welker
51. Unlocking the secrets of SQL Server 2008 Reporting Services by William Vaughn
52. Reporting Services tips and tricks by Bruce Loehle-Conger
53. SQL Server Audit: change tracking or change data capture? by Aaron Bertrand 
54. Introduction to SSAS data mining by Dejan Sarka
55. To aggregate or not to aggregate: is there really a question? by Erin Welker
56. Incorporating data profiling in the ETL process by John Welch
57. Expressions in SQL Server Integration Services by Matthew Roche
58. SSIS performance tips by Phil Brammer
59. Incremental loads using T-SQL and SSIS by Andy Leonard

Categories:
Conferences | Resources

We've finally booked all of our tickets and started planning final details for all our of our classes and conferences this fall. We've got quite a few things planned and tons of great content at each. By continent, here's the plan:

Europe

  • Dublin, Ireland: September 21-25. Paul and I will be teaching a week-long Immersion Event - combining internals, performance tuning, database maintenance and more.
  • Warsaw, Poland: September 29-30. Paul and I will be presenting a full day of SQL Server sessions at the Microsoft Technology Summit 2009

Australia - Melbourne

  • October 15-16. Paul and I will be teaching a 2-day class "SQL Server 2008: New Features - Updating Your Administrations Skills in Database Infrastructure and Scalability"
  • October 19-22. Paul will be teaching a 4-day class "SQL Server 2005/2008: DB Maintenance and Availability: From Performance to Disaster Recovery"
  • October 19-22. I will be teaching a 4-day class "SQL Server 2005/2008: Performance Tuning – From Design to Indexing to Optimizing Procedural Code"

US

  • Seattle, WA for SQLPASS: November 2-5. Paul and I will be teaching two full-day workshops and a Spotlight Session each.
  • Las Vegas, NV for SQL Connections: Nobember 9-12: Paul and I will be teaching two full-day workshops and 5 sessions. Stacia will be teaching 4 sessions on BI.
  • Redmond, WA for SQL MCMs and Sharepoint MCM's through the end of this year

You can find more details and links to the various registration sites on our Upcoming Events page. And, if you have any questions, feel free to email me: Kimberly AT SQLskills.com or Paul AT SQLskills.com.

We hope to see you there and be sure to swing by and say hi!

Cheers,
kt

Categories:
Conferences | Events

This morning, I woke to a wonderful email and I thought I would share it:

Good morning Kimberly, I just wanted to send you an email to let you know how awesome you are! I have applied some of your indexing strategies to our website’s homegrown CMS and we are experiencing a significant performance increase. WOW....amazing tips delivered in an exciting way! 

Thanks again,
Jim

OK, I seriously can't complain about the awesome part ;-)... but, what I think is so cool is that he sent the email. No, I don't expect everyone to send me mail after they implement a tip/trick BUT, it's really nice when I do get an email (especially like this :). There are so many ways to improve performance and some can lead to significant gains (or minimized downtime/data loss, etc.) and this is exactly why we (speakers/RDs/MVPs, etc.) do this stuff!

The long story short is that it does cost you money to go to a conference (or, at least, time to read blogs, etc.) but what we try to do at events like Connections is distill down the key points into our sessions so that you can [hopefully] apply these techniques immediately. It makes for fast-paced sessions and an information packed week but our conference just ended yesterday and I already have email from it. That's just really cool!

So, I know the economy is in a tough state and I know that quantifying the gain of a conference is hard (especially when the cost of the conference is so easy to quantify) but the end result of some of this time away might be more than worthwhile!

THANKS Jim!
kt

Categories:
Conferences | Personal

It's an exciting year for us for DevConnections! SQL Server 2008 has now been out for a few months and an SP is coming up soon. This is the sign that some customers wait for to migrate over to the new release feeling that an SP indicates a higher level of stability. But, this is also a time when some companies are shying away from upgrades because of the immediate and very quantifiable costs. And so Paul and I really struggled with what to focus on when we put together our Connections line-up.

What we decided to do is focus on your getting the most from the system that you have now - with best practices that apply to SQL Server 2000, SQL Server 2005 and SQL Server 2008. Personally, Paul and I are going to demo and focus on 2005/2008 but the concepts work on all 3 versions (and even most of the syntax as well - but, for index fragmentation analysis and maintenance the commands changed between 2000 and 2005/2008 so that's one minor difference). For the conference itself, we're focusing on upgrade, new features in 2008 and things to be aware of architecturally in all areas of Administration/Ops, Development and Business Intelligence. And, given that this isn't a "new product year" for SQL, other big conferences are likely to have fewer SQL sessions than usual (and most do...seriously).

So, with SQLConnections you get 46 *SQL* sessions and 3 full-day *SQL* workshops (and workshops on other technologies as well - all of which are spread over 2 pre-con days and 1 post-con day - with none of the SQL ones running concurrently so you could attend all 3). Top it all off with a more intimate event than many others means more interaction to get your tough questions answered! In fact, to help make sure we see as many people as possible, Paul and I usually schedule our sessions before and after lunch so that we can spend the entire lunch gap inside our session room answering even more questions! We even have a session called "Follow the Rabbit" where YOU drive the session with your questions. It's great fun and we've been doing this for the past few years with a lot of success!

If you want to see a bit of the personality and flair offered at Connections - check out MyConnections - it's our conference magazine (note: it's 9.80 MB to download but, it's 84 pages). It's something you get automatically after attending and it's filled with technical articles and all sorts of additional information that comes from Connections. And, here's a link to a fun and fast-paced video with highlights of the conference itself (nothing technical - just fun shots of the event). For example, did you know that EVERY year a Harley is given away at Connections? Here's the quick video: mms://bcast.sswug.org/sswugtv/DevConnectionsFall08.wmv.

Finally, did you know that EVERY attendee gets a FREE SQL Server 2008 Standard Edition license with one CAL. That can cover your attendance right there and get you started on development and learning with SQL Server 2008.

We really have a great time at Connections and we hope to see you there!! (And, Florida in March is a nice destination from the winter weather for many of us as well. :)

We hope to see you there!!
Kimberly and Paul

Given the general state of the economy...many companies are looking to cut back. Going back over what we've done and "optimizing" things -> budgets, expenses, etc. is the norm right now. And, scaling back is not always a bad thing - unless the wrong things are cut. Unless the wrong things are used to motivate you. Prioritizing and/or really assessing what gives you the biggest gains for your dollars is hard. In fact, one of the things that always seems to be first on the cutting block is training. Training is hard to quantify. And, the results of good training are also hard to quantify. Instead of fixing a problem (which you can often see the exact improvement) you might instead avoid a problem. Avoid downtime. Avoid data loss. Process more rows - with the same hardware. But, how do you know the cost of what could have happened. Ugh. To be honest, if I could do that - Paul and I would be on a beach. ;)

But, I do have a reason for this post... what should you be thinking? Where should you focus your attention? What can you cut - safely, temporarily, permanently and what might you help to prioritize?

Should you upgrade software?

  • Is there a feature that makes something easier? Some new features are really powerful "big" features. For example, Policy-Based Management (PBM) might help you to better centralize certain rules (in PBM-speak "policies") and then enforce them on many servers - even 2005 servers... so, you might be able to upgrade a smaller number of servers and still get some of the benefits. Many of the tools work against multiple versions so you might be able to minimize (and/or prioritize) which servers you upgrade and slowly migrate others. Potentially following an every-other-version upgrade strategy... upgrading some servers from 2000 to 2008 and leaving some of your 2005 servers to wait to upgrade until SQL11 (the next version after SQL10 - which is SQL Sever 2008).
  • Are you starting a new project - architecting a new database? Wouldn't it be easier to start on the newer version and get better longevity (maybe?!)? For example, sparse columns might make a major difference in your base table's architecture...and be easier than if you were to architect (and write all of the code) for 2005 but then later need to do a major architectural change to move to 2008 (well, to *really* benefit from things like sparse columns). There are some really good features in 2008 and some *might* warrant upgrading... upgrading now. But, if you don't have a direct need then I'd argue that you could probably stay with 2005 (or even 2000) and then push this out a bit until you absolutely need to move forward.

Should you upgrade hardware?

  • Again, are there features that will directly impact: performance, availability, manageability?
  • Can you wait? I can't really answer this and - for everyone - the answer is going to be "it depends". There might be something that significantly reduces costs and/or minimizes downtime and as a result, you'll just have to do cost-benefit analysis. This is a tough one... but, maybe you can do rolling upgrades and let some of the lesser servers take the hand-me-downs. :)
  • Can you do rolling upgrades moving the most critical to a new server and then a less critical server to the one freed up by the last upgrade...

Is there anything you can do to get more out of what you already have??

In my opinion, this is probably even more important than the two above. Upgrading hardware and software is something you will ALWAYS need to consider but if you could get better performance, scalability and availability out of the hardware/software you have now, then you'll benefit *now* without additional funds spent (actual outgoing funds) and you still be able to leverage what you do today when you do upgrade. So, what this really translates to (IMO) is tweaking and tweaking a bit more - what you already have? How? What can you look for? What can you do to help??

  • Upgrade to the latest service packs/hotfixes (at least upgrade to the free stuff - you might see some gains and in some cases (like SQL Server 2005 SP2+) you might get some new features. (important note: test this on a non-production server FIRST!!)
  • Update your hardware's firmware? You might have missed an update that improves performance (important note: test this on a non-production server FIRST!!)
  • Bottleneck Analysis - Some good resources for this are: Performance Tuning Using Waits and Queues and the SQLCAT team.
  • Workload Analysis - Some good resources for this are: Troubleshooting Performance Problems in SQL Server 2005, Working with Tempdb in SQL Server 2005, Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005...well, there are lots of good whitepapers that are specific to certain types of workloads and/or perf problems...check out our whitepapers page here: http://www.sqlskills.com/whitepapers.asp and the CAT team's whitepapers pages here: http://sqlcat.com/whitepapers/default.aspx and the general SQL Server on microsoft.com pages here: http://www.microsoft.com/sqlserver/2008/en/us/white-papers.aspx and for 2005 here: http://www.microsoft.com/sqlserver/2005/en/us/white-papers.aspx
  • Maintenance - often overlooked and incredibly important. A database that has solid maintenance practices (fragmentation analysis and cleanup, VLF analysis and cleanup, transaction log management, finding corruption in its early stages through automated CHECKDB executions...) performs better, is easier to recover, might naturally stay smaller (more compact) and therefore require less hardware. In fact, analyzing indexes - to get rid of unused indexes and to consolidate redundant indexes can end up saving disk space, backup space, cache, maintenance costs, etc. Both Paul and I have blogged quite a bit about many of these!
  • Other tips and tricks
    • Blogs... which is why you're here and there are so many out there! Here's a link I recently found that lists a bunch of SQL-related blogs: http://technet.microsoft.com/en-us/sqlserver/bb671052.aspx and, of course, Paul's post on "So many blogs" and the PASS list of blogs here: http://www.sqlpass.org/Community/BlogDirectory.aspx.
    • Webcasts... there are lots out there and we now have a page which has most of ours listed on it (thanks to Paul for creating this!!) here: http://www.sqlskills.com/webcasts.asp and there are LOTS more on TechNet, MSDN, etc.
    • Conferences... OK, maybe a shameless plug for conferences like SQLConnections *but* in having put together the agenda (with Paul) where we specifically focused on best practices topics and performance tuning - I can tell you that some of the tips and tricks that we recommend can significantly improve performance, may minimize needed disk space (by creating more optimal and often fewer indexes), may improve availability with better design practices and/or maintenance and much more than that! And, in getting away from the office for a few days and focusing just on learning you might do two things. First, you might learn some tips and tricks that you never would have (or it would have taken *a lot* more time and/or been harder to really understand?). Second, you might come back with a whole new and renewed enthusiam for doing things - and with an ordered/prioritized list of things to try. And, this might even help to motivate you because it also shows that your company really is committed to you/your job (having spent money specifically on your learning) - and you to them.

So, I do think that there are SMARTER ways to save. A well trained employee is worth a lot more than a cheaper one. And, there are smarter things to cut. I hope this might help you think of things to do and/or places to look to get better performance with what you have! I think blanket "no training" or "no upgrades" statements are never good for anything - even the budget (the longer term effects can be much worse - but also much harder to quantify).

Really, the answer is always different. It depends............

kt

Well, I had wanted to come up with a clever reply to my husband's oh-so-romantic blog post (here). And, well, in all honesty, that *is* the best present for me... but, probably not what most would say is romantic ;-). We've both had quite an effect on each other's presentation styles. We constantly remind each other of what works and what doesn't work. In fact, we even take notes when we watch each other's sessions so that we can very clearly and concisely state what we think works and/or doesn't work in a session. So, that got me thinking that I'd like to add a few things - mostly about how to get started in presenting - as his list for tips/tricks in presenting was extremely thorough!

Presenting tips:

  • Demos: OK, everyone says this - yes, your demo should work. A demo that fails is easily the most frustrating thing to happen on stage. Not only is it frustrating for you (as the presenter) but the attendees feel like their time is wasted. And, in all honesty, this should never happen. When it does it usually happens because of one of the following: the demo wasn't prepared, the demo was overly complicated or something changed recently (and you hadn't recently tested it). And, all of these are preventable.
  • Passion: Paul mentioned that you need to find a topic for which you have a passion - and I completely agree. This is probably the most important part for me. I've often been asked to talk about X or Y and if I can't find something really compelling to focus on, then it's definitely not my best session. In fact, less and less am I presenting other people's content and/or other people's abstracts. I really want to construct the session, the content and the message (in general). Having said that, what I want to add is passion/excitement/fun. The more fun you have with a session (and, I don't mean jokes - I just mean good content that makes sense and that is interesting), the more fun it will be to present. If you're having fun and presenting something with passion (that you have specifically for that topic), then it's contagious. People will remember more and take more away with them.
  • Mentor: Paul mentioned this in his post, Greg Low mentions this in his series Presenting at Large Events, and large conferences such as TechEd have people like Richard Klees on-site to help with this as well. But, if you can find a colleague or other presenter to really watch your actual session (and you watch theirs), then you will get the best feedback. The actual session - in front of real attendees - is the only place where everything counts (unfortunately, all of your presentation gotchas don't always show in a "test run"). So, it's here where you can get the best feedback and where you can really learn.
  • Don't stop learning: I've presented in one way, shape or form since 1987 when I gave "short-courses" on WordPerfect for the local students and staff at my University computer center (where I worked). And, in over 22 years, I still read evaluations, still look for books on presenting, still read blogs, watch webcasts, etc. A session can *always* be better. A presenter *always* has things they can work on.

Getting Started (which can also translate into improving your own skills/knowledge and even your own position within the company):

  • Create a work/study group: Something that can help to "find the right tool" for the job is to divide and conquer. In our technical fields, no one can ever know everything. And, sometimes we get stuck in a rut - solving problem after problem with the same solution. I always use the "tool" analogy because I think it works well. If you have a problem in your house you don't always grab the hammer, right? But, I don't know how to use every tool either - if I don't know exactly what tool to use, sometimes I'll ask someone else to look at something. Sometimes a second set of eyes is exactly the thing to do. They might see an easier and/or a quicker solution. So, since you can't know everything - know a lot about a lot of things. Have a small work/study group that meets weekly or bi-monthly where each of you tackles a topic, a feature, something. Or, maybe you all read different blogs or newsgroups - then come back together and each do a 10 minute presentation on what you found. This can keep you better informed about other tools you might need to use someday AND can help you to start presenting (on a small scale)

NOTE: Before you do any of the following, you might want to check to see what your company policies are with regard to blogs, user groups, conferences, etc. With an appropriate disclaimer and/or no direct references to the company, you might be fine. Just check to make sure! 

  • Present at a local user group and/or consider creating one if one doesn't exist: these a typically 10-50 people who meet at least once a month. Some user groups are much larger... But, this is a great way to learn more AND present what you know to a bigger group but, with (usually) a bit less pressure. The PASS website has a large list of chapters: http://www.sqlpass.org/Chapters.aspx. Consider even working with the local user group to have a side group that meets solely for improving presenting skills - you can present to each other in the same way that the work/study group would but this is a group outside of your company.
  • Create a blog: there are lots of sites you can join to blog on and my personal opinion is to see if you can write consistent posts for a month or so (without them being published publicly) and then slowly publish the ones you've written so that you can stay ahead of the game. Blogging is hard. I have a hard time keeping up with it but if you have a good message - that's useful to others - then it's worth it.
  • Create podcasts to post on your blog: This can be another way to present but without the stress of an audience.
  • Write for magazines (TechNet, MSDN, SQL Server Magazine): This is a bit harder but if it's a good article then it's likely to be published either in print and/or on their associated websites. This can give you more exposure and in turn, help you to hone your message and your presentation skills.
  • Submit sessions for larger conferences: This is the hardest and will take the most time. It's really nothing personal if you're not chosen the first or second time around (and these days the large conferences are even more competitive so it's *really* hard - don't get discouraged!!). Most large conferences want people who have a name that attendees can recognize. So, this takes time. The previous bullets *will* get you to a point where submitting to a larger conference makes sense - but, even then it's still not a guarantee that you'll be accepted. The more you blog, write, present at user groups, etc. the more people will get to know your name and your presentation skills. This is what the larger conferences are looking for - people that can give a good, technical session and make those 75 minutes the attendee spends with you worthwhile. Consider getting into a speaker competition like Speaker Idol which is usually at conferences such as TechEd but I've also been seeing this in local areas as well (with local user groups).

Key point: Clear and Concise "Presentation" for every aspect of life...

So, in re-reading Paul's post, I also read the comments and followed the links (which is what got me to Greg Low's 4 part series on presenting for large conferences - which is a really good series btw). In his presentation he mentioned a flight attendant... which, then made me surf/read a few things there. And, somehow I go sidetracked and ended up:

here: Galley Gossip: Flight Attendant Pet Peeve #1: Answer please!
and here: A woman missed her flight at the boarding gate HKIA
and even here: An open letter to unsatisfied users on the newsgroups

And, the combination made me think of a few things that really can go back to presenting but also just in general about comments, criticisms, and everything in life. If you want something then you need to ask for it precisely. If you want to get somewhere or do something or improve your position (in life, in work, whatever), then you need to be specific, concise, and clear. It's all about the presentation. Paul says this occassionally to the girls: Stop, Think, Speak. It's somewhat frustrating when he says this to me but it's usually after I've had a couple of glasses of wine ;) but, I think it's really interesting in the context of user groups, forums, presenting, life... You need to *present* something clearly and concisely for people to understand.

If you're posting a question on a forum and/or newsgroup - take time to research it first. Take time to present it clearly (what version, what's the EXACT syntax (can you provide a repro script?), what exactly are you doing, what is it doing that's wrong, what do you think it should be doing?). The better your question (i.e. the presentation), the easier it is to get people to understand. And, in the case of a forum/newsgroup, the easier it is to get a [useful] reply. Remember Tom Cruise/Cuba Gooding, Jr. in Jerry Maquire - "Help me, help you."

If you're presenting a session - present the problem (or idea), present the solution (code/demo/etc) and summarize why it works. Clear, concise and then follow through. And, this also reminds me of the most important presentation skills that everyone says but that I'm going to repeat one more time... your demo should WORK. Keep is simple. Straightforward (concise) and simple demos are really the most effective!

So, on that note, I'll remind you to look at one of the links I already posted above. This woman is very clearly stating the problem and reasonably coming up with a solution (to her missed flight): A woman missed her flight at the boarding gate HKIA. Yep, that's going to get someone to help you. Hmm. Clearly, she did not see Jerry Maguire.

Thanks for reading!
kt

Categories:
Opinions | Presenting | Conferences

Theme design by Nukeation based on Jelle Druyts