Andy returns to the Worst Practice series this week with a short article looking at how connection strings in applications affect what you see in sysprocesses. Perhaps less controversial (in our opinion) that some of the other worst practices, this is something easy to fix and definitely worth fixing! Read the article and post a comment - explore other points of view! Readers posting a comment will be entered in a drawing for a copy of the SQL Server 2000 Resource Kit.   Read more...

In this article by Neil Weicher, he talks about encryption of data and files for SQL Server.   Read more...

Continuing with the Worst Practices Series: Steve Jones examines why encryption in the database is a bad idea.   Read more...

One of the strengths of SQL Server is its ease of management and administration over other systems. Oracle, DB2, even early versions of SQL Server required command line mastery to make many types of changes. But should you really be using the GUI for most of your tasks?   Read more...

Continuing with Andy Warren's series on Worst Practices for a DBA, Steve Jones joins in this week with his worst practice.   Read more...