(Allan Mitchell) Shredding a recordset in this instance means that we are going to show you how to take a recordset produced in your SSIS package, loop over the rows in that recordset, break apart the columns and do something with them. This is really useful when you want to preform an action on a r

(Geert Vanhove) SQL Server database systems are more than ever before being chosen as the preferred backend database solution for large business’s critical systems. And SQL Server richly deserves this status. As a result of this, more users than ever before are blocked in their daily activity when t

(Serdar Yegulalp) There have been all too many instances in the news lately where someone has gained outside access to a database — usually for a turnkey commerce solution — discovered that sensitive information in the database such as user names, passwords, credit card numbers or addresses were a

(Dejan Sunderic) Source code control (or version control) is typically introduced in development environments in which more than one developer needs to work with the same piece of code. It allows development organizations and their members to –Manage code centrally –Manage multiple versions o

(Alex Woodie) When SQL Server 2005 becomes available this fall, Veritas will be there to support it with its storage virtualization and high availability software, the vendor announced last week at the Microsoft TechEd conference in Florida. Veritas says it will support the new database with its

(Randy Holloway) Microsoft’s integration of the .NET Framework and the CLR directly into the database engine in SQL Server 2005 is a key enhancement. The result is a major paradigm shift for database application developers and administrators, who can leverage the new functionality in many different

Under certain circumstances, when you grant permissions to an object in Microsoft SQL Server 2000, the permissions that you granted do not appear in the sysprotects virtual table for that database or in the output that you obtain by running the sp_helprotect stored procedure.

(John Peterson) Do you spend part of your day administering a remote SQL Server? If so, has Microsoft’s got the tool for you. Introducing Microsoft’s Web Data Administrator…

(Daniel Turini) So, you are now the leader of a SQL Server based project and this is your first one, perhaps migrating from Access. Or maybe you have performance problems with your SQL Server and don’t know what to do next. Or maybe you simply want to know of some design guidelines for solutions usi

(Jayaram Krishnaswamy) This tutorial builds on earlier articles in the series, which explained (among other things) how to create a DTS package with ImportExportWizard. In this article, you will learn how to execute the DTS packages designed and saved on the SQL Server from ASP.NET using Visual Stud