Data Validation Sample
This video sample shows how the clustering algorithm can be used to automatically validate data.
2006-11-08
2,184 reads
Additional Articles
SQL Server 2005 Transactional Replication Agents
SQL Server 2005 replication agents are configured optimally out of the box, but occasionally you might need to alter the default behavior by tweaking the agent's parameters. SQL Server 2005 exposes some parameters through graphical interface that were available only from command line or through agent job steps in previous releases. Baya Pavliashvili encourages you to learn the new options available with each replication agent and how to fine-tune these options for your applications.
2006-11-07
2,281 reads
Step-by-Step Guide: Installing SQL Server 2005 Reporting Services
Working with a new piece of technology can be intimidating. Not having the technology installed correctly can only lead to more difficultly. This guide outlines steps to properly install SQL Server 2005 Reporting Services and the current service pack to get you going in the right direction.
2006-11-06
3,793 reads
The CV Detectives
You may find this shocking, but some IT people lie on their CV. Richard Morris offers a rare glimpse into the dark underworld of the people tasked with rooting out the CV fraudsters.
2006-11-03
3,591 reads
Toying with template parameters in SQL Server 2005
If you create functions or stored procedures from SQL Server 2005 Management Studio, you will notice that the new window is filled with a template. In general, you get a skeleton interspersed with markers. This article discusses how you can use templates.
2006-11-02
2,522 reads
Kimball University: Four Fixes Refurbish Legacy Data Warehouses
DW/BI professionals are often tasked with making evolutionary upgrades and improvements to minimize cost and upheaval in the current analytic environment. We explore four upgrades that can breathe new life into legacy data warehouses.
2006-10-31
2,682 reads
Fine Tuning your Database Design in SQL 2005
If your SQL Server app is suffering from poor performance and you suspect a missing index, then read on
2006-10-30
2,990 reads
Contract Coding: Ensuring your Client pays up
Damon Armstrong learned the hard way about the consequences of not having a clearly defined project scope or work contract
2006-10-27
3,089 reads
Calculating financial values in SQL Server
SQL Server 2000 and 2005 do not include much in the way of financial functions, but there are many sources for the formulas for financial calculations. In this tip, I present the present value (PV) and future value (FV) functions, both of which are scalar UDFs.
2006-10-26
2,458 reads
SQL Server DATE/TIME Workbench
The definitively "hands-on" guide to handling dates and times in SQL Server
2006-10-25
2,883 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers