John Papa
MSDN Magazine December 2003
View Complete Post
MSDN Magazine January 2004
SQL Server Management Objects offer developers a robust toolset for backing up and restoring databases, and issuing DDL commands, as John Papa explains.
MSDN Magazine June 2007
What to do when you need to disable triggers and constraints to perform data synchronization and other tasks with an offline database.
MSDN Magazine April 2007
Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.
MSDN Magazine July 2006
Many applications require some degree of integration with a reporting tool. A good solution, SQL ServerT Reporting Services 2005, provides Web-based reports and can be integrated into both Windowsî Forms and Web-based applications.
MSDN Magazine June 2006
SQL Server 2005 includes several important improvements to the Transact-SQL (T-SQL) language. One added feature is a new kind of trigger that fires when data definition language (DDL) statements run.
MSDN Magazine May 2006
SQL ServerT 2000 includes several XML features that let you transform relational rowsets into hierarchical XML documents, read XML documents, and bulk load data via XML. For example, you can pass an XML document to a stored procedure, join the XML to some tables and return a rowset, or even modify data in the database.
MSDN Magazine June 2005
MSDN Magazine November 2003
MSDN Magazine October 2003
MSDN Magazine September 2003
Hall of Fame Twitter Terms of Service Privacy Policy Contact Us Archives Tell A Friend