One of the most integral components and critical success factors of any enterprise data warehousing initiative is the Solutions Architecture document, a high-level conceptual model of a data warehousing solution. Learn why this collaborative effort that addresses the needs of all major stakeholders, including both the business units and Information Technology (IT), is essential.
2010-07-09
2,224 reads
You can create a database under the assumption that SQL looks after all the problems of concurrency. It will probably work fine under test conditions: then, in the production environment, it starts losing data in subtle ways that defy repetition. It is every Database Developer's nightmare. In an excerpt from his acclaimed book, Alex Kuznetsov explains why it happens, and how you can avoid such problems.
2010-07-09
3,657 reads
Take your peers out of their comfort zone and do you know how well they'll perform?
2010-07-08
282 reads
An article from Scott Zurolo tests the terformance of SQL Server 2008 Table Valued Parameters against more traditional methods of updating many rows at once.
2010-07-08
9,887 reads
In this part of NULL Defense series, we will discuss how to create NULL Defense in Script Transformation.
2010-07-08
3,480 reads
If you have multiple ports, this article from Mark Greenbaum will tell you which port a connection is using
2010-07-07
7,978 reads
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
The July 2010 PASS Performance VC Presentation by Jason Strate on July 6th 12:00 PM EDT (GMT -4).
2010-07-06 (first published: 2010-07-01)
3,237 reads
The provided SSIS package contains a single script task that will script all SQL Server 2000/2005/2008 Agent Jobs into individual files.
2010-07-06
12,930 reads
How is it possible to pass multiple parameters to a SQL Server 2005 CLR aggregate?
2010-07-06
2,370 reads
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
By Steve Jones
This is kind of a funny page to look at. The next page has...
A while ago I blogged about a use case where a pipeline fails during...
Comments posted to this topic are about the item Why End-User Testing Is Even...
I have a table I didn't design that has tons of repeating groups in...
Comments posted to this topic are about the item Writing as an Art and...
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers