Fort SQL

Information about SQL Server security.

May, 2010

Posts
  • Fort SQL

    List of SQL Server Service Names

    • 6 Comments
    In the tables below, services that can have multiple instances on the same server have the default instance name listed first and then a named instance – “Contoso1.” These services names are without any service packs being applied. I haven’t checked to...
  • Fort SQL

    SQL Server Runaway Transaction Logs

    • 0 Comments
    When SQL Server is used without a qualified DBA, runaway transaction logs are by far the most common problem. This behavior is because the default configuration of SQL Server is intended to support production databases, and production databases should...
  • Fort SQL

    Enabling Transparent Data Encryption (TDE)

    • 0 Comments
    Transparent Data Encryption (TDE) is a feature added in SQL Server 2008 which allows you to encrypt an entire database at a time. A major potential benefit is that when TDE is enabled, all backups are automatically encrypted, which may be worthwhile if...
Page 1 of 1 (3 items)