By Sara Cushman – Good, clean data is sort of like good taste. Many people believe they have it. Plenty don’t. It’s also wildly subjective; the definition of quality data varies from business to business.Data quality problems, though, have far more dangerous and costly consequences than serv

By Russ Whitney – Track the time employees spend working on projects.

Q. I have a 30 gigabyte (GB) database, and I use the Full recovery model. Whenever I use the database consistency checker (DBCC) statement DBCC DBREINDEX to reindex certain large tables periodically, I change the recovery model to Bulk_Logged, then return it to Full after the reindexing is complete.

This course provides delegates with the technical skills required to program a database solution by using Microsoft SQL Server 2000.

by Joe Chang – SQL Server employs a set of formulas to assess the cost of an execution plan for a query based on the type of operations involved, and the number of rows and pages involved. By examining the SQL Server execution plan cost formulas, we can understand why a specific execution plan is ch

Maintaining quality code across a large team is difficult. Even when standards are in place developers can make mistakes that will slip through QA. SSW SQL Auditor, built in VB .NET, allows a developer to set SQL Server design rules and then check the database for code or design elements that ignore

By J. D. Meier – Using SQL and ADO to provide data for your Web application can seem daunting, but these ten tips can noticeably improve your results.

By Serguei Eremenko – Java provides a simple standardized API for reading and writing to and from external resources such as files, databases, and sockets. But even though the Java I/O API covers a wide spectrum of applications’ demands, correct usage of it is not as simple as it may seem. Inefficie

By Dennis Fisher – A Russian security researcher claims he has discovered a flaw in Microsoft Corp.’s SQL Server 2000 which gives an attacker the ability to either crash the server or execute malicious code on the machine.Microsoft is aware of the advisory and is investigating the issue, the

by Norman Cillo – I have encountered a small little ODBC issue on a number of clients. This issue revolved around the ODBC administrator client program and its display of the System DSN names.