(Thiru Thangarathinam) The main purpose of an application’s data-access layer is to transport required information back and forth between the database and the application. Because of the focused nature of the data-access code, the code in this layer can quickly become repetitive. For example, to

(Marcin Policht) Following an extended review of various types of Foreach Loop enumerators in the SQL Server 2005 Integration Services, we are turning our attention to other types of package components, which either did not exist in the Data Transformation Services (SSIS predecessor present in earli

(Victor Volkman) In the late 1980s, when I first learned to program in C, I cobbled together data structures and algorithms from books and pretended they were generic or they could be generalized, perhaps even by macros. Invariably, however, I would end up copying them or tweaking them for every new

(Andrew Novick) In 2003 and 2004, when this news letter was the UDF of the Week Newsletter, it featured the occasional user contributed code. The format of Coding-in-SQL doesn’t really lend itself to most user contributions but shen a reader, Jason Schaitel, sent in some code last week I decided th

(Hari Ramachandran) For years, Microsoft Product Support Services (PSS) has used two tools—OSTRESS and Read80Trace—to simulate scenarios and analyze large SQL Server trace files for its customers. At the Professional Association for SQL Server (PASS) 2004 conference, PSS released these tools to the

(Vijay Kumar) When an application submits a SQL query to the database server, the server first parses the SQL. It checks the SQL syntax, for security access and prepares the query for execution. Query optimization involves determining the optimal path for executing the query. The server uses eit

(Scott Robinson) I remember a time (a time long past) when the idea of tying applications together across functional (and, heaven forbid, departmental) boundaries was not only politically incorrect to the in-house user community, but downright frightening to some—and certainly intimidating to IT (or

After you install Microsoft SQL Server 2000 Service Pack 4 (SP4), you receive the following error message when you try to open a trace table by using SQL Profiler: Failed to open a table.

(Baya Pavliashvili) SQL Server supports up to 32,767 simultaneous connections per single instance, but you should never attempt to run an application supporting this many users on a single server. It would bring the server to its knees. If you have more than several hundred concurrent users, you typ

(Scott Guthrie) Describes how to set up the new ASP.NET Membership, Role Management, and Personalization services to use a regular SQL Server instead of Microsoft SQL Server Express.