http://www.sqlservercentral.com/Articles tagged T-SQL, SQL Server 6.5 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)One of the major problems in the database field is when people store sensitive data unencrypted into SQL Server. This article shows you one of the most basic ways to encrypt data to the casual viewer. http://www.sqlservercentral.com/articles/Security/encryptfunction/372/2006/05/29http://www.sqlservercentral.com/articles/Security/encryptfunction/372/One thing that often amazes me is that many SQL Server developers do not actually measure the performance of their queries. Many of them thought that you needed external tools, more or less complicated, to run against your server, and they did not have the time or inclination to learn and try these. This article will describe a couple of much easier methods of measuring performance of queries. http://www.sqlservercentral.com/articles/Performance+Tuning/measuringperformance/1323/2005/12/23http://www.sqlservercentral.com/articles/Performance+Tuning/measuringperformance/1323/One thing that often amazes me is that many SQL Server developers do not actually measure the performance of their queries. Many of them thought that you needed external tools, more or less complicated, to run against your server, and they did not have the time or inclination to learn and try these. This article will describe a couple of much easier methods of measuring performance of queries. http://www.sqlservercentral.com/articles/Performance+Tuning/measuringperformance/1323/2005/12/23http://www.sqlservercentral.com/articles/Performance+Tuning/measuringperformance/1323/One of the most handy extended stored procedures in SQL Server is xp_cmdshell. This article will show you how to use it. http://www.sqlservercentral.com/articles/Administering/xpcmdshell/141/2003/11/14http://www.sqlservercentral.com/articles/Administering/xpcmdshell/141/An alternative procedure for viewing locks based on sp_lock. http://www.sqlservercentral.com/articles/Performance+Tuning/lockview/297/2001/07/24http://www.sqlservercentral.com/articles/Performance+Tuning/lockview/297/One of the major problems in the database field is when people store sensitive data unencrypted into SQL Server. This article shows you one of the most basic ways to encrypt data to the casual viewer. http://www.sqlservercentral.com/articles/Security/encryptfunction/372/2006/05/29http://www.sqlservercentral.com/articles/Security/encryptfunction/372/One of the most handy extended stored procedures in SQL Server is xp_cmdshell. This article will show you how to use it. http://www.sqlservercentral.com/articles/Administering/xpcmdshell/141/2003/11/14http://www.sqlservercentral.com/articles/Administering/xpcmdshell/141/