Forum Replies Created

Viewing 15 posts - 4,486 through 4,500 (of 6,104 total)

  • RE: Encryption

    When you say table, do you mean the system table like sysxlogins or do you mean a user table. If you mean a user table, you'll need to know the...

    K. Brian Kelley
    @kbriankelley

  • RE: So What is IIS?

    These docs work if you are using a Microsoft Certificate Server. They don't cover the case where you need a 3rd party CA for B2B. After all, if you and...

    K. Brian Kelley
    @kbriankelley

  • RE: So What is IIS?

    IIS Lockdown tool helps greatly, but it isn't the end of it since you have to keep up with the bulletins that have come out since then as well.

    As far...

    K. Brian Kelley
    @kbriankelley

  • RE: SQL off line??

    You can install either SQL 2K MSDE, Personal Edition, or Developer Edition (only available with MSDN) to get a SQL 2K database engine on your laptop.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to...

    K. Brian Kelley
    @kbriankelley

  • RE: Underscore in Virt.Serv. name

    Underscores are only supported by DNS for RR records such as identifying where services are. They aren't for A records, which identify hosts.

    Since the virtual SQL Server is tied to...

    K. Brian Kelley
    @kbriankelley

  • RE: Sql agent jobs sitting in queue

    Do a refresh in EM first, just to make sure you get the latest status. Executing means they are running. Yes, you can stop the jobs, but without knowing the...

    K. Brian Kelley
    @kbriankelley

  • RE: So What is IIS?

    It also probably needs to be said that if you're on Win2K and above (WinXP and 2003) across all machines that will talk in this manner, you also have the...

    K. Brian Kelley
    @kbriankelley

  • RE: Protecting Proprietary SQL code

    No argument on pulling the data back from the databaseand processing it at the middle tier. My only concern from a performance perspective are the decoys. You've indicated that these...

    K. Brian Kelley
    @kbriankelley

  • RE: How do you delete an Extended Stored Proc?

    Keep in mind that until you move the .DLL, someone can always re-add it. However, to be able to move the .DLL, you'll want to drop all stored procedures that...

    K. Brian Kelley
    @kbriankelley

  • RE: So What is IIS?

    Sure. You still deal with the issues of having an FTP server on your SQL Server and all the security issues that would normally entail. That's usually enough to make...

    K. Brian Kelley
    @kbriankelley

  • RE: So What is IIS?

    I agree. I don't typically run IIS/SQL Server except on my workstations that I use for development/testing. However there I know the performance hit, security concerns, etc. I certainly don't...

    K. Brian Kelley
    @kbriankelley

  • RE: Function

    Can you post some basic create (DDL - Data Definition Language) statements on the objects you are using? While your idea looks clear, it'll help with the code. Also, it...

    K. Brian Kelley
    @kbriankelley

  • RE: Worst Security hole I have ever seen

    You always have an option of creating a role and putting the users (Windows groups still map to a database user) in the role and granting permissions to the role....

    K. Brian Kelley
    @kbriankelley

  • RE: Detect database backup

    It really depends on what's kicking off the backup. If it's being kicked off through SQL Agent, you can query the appropriate tables in msdb. However, if you have an...

    K. Brian Kelley
    @kbriankelley

  • RE: Worst Security hole I have ever seen

    The other thing you're going to want to do is get your concerns documented. Address a pleasant but focused e-mail to the admin indicating the risks as you see them...

    K. Brian Kelley
    @kbriankelley

Viewing 15 posts - 4,486 through 4,500 (of 6,104 total)