This article presents a strategy for testing ETL applications that perform data movement and populate data warehouses. It is useful information for the testing community as well as designers and managers charged with planning a data warehousing implementation.
2007-09-21
2,460 reads
Developing an effective solution requires quality within and across all components of the BI architecture.
2007-09-20
2,840 reads
In the simplest terms, a NULL value represents an unknown value. It's unknown in the sense that the value is: missing from the system, may not be applicable in the current situation, or might be added later. NULL values are different than any other value and are sometimes hard to compare and handle.
2007-09-20
3,550 reads
The Cincinnati SQL Server Users group is getting going again with a meeting on Tuesday, September 25th. If you are in the area, check out the details.
2007-09-20
2,473 reads
SQL Server 2005 allows DBAs to set configurations for SSIS packages outside the package to facilitate a smooth transition between different environments.
2007-09-19
3,321 reads
This article discusses: How SQL injection attacks work, Testing for vulnerabilities, Validating user input, Using .NET features to prevent attacks, and Importance of handling exceptions
2007-09-19
4,869 reads
In the latest in their popular series on 'Unit Testing' database development work , Alex K and Alex S give some examples of unit testing Database Modifications
2007-09-18
3,422 reads
We've compiled a list of our dozen most popular tips in the area of upgrading to SQL Server 2005 and they run the gamut.
2007-09-18
4,268 reads
An article explaining where to find packages when saved to SQL Server.
2007-09-17
3,092 reads
2007-09-14
3,449 reads
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
I have a couple of SQL Agent job steps which run PowerShell commands of...
Comments posted to this topic are about the item Database security permissions save script
I have a SQL Agent job for backing up a set of Analysis Services...
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers