This article explores the concepts and advantages of data source controls, and compares their usage in ASP.NET 2.0 to data access techniques in ASP.NET 1.x.
2007-08-20
2,187 reads
Alex Kuznetsov starts off a series of three articles on 'Unit Testing' your database development work. He begins by describing five simple rules that make all the difference.
2007-08-20
3,248 reads
To run with the pack in terms of performance, productivity, and competition, servers that are long in the tooth have to be put out to pasture regularly. But there might be (and usually is) some life left in these early retirees, and they can still be put to good use.
2007-08-17
4,108 reads
Use IsGeneration() to support conditional logic within filter expressions. BI Architect Bill Pearson looks beyond employing IsGeneration() in calculations, and provides hand-on practice in its use within the MDX Filter() function.
2007-08-17
2,109 reads
How many cores (or hardware threads) can your code harness to get its answers faster?
2007-08-16
2,251 reads
Remi Gregoire describes one of the Support nightmares, the vice of RBAR Database Programming, 'Row By Agonising Row', and illustrates how the effect of RBAR can sometimes be felt only years after an application is released, when the database supporting the application grows.
2007-08-16
3,179 reads
A new Java based application for searching SQL Server and Sybase databases is available for free from SQLMesh.
2007-08-16
3,453 reads
This tutorial shows you how to properly install Microsoft's SQL Server 2005, avoiding the pitfalls of an unsuccessful deployment.
2007-08-15
2,433 reads
SQL Server 20008 will be released approximately February of 2008, along with a new version of Visual Studio and Windows. This article will highlight some of the new features and benefits found in SQL Server 2008.
2007-08-15
7,510 reads
In a previous article I showed how to look at what query plans are in SQL Server's memory. In this article I'll look at how they got there and how and when they get reused. This is commonly called compiling a query plan. More specifically I'll look at how and when SQL Server can parameterize dynamic SQL
2007-08-14
4,567 reads
Short version You want to get this running as fast as possible. Do these...
By Steve Jones
Last week I asked you to write about SQL Server 2025 and what things...
By SQLPals
Writing Better Dynamic SQL This updated and "sort" of a style...
Comments posted to this topic are about the item SQL Server 2025 has arrived!
Comments posted to this topic are about the item Don't Create Workslop
Comments posted to this topic are about the item What is the original database...
What is returned when this code is run?
SELECT ORIGINAL_DB_NAME()See possible answers