How to use a Script Transformation in SSIS
This shows you how to use the Script Transform to make intelligent decisions about your data and clean it appropriately.
2006-01-13
1,104 reads
Articles
A Review of sqlSentry 2.5
In this review, Brian reviews one of his favorite tools in his DBA toolkit. He shows you some of the new features in this event management system and how it can shave hours off your day each day.
2006-01-12
6,674 reads
SQL Server Integration Services - Debugging Script Componen
Continuing the coverage of debugging features in SQL Server 2005 Integration Services Data Flow, which we started in the previous installment of this series, we will now focus on the Script Component.
2006-01-12
1,301 reads
Introduction to SQLCMD
SQL Server 2005 has deprecated osql and isql as command line tools and replaced them with SQLCMD. Haidong Ji brings us an introduction to this new tool and a few tricks to make you more productive when using it.
2006-01-11
18,400 reads
New 64-bit sqlSentry Enhances Performance and Scalability
sqlSentry, a leading developer of management solutions for Microsoft SQL Server, today announced that it has released the 64-bit version of its industry-leading scheduling and notification management system for SQL Server 2005, supporting both x64 and Itanium-based systems.
2006-01-11
2,707 reads
SED and the Big Bad UNIX File
One would think that when you have to work with Unix text files, they would be the same as Windows text files. That is not quite the case and Peter Ward brings us a look at how this caused a problem in DTS and a way you can fix it.
2006-01-10
9,532 reads
A surrogate key architecture to perform powerful database operations
The alternative to surrogate keys is natural data keys. In order to understand the many substantial benefits of surrogate keys it's necessary to discuss some background on the issues involved.
2006-01-10
4,860 reads
Usage-Based Optimization in Analysis Services 2005
In this lesson, we revisit usage-based optimization, a subject that we undertook in my article MSAS Administration and Optimization: Simple Cube Usage Analysis, in September of 2003, and MSAS Administration and Optimization: Toward More Sophisticated Analysis in October of 2003. In the earlier articles, we discovered that, among several tools that Microsoft SQL Server 2000 Analysis Services offered us to assist in the maintenance and optimization of our cubes, two of these tools, the Usage Analysis Wizard and the Usage-Based Optimization Wizard, leveraged the usage-based optimization features of Analysis Services.
2006-01-10
1,810 reads
PART 8: ESTIMATION
Data modeling is no doubt one of the most important and challenging aspects of developing, maintaining, augmenting and integrating typical enterprise systems. More than 90% of functionality of enterprise systems is centered round creating, manipulating and querying data. It therefore stands to reason that individuals managing enterprise projects should leverage on data modeling to execute their projects successfully and deliver not only capable and cost effective but also maintainable and extendable systems
2006-01-09
2,421 reads
SQL Writer in SQL Server 2005
Definitely written for backup ISVs, but this is an interesting architectural article as to how the backup systems will work in SQL Server 2005.
2006-01-06
2,193 reads
Blogs
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Back at Small Data SF in 2025
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
Forums
Large posts full of code not allowed anymore?
Several times now, I've seen a post asking for a solution. I've replied, and...
Data > Hype
Comments posted to this topic are about the item Data > Hype
Create and Read the Analysis Services Flight Recorder
Comments posted to this topic are about the item Create and Read the Analysis...
Question of the Day
Slipstream parameters
What parameters are needed to enable a slipstream installation for setup.exe (SQL Server setup)?
See possible answers