http://www.sqlservercentral.com/Content tagged .Net, T-SQL posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)For many of us, working with the identity property allows us to easily generate a sequential series of numbers. But what if you need to generate a sequence according to some pattern, like one that includes the year? New author Asif Sayed brings us a technique and the code for generating a patterned sequence. http://www.sqlservercentral.com/articles/Miscellaneous/generatingasequentialpattern/2390/2006/05/17http://www.sqlservercentral.com/articles/Miscellaneous/generatingasequentialpattern/2390/A new article from MSDN magazine on stopping SQL Injection attacks by examining how the SQL can be exploited. It's a good basic article for developers as well as DBAs who might have to review code.http://www.sqlservercentral.com/redirect/articles/1470/2004/08/20http://www.sqlservercentral.com/redirect/articles/1470/This week Andy looks at where, when, and how jobs should be run and why you need to think about those items before you build the job. Part of this is deciding what runs on production servers and what doesn't. http://www.sqlservercentral.com/articles/Administering/managingjobspart3/936/2003/03/11http://www.sqlservercentral.com/articles/Administering/managingjobspart3/936/Architectural choices for data access affect performance, scalability, maintainability, and usability. This article focuses on the performance aspects of these choices by comparing relative performance of various data access techniques, including Microsoft® ADO.NET Command, DataReader, DataSet, and XML Reader in common application scenarios with a Microsoft SQL Server™ 2000 database.http://www.sqlservercentral.com/redirect/articles/620/2002/03/01http://www.sqlservercentral.com/redirect/articles/620/