Accessing and Updating Data in ASP.NET 2.0: Data Source Control Basics
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.
Close These Loopholes in Your Database Testing
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.
A Replication Interview Book Review
Andy Warren has had a great deal of experience with SQL Server replication and just picked up a new book on the topic. Rather than the standard book review, he decided to conduct the review as an interview with the author.
10 things you can do to give old servers a second life
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.
Logical Functions: IsGeneration(): Conditional Logic within Filter Exp
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.
Getting SQLAgent to Respond Faster
One limitation of SQLAgent is that granularity to which you can schedule jobs: every minute. Sometimes there are things that you would like to happen more frequently, like alerting. Johan Bijnens brings us a technique for getting your SQL Agent to respond to alerts in as little as every 10 seconds.
How Much Scalability Do You Have or Need?
How many cores (or hardware threads) can your code harness to get its answers faster?
RBAR: 'Row By Agonizing Row'
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.
SQLMesh Personal for Free
A new Java based application for searching SQL Server and Sybase databases is available for free from SQLMesh.
Working with Time Frames in T-SQL
There is often a need to work with time data representing various events and then reporting on them in SQL Server applications. However T-SQL doesn't necessarily make this easy. However new author Joe Lynds brings us an article on some advanced T-SQL to do just that.
Blogs
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers