Forum Replies Created

Viewing 15 posts - 1 through 15 (of 17 total)

  • RE: A Walkabout

    In this day and age of businesses, anything that gets people exposure simply to the fact that things are done differently in different countries is a bonus. As someone who...

  • RE: The Optimists

    Great Editorial and a fantastic point.

    I am a very hands on Systems Architect and I believe that in every single way it is the developers job to make the...

  • RE: Windows Level Privileges for DBAs

    Well said Ed. :satisfied:

  • RE: SQL Server 2005 SP3

    That is the lamest excuse from a company I have ever heard.

    People to this day are buying SQL 2005 and Microsoft to this day are patching bugs. When I want...

  • RE: Should the DBA be a Local Administrator?

    Brandie Tarvin (2/12/2008)


    Sorry, Andrew, but I have to disagree.

    If you think you need the rights and you're not getting them from the person responsible, then you've got no choice but...

  • RE: Should the DBA be a Local Administrator?

    Brandie Tarvin (2/11/2008)


    Make a list of your duties. Then investigate each one and verify whether or not you can accomplish that particular task without local admin access. If,...

  • RE: Should the DBA be a Local Administrator?

    I always take the stance that you should be justifying what rights you need, not how that is implemented.

    If the team responsible for granting rights to Servers or Groups...

  • RE: The switch to Oracle

    I'll would like to just second the use of ask tom (Tom Kytes site). Tom Kyte, while short tempered, arrogrant, Oracle biggot (Not really that bad :)), he is a...

  • RE: Running a production SQL environment on a virtual server

    I think the normal concept of Virtual Machines, ie VMWare running on a server with multiple CPU's, lots of memory and maybe a RAID array is not terribly suited to...

  • RE: how to avoid sp_cursorprepexec and sp_cursorunprepare?

    Are you using parameterised code ?

    //Not parameterised

    SqlDataReader myReader;

    SqlCommand cmd = new SqlCommand("SELECT column1 FROM table1 WHERE colum1 = 'xyz'", sqlConn);

    myReader = cmd.ExecuteReader();

    ----------------------------------

    //parameterised

    SqlDataReader myReader;

    SqlCommand cmd = new SqlCommand("SELECT column1 FROM...

  • RE: Naming Convension

    Periods are used to seperate domains, ie owner, database, table and column. IMHO its a very bad idea to use it as part of an object name. In fact, while...

  • RE: Parameters in Report Header not displayed after upgrade to 2005

    Good pickup...and well done for posting the solution 😉

  • RE: Code use in RS

    andre (1/7/2008)


    Thanks for your reply

    Sorry Did not make myself clear 🙂

    When trying to declare DR as Datarow in the Code window of report, RS throws an error

    Datarow does not...

  • RE: Parameters in Report Header not displayed after upgrade to 2005

    To the best of my knowledge there is no such thing as a Report header in SSRS. Can you clarify that you are talking about a Page Header? Or have...

  • RE: Code use in RS

    andre (1/7/2008)


    Hi There

    Thanks for your reply.

    Yes I am try to build up a string of values.

    Interestingly if I do the following

    Public Function BldTypes(ByVal DT As DataSet) As String

    This line does...

Viewing 15 posts - 1 through 15 (of 17 total)