Forum Replies Created

Viewing 15 posts - 3,496 through 3,510 (of 3,614 total)

  • 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...

  • RE: So What is IIS?

    Under no circumstances should you install IIS on the same box as SQL. Even in a development environment it causes problems.

    You can write a web app that crashes IIS...

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

    Firstly, use a naming convention that maximizes the readability of your code. Readability was a key learning point in the "Worst Practices - comments" series.

    Secondly, using the tablename.fieldname notation...

  • RE: Worst Practice - Bad Comments

    I've set up a case-sensitive SQL Server simply because the data that had to be imported from external sources needed to retain its case sensitivity. ID fields were an...

  • RE: SQL 2000 SP3

    I've got a strange problem that has occured after an SP3 install.

    All my SQL Servers, including my Lap top install are at SP3. All are running fine.

    If I use...

  • RE: Worst Security hole I have ever seen

    In the UK 2 Years ago a SQL DBA could look for work in the £30K - £40K region.

    Being a DBA meant something.

    Today a SQL DBA will probably see jobs...

  • RE: SQL Worm - Are we lazy

    I WISH!!!

    The problem is that it is on a client's site and is working fine. It is a case of "if it ain't broke, don't fix it".

    All(!?!) we have...

Viewing 15 posts - 3,496 through 3,510 (of 3,614 total)