Tips and Tricks in SQL Server and BIDS-VBForums
Results 1 to 3 of 3

Thread: Tips and Tricks in SQL Server and BIDS

  1. #1

    Thread Starter
    Super Moderator FunkyDexter's Avatar
    Join Date
    Apr 2005
    Location
    An obscure body in the SK system. The inhabitants call it Earth
    Posts
    3,645

    Tips and Tricks in SQL Server and BIDS

    Hi All

    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?
    When one of my minions says, "Hey, he's just one guy, what can he do?" I say "This"... and shoot them.

    The problem with putting your lair in a volcano is keeping your robot army from melting.

    I know that the human being and the fish can coexist peacefully - George Bush

  2. #2
    #28 for the Yanks coming GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    6,900

    Re: Tips and Tricks in SQL Server and BIDS

    Watch the use of connecting to Excel spreadsheets if using 64 bit BIDS env. Remember to set to run in 32 bit for the desinger as there is no 64 bit driver.
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1

  3. #3

    Thread Starter
    Super Moderator FunkyDexter's Avatar
    Join Date
    Apr 2005
    Location
    An obscure body in the SK system. The inhabitants call it Earth
    Posts
    3,645

    Re: Tips and Tricks in SQL Server and BIDS

    Hi Gary

    I'm after a more general level than that but all info's useful and I didn't know that so thanks.

    Declan
    When one of my minions says, "Hey, he's just one guy, what can he do?" I say "This"... and shoot them.

    The problem with putting your lair in a volcano is keeping your robot army from melting.

    I know that the human being and the fish can coexist peacefully - George Bush

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.