Quick tips for monitoring SQL Server performance issues

Doing any kind of performance tuning on SQL Server can be tricky. In fact, I wrote a whole book about it back in 2000, called The Definitive Guide to SQL Server Performance Tuning ...

Active Directory Lightweight Directory Service Part 2

This article continues the discussion of the Active Directory Lightweight Directory Service (AD LDS) by explaining some techniques that you can use to plan for the deployment process, ...

Active Directory Lightweight Directory Service Part 1

Introduction many directory services requirements for an organization. However, AD DS also has many dependencies that make its deployment and management a complex task. Because ...

Secure Email using Transport Layer Security and Outlook

The ability to secure email communications is critical in today’s environment where hacking into users’ accounts has become a hobby to some very bright individuals.  Information ...

Manage the Active Directory Domain Services Schema – Part 1

Introduction The Active Directory Domain Services (AD DS) schema contains formal definitions of every object class that can be created in an AD DS forest. The schema also contains formal ...

Change the Routing Status of a Name Suffix

Introduction Name suffix routing allows you to control authentication requests thattake place between forests that are joined by a forest trust. By using the ActiveDirectory Domains ...

Transparent data encryption in SQL Server 2008

Transparent Data Encryption (TDE) is a new feature in SQL Server 2008 designed to encrypt your database files, database backups and temporary database (tempdb). As you request data ...

T-SQL aggregate functions in SQL Server 2008

When working with data in a SQL Server database, there may be times when you want to perform a calculation on a set of values. For example, your data might include the amounts of individual ...

PowerShell commands every Windows admin should know

Over the last few years, Microsoft has been trying to make PowerShell the management tool of choice. Almost all the newer Microsoft server products require PowerShell, and there are ...