How to add NULL Defense to your SSIS packages using scripting
In this part of NULL Defense series, we will discuss how to create NULL Defense in Script Transformation.
2010-07-08
3,480 reads
Additional Articles
Data Warehousing Architecture - Designing the Data Staging Area
The staging area tends to be one of the more overlooked components of a data warehouse architecture, and yet it is an integral part of the ETL component design. Learn why it is best to design the staging layer right the first time, enabling support of various ETL processes and related methodology, recoverability and scalability.
2010-07-07
6,197 reads
Multi-parameter CLR aggregate in SQL Server 2005
How is it possible to pass multiple parameters to a SQL Server 2005 CLR aggregate?
2010-07-06
2,370 reads
Physical Join Operators in SQL Server - Merge Operator
Part II of the Physical Joins series looks at the Merge operator.
2010-07-05
4,112 reads
Reporting Services 2008 R2: Geospatial Visualization – Part I
Geospatial Visualization is one of the key new features of SQL Server 2008 R2 Reporting Services. This step-by-step tutorial demonstrates the creation of a Map Report.
2010-07-02
3,764 reads
Kimball University: Extreme Status Tracking For Real Time Customer Analysis
Customer interactions create a wealth of timely data that marketing departments are eager to exploit. The customer status fact table provides a central switchboard for using this fast-moving data.
2010-07-01
2,416 reads
Determining Object Access Using SQL Server Profiler
Deanna Dicken examines a SQL Server Profiler event to determine object access...who is using the object, when, and how. This gives the SQL developer or database administrator much needed information for impact analysis prior to a change or the decommissioning of a SQL Server object.
2010-06-30
2,886 reads
Performance Counter DMV sys.dm_os_performance_counters
By querying a single DMV, sys.dm_os_performance_counters to be precise, you can collect counter information that you would receive from PerfMon for the various SQL Server counters.
2010-06-29
3,559 reads
Operator of the Week - Lazy Spool
Continuing to illuminate the depths of SQL Server's Query Optimizer, Fabiano shines a light on the sixth major Showplan Operator on his list: the Lazy Spool. What does the Lazy Spool do that's so special, how does the Query Optimizer use it, and why is it so Lazy? Fabiano Amorim explains all.
2010-06-28
2,774 reads
SSAS: Explaining the State Transitions Viewer for Sequence Clustering
In SQL Server 2005 and SQL Server 2008, Microsoft has added some fantastic visualizations around data-mining algorithms. These visual aids allow us to see exactly what a particular algorithm is predicting or describing—making a difficult subject easier to understand.
2010-06-25
2,023 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers