(Dr. Song Li) This article introduces a method to load and execute SSIS packages in Microsoft Windows with a demo WPF application.
Tag: sql server
Statistically Speaking
(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
Getting Dynamic in SSIS Queries
(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
Comparing Analysis Services and PowerPivot
(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
SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE
(Pinalkumar Dave) Today, we are going to discuss about something very simple, but quite commonly confused two options of ALTER DATABASE.
A High Level Comparison Between Oracle and SQL Server – Part III
(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
Monitor Your SQL Server Virtual Log Files with Policy Based Management
(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
Try Catching These Errors
(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.
Introduction to Control Flow and Data Flow of SSIS 2008
(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.
Are log records removed from ldf file for rollbacks?
(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