(Darren Fuller) Part 1 of this series discussed the need for database change management and problems with current approaches e.g. the manual creation of upgrade scripts, which is inefficient and error prone. This second article of a 4 part series examines an automated approach to database change ma

(David) Designing a database for a large-scale web application is a monstrous task to say the least. It can however, be made easier by taking full advantage of the many tools, utilities and built-in objects that come with a Relational Database Management System (RDBMS), such as Microsoft SQL Server

(Muthusamy Anantha Kumar) This article examines how to take advantage of VB Script and MS-DOS batch files to restore multiple DTS packages stored in the form of structured storage files from one folder to a SQL Server box. When many DTS packages reside as structured storage files, it can be tiresome

(Joe McKendrick) The prize seems so tantalizingly close that many data center managers can almost touch it. Vendors, analysts, and end-users alike are talking about achieving something unimaginable even just a few years ago – almost transparent business continuity that could keep IT systems up and r

The SQL Server 2000 Report Pack for Microsoft CRM is a set of six Microsoft SQL Server 2000 Reporting Services reports that work with the Microsoft CRM 1.2 sample database. With the Report Pack, you have the choice of using the sample reports either as-is or as templates for designing new report

(Patryk Nowakowski) With the release of ADO .NET Microsoft has fundamentally changed the way of database applications development. The new version of ADO introduced with .NET Framework is extremely flexible and gives developers a wide variety of tools for handling common database programming tasks.

(William Pearson) In this lesson, we will introduce a function that operates upon a specified set, extracting the dimensions of that set as we dictate. As most references point out, by way of explanation, the EXTRACT() function works in a manner that is the opposite of the CROSSJOIN() function (for

(Baya Pavliashvili) Data warehousing is not for the faint of heart; it takes much diligence and dedication to learn the various tools of the trade. In this article, Baya Pavliashvili details some features available with Microsoft Analysis Services, whose Analysis Manager allows you to create and

(Vinod Kumar) This requirement again comes from the repeated posts in the local usergroup of mine. Bussiness processes at some time would want to Update millions of rows based on some criteria. Even for a matter of fact sometimes we would be interested in deleting tons of rows. And issuing a DELETE

Q&A: A senior internal technology architect shares insight Microsoft has gained from deploying and testing the latest beta release of Microsoft SQL Server 2005 as part of the company’s SAP R/3 enterprise resource planning system.