Using DTS Global Variables
Global variables are a little known solution in Data Transformation Services (DTS). Often packages become "stale", where you must develop a package for each client.
Case Statement Tricks
The CASE statement is a very flexible tool. Here are just a few of the tricks you can work with it.
DTS Basics
In this article, we get you started with the core knowledge you'll need to transform your data using DTS.
Incorrect Reporting of Date and Time in Performance Log Files
If you use performance log data and need to conduct time-sensitive analysis, watch out for this little feature in Windows 2000.
Non_Continuous Replication
Replicating continuously minimizes latency, but at a cost. If you're replicated a lot of databases, read this article for some ideas about how to trade latency for overhead by runnig your agents in non-continous mode.
Tech Tales
There is a web site devoted to humorous tales from the tech
support field. Check out these samples and submit your own.
New SQL Server 2000 Data Types
In the latest release of SQL Server, Microsoft has added a number of new data types to expand the functionality of SQL Server.
Removing Duplicate Rows
Ever have duplicate rows of data returned in a query? This article by Neil Boyle examines different techniques for removing duplicate rows.
Blogs
Why the masters and what lies ahead
I recently graduated with a Master’s in Strategic Communication from the University of Delaware....
Copilot Reminded Me How To Find a File Handle
By Steve Jones
Recently I was trying to delete a folder and kept getting the “something is...
Planview Portfolios REST API with ADF – Retrieving Actual Data
In the introduction of this blog post series, I explained the use case: extracting...
Forums
Filtered index prerequisites to be used
Hello, After few videos and showing how filtered indexes works, what are the prerequisites...
Enhancing Web Application Performance through Database Optimization: A Comprehensive Study
Comments posted to this topic are about the item Enhancing Web Application Performance through...
Automated Azure SQL VM Patching
Comments posted to this topic are about the item Automated Azure SQL VM Patching
Question of the Day
Automated Azure SQL VM Patching
There is an Automated Patching service for VMs running SQL Server in the Azure Cloud. This uses the SQL Server IaaS Agent Extension to work with PowerShell. What types of patches are installed with this service? Note: All updates are marked with tags, such as Important, Critical, or something else
See possible answers