Lohn Solutions

On-Demand Enterprise: Database Automation for the DBA Shortage: “As the amount of data continues to grow, the need for experienced database administrators (DBAs) is exploding. The U.S. Department of Labor and Statistics reports that employment of DBAs is expected to grow significantly and outpace the growth of all other occupations through 2016. The DBA has [...]

Microsoft Press – SQL Server 2008 Free E-Book Offer: “Introducing SQL Server 2008

by Peter DeBettaISBN: 9780735625587

Learn about major new features in SQL Server 2008 including security, administration, and performance.”

The TRUSTWORHY bit database property in SQL Server 2005

EXECUTE AS vs. SETUSER In SQL Server 2005, the context in which a string, command, or module is executed can be explicitly set by using the EXECUTE AS statement. EXECUTE AS replaces the SETUSER statement.

TRUSTWORTHY Database Property Because a database that is [...]

SQL 2005 and MSDTC

MSDTC – Give it a dedicated group or use Cluster Group? – Database Forum The only reason to give it its own group is performance. If you have a high load/use for MSDTC, you should configure it in its own group, however this will impact available [...]

1. SQL SERVER SETUP

Setup a SQL 2005 Standalone Machine

I would strongly recommend that you start by reading about the pre-requisites of installing SQL 2005.

http://msdn2.microsoft.com/en-us/library/ms143719.aspx

If you [...]

I got this emailed to me as well – again, some good points.
22 WAYS TO STRIKE OUT WHEN INTERVIEWING

A recent survey was conducted among 150 companies to discover why a candidate who is capable of handling a job is not hired. The responses all relate to [...]

I got this emailed to me and it’s got some good points….

TWENTY GOOD ANSWERS TO HELP YOU MASTER EVEN THE MOST GRUELING EMPLOYMENT INTERVIEW

Most people make two devastating mistakes when they are being questioned in an interview. First, they fail to listen to the question. [...]