SQL Server 2008 is secure by design, default, and deployment. Microsoft is committed to communicating information about threats, countermeasures, and security enhancements as necessary to keep your data as secure as possible. This paper covers some of the most important security features in SQL Server 2008. It tells you how, as an administrator, you can install SQL Server securely and keep it that way, even as applications and users make use of the data stored within.

The Vacation Dilemma

by Steve Jones

SQLServerCentral.com

Editorial - MP3

Does vacation cause extra stress at your job before or after you leave? Steve Jones asks a poll question this Friday to see how you feel.

The Vacation Dilemma

by Steve Jones

SQLServerCentral.com

Editorial - iPod

Does vacation cause extra stress at your job before or after you leave? Steve Jones asks a poll question this Friday to see how you feel.

The Vacation Dilemma

by Steve Jones

SQLServerCentral.com

Editorial - WMV

Does vacation cause extra stress at your job before or after you leave? Steve Jones asks a poll question this Friday to see how you feel.

Audit Database Changes in the Real World

by TJay Belt

SQLServerCentral.com

Auditing

Tjay Belt brings us a story of how auditing was actually implemented and a discussion of why particular decisions were made.

TechEd - Day 1

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones talks about Day 1 at TechEd and some observances from the 2008 show.

Entity Framework: The Cribsheet

by Additional Articles

SimpleTalk

LINQ

Prasanna Amirthalingam provides an overview of Entity Framework and how it can be used. He shows that it can provide an excellent interface between the Object-oriented model and the relational. The Entity Framework allows developers to work with data in the form objects and properties without having to concern themselves directly with either the stored procedures or functions of the defined interface, or the the underlying database tables and columns where this data is stored.

Finding and listing all columns in a database with default values

by Additional Articles

MSSQLTips.com

Administration

I was troubleshooting an issue last week on a vendor-developed database when they stated we needed to look at each one of the 50 tables in their database to make sure that all fields expecting default values, had default values assigned.