SQL Server Management Objects offer developers a robust toolset for backing up and restoring databases, and issuing DDL commands, as John Papa explains.
John Papa
MSDN Magazine June 2007
View Complete Post
In this column see how to bind a custom list of business entities using the binding tools in the .NET Framework 2.0.
MSDN Magazine February 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
Dealing with error handling between T-SQL and a calling application, evaluating when a field's value has changed, and creating auditing tables in SQL ServerT are all common issues that developers must tackle.
MSDN Magazine April 2004
MSDN Magazine January 2004
MSDN Magazine December 2003
MSDN Magazine November 2003
MSDN Magazine September 2003
Hall of Fame Twitter Terms of Service Privacy Policy Contact Us Archives Tell A Friend