DTS to SSIS Migration
Determining how you will upgrade your DTS packages to SQL Server Integration Services (SSIS) is the first step in creating a DTS-to-SSIS migration strategy.
DTS Polling
Lots of packages exist that will import data files for you, even if you do not know the file name ahead of time. But most of them expect the files to be there. New author Andre Quitta brings us a technique he has for checking to see if the files are even there before importing them.
Secrets of successful IT projects
Some time ago, I worked on a team that was attempting to define an IT strategy for a large multinational company. Management incorrectly thought the company was unique in that it had a high number of failed IT projects. In fact, only one in four IT projects can be termed successful, if the benchmarks of success are adherence to scheduled completion time and budget, and realization of the project goal, whether that be saving money, growing the business, or what have you. I have to explain this because many of you may never have come across one.
An Elegant ETL Solution: Except for Lost Data
An early adopter of SQL Server 2005 found some issues with Integration Services. And he shows how it was debugged and the issue solved. This is a great look at some of the helpful parts of Intration Services in solving problems as well as a few places it falls short.
Using SQL Server 2005 sqlcmd Utility
SQL Server 2005 provides some new command line utilities. One such utility is "sqlcmd". The sqlcmd utility is used to run adhoc queries interactively from a command prompt window, or can be used to execute a script containing T-SQL statements. The sqlcmd utility is a great improvement over osql and isql of older releases of SQL Server. In this article, I will explain some of the features this new command line utility brings to administering SQL Server.
XML Indexes in SQL Server 2005
Use the relational query engine in SQL Server 2005 to make a single query plan for the SQL and XQuery parts of your queries, and make the implementation of XML queries fast and easy to predict and tune.
SQLDBControl BETA Testers Wanted
A new product has just been released in Beta to help you with source control for your SQL Server development. Beta testers are wanted, so if you're interested, read on.
Starting and Stopping SQL Server Part 2
Continuing with his series, Andy Warren looks at what it means for SQL Server 2000 to run as a service and some of the options you have for starting, stopping, and restarting your server.
SQL Server Notification Services Architecture
Most SQL Server 2000 DBAs have heard of Notification Services, but are they aware of how it works and what it's capabilities are? This is a great platform on which to build any type of messaging/notification/subscription application. New author and PASS board member Joe Webb brings us a look at this add on for SQL Server.
Using CLR Integration in SQL Server 2005
This paper describes the new CLR integration features of SQL Server 2005 and how database application developers and architects can take advantage of them to write user-defined procedures, functions, and triggers, as well as define new types and aggregates
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers