(Shabdar Ghata) Whenever we want to backup or move SQL Server database, most of us prefer to use regular backup utility which is available through Enterprise Manager in SQL Server 2000 or Management Studio in SQL Server 2005. Limitation of using Enterprise Manager or Management Studio is we have to

(Gregory A. Larsen) Microsoft introduced dynamic management views (DMV) and functions (DMF) with SQL Server 2005. So what are DMV’s and DMF’s? How do you use these dynamic management objects? DMVs and DMFs are a mechanism to allow you to look at the internal workings of SQL Server using TSQL. They a

(r.stropek) SSIS has a built in function for loops. In this blog article I want to demonstrate how to use SSIS’s Foreach ADO enumerator to loop through a list of SQL server names and collect some basic data (e. g. name, language, version, etc.) about them.

(Serdar Yugalalp) I recently explained how changes in SQL Server 2005 may break older applications and databases, especially where deprecated functions are used. Now I’m going to discuss how to use stored procedures in your migrated databases to take advantage of newer functionality in SQL Server 20

Consider the following scenario. You remove an instance of one of the following products: • Microsoft SQL Server 2000 Desktop Engine (also known as MSDE 2000) Service Pack 4 (SP4) • SQL Server 2000 Desktop Engine (Windows) SP4 • Microsoft SQL Server 2000 SP4

(Chris Martinez) Anyone that has worked with SQL Server for a while undoubtedly has come across a scenario where they needed a way to pass an array as a parameter to a stored procedure. One of the most common of these scenarios involves a stored procedure that must be executed passing numerous prima

(Jasper Smith) When you have a lot of SQL files in a SQL Server Management Studio (SSMS) Project or a lot of Packages in a SSIS Project, it can become difficult to find the file or packages you are looking for as the order that they are displayed in the Solution Explorer is the order they were added

(Josef Finsel) SQL Server 2005’s Management Studio offers lots of new functionality, but you can’t always use a GUI. Sometimes you need to run a script from the command line, especially for an upgrade or install script. Previous versions of SQL Server had two command-line utilities: ISQL, which uses

(John Papa) Many applications require some degree of integration with a reporting tool. A good solution, SQL Server Reporting Services 2005, provides Web-based reports and can be integrated into both Windows Forms and Web-based applications. Plus, it introduces several enhancements over its predeces

(James Catchpole) Most medium to large sized businesses have a reporting solution that provides timely financial information in a user-friendly format for sales people, managers and customers. Usually, the “solution” is a dedicated reporting employee who manually queries source databases for statist