Forum Replies Created

Viewing 15 posts - 3,421 through 3,435 (of 3,544 total)

  • RE: How To Copy DB Between Servers

    As an aside, I worked through the MS XML SQL Server programming book and having got through lots of interesting and useful stuff on updategrams etc the book finally said...

  • RE: We Studied, We Passed, Was It Worth It?

    Andy,

    From your experience what are the advantages of dot.net over the previous MS offerings.

    We are having a struggle to get dot.net into our company and at this stage we're at...

  • RE: How to Execute Views from VB

    I tend to use the DataEnvironment object to execute any views, stored procedures and commands within my app.

    Intellisense lets you reference your database objects, and in the case of views...

  • RE: Protecting Proprietary SQL code

    I would love to see a good article/book on xp's.

    There is a good example on this site to read an external text file. Note that it uses...

  • RE: Introduction to ADO - The Command Object

    I do a lot of Web development and one of the problems I find is that the constants (adCmdStoredProcedure) used to indicate command types are rarely defined outside of an...

  • RE: Protecting Proprietary SQL code

    Have you ever considered storing them encrypted in the registry?

  • RE: Favourite Tools?

    When my company develops internet applications we run a stress test tool against the site to see what sort of load the site will stand.

    Does anyone know of any stress...

  • RE: Protecting Proprietary SQL code

    If you don't hard code your connection strings and you don't use NT security then what do you do?

  • RE: Select into & Full/ Bulk Recovery Model

    My understanding is that "Full Recovery" records absolutely everything and is granular.

    My understanding is that Bulk logging is used for massive inserts into the database.

    I've had a situation where Full...

  • RE: Table/Column Naming Conventions (Opinions Wanted)

    There is quite a bit of disagreement here with regard to naming conventions.

    We are all in agreement that a naming standard is a good thing, but there is an absence...

  • RE: Protecting Proprietary SQL code

    I notice that Microsoft haven't encrypted the build in stored procedures within SQL Server!

    Ripping off the SQL code is only practical if you rip off the database schema as well.

    I...

  • RE: Table/Column Naming Conventions (Opinions Wanted)

    quote:


    What's convenient for DBAs, VB programmers, Access developers, end-users using something like Access or Crystal Reports, PowerBuilder and Java are all different;...

  • RE: Table/Column Naming Conventions (Opinions Wanted)

    It would be useful if someone could come up with a naming standard that can grow as databases evolve i.e. to take us through to SQL Server 2050, ORACLE 69i,...

  • RE: So What is IIS?

    Brian,

    Forgive my ignorance, but what do you put an SSL certificate on a SQL box for?

  • RE: So What is IIS?

    I use a number of Web Content Management Systems and have seen horrendous memory leak problems in some of them.

    There are one or two that use an ISAPI filter in...

Viewing 15 posts - 3,421 through 3,435 (of 3,544 total)