(Dr. Song Li) This article introduces a method to load and execute SSIS packages in Microsoft Windows with a demo WPF application.

(Joshua Jones) As DBAs, we quite often find the need to take a look at new databases (or old databases we haven’t seen in awhile), and figure out what shape the indexes are in. For those of us who do consulting work, you probably find this work is particularly familiar territory. Fortunately, when S

(Eric Johnson) When you start working with SQL Server and SSIS, it isn’t long before you find yourself wishing you could change bits of SQL queries dynamically. Most commonly, I see people that want to change the date portion of a query so that you can limit your query to the last 30 days, for examp

(Ashvini Sharma) As more customers are getting aware of PowerPivot, they’re looking for more guidance on when to use what it vs. Analysis Services. This post is our view of the BI landscape and how SQL Server Analysis Services and PowerPivot satisfy needs across the organization. After going through

(Pinalkumar Dave) Today, we are going to discuss about something very simple, but quite commonly confused two options of ALTER DATABASE.

(Sadequl Hussain) When SQL Server is installed, a number of Windows registry keys are also created. These registry keys specify various parameters values required by the instance. For example, one registry key would specify the location of the error log file; another would contain the location of th

(Thomas LaRock) SQL Server splits your physical transaction log file into logical chucks, called virtual log files (VLF). While your transaction log file may look like one file, logically it is fragmented and the level of fragmentation can result in performance degradation. You can take action to co

(Eric Johnson) Transact-SQL is a great language for data manipulation, but it has its weaknesses. Unlike real programming languages, T-SQL is confined to procedural code. Sure, you can build modules by using stored procedures and functions, but for the most part, all of the work will be procedural.

(Marcin Policht) In our most recent article dedicated to the subject of Integration Services in SQL Server 2008 and 2008 R2, we described the process of executing a sample package created using Export and Import Wizard, which copied content of a view in the AdventureWorksDW database to a flat file.

(Tibor Karaszi) Seems like a simple enough question, right? This question (but more targeted, read on) was raised in an MCT forum. While the discussion was on-going and and I tried to come up with answers, I realized that this question are really several questions. First, what is a rollback? I can s