I've been asked to do a series of seminars for a clients BIDS developers. These developers could best be described as talented amateurs (they selected a few of the more technically adept folks from around the business and gave them some initial training on BIDS).
One of the first topics they've identified is a Tips and Tricks session on the tools they use. The tool set basically comprises SQL Management Studion and Visual Studio BIDS projects. I think I'll probably also make them aware of Profiler too.
The trouble is I'm actually struggling to come up with any tips and tricks. I've got a few but I've been using the tools for so long, I don't actually notice what I'm doing any more (which probably qualifies me for management). Here's a few I've come up with:-
1. How to use the immediate window
2. How to query datasets using the query designer
3. How to debug sql using SSMS
4. How to use Profiler to see the actual SQL that's being run
That's the sort of level I think I want to pitch at. Can anyone else think of tips and tricks that are worth me chucking in?