SQL Server R2 Express Edition features

An often overlooked and underestimated edition of SQL Server, the Express Edition superceded the SQL Server 2000 MSDE (Microsoft Data Engine) edition.  Introduced with the SQL Server 2005 lineup, this edition allowed applications requiring a small data store to be distrubuted without incurring the cost of a higher-end SQL Server... [Read More]

Securing Access to an SQL Server Port

In an earlier article titled SQL Server Connection Strings, Unique Application DNS and Listening Ports I explained a method that can be used to manage applications’ connectivity to SQL Server databases across an enterprise.  This article extends the principles explained. [Read More]