Instead of hesitantly thinking, "Am I ready?" the morning of your exam, wouldn't you rather be saying, "I'm ready!" with confidence? Boost your confidence with MCSE Readiness Review Exam 70-029: ...

I’ve created a script that monitors a table in a SQL Server database. I’m only interested in one column in the table: TimeStamp. If the maximum (newest) value in TimeStamp is more than 30 minutes ...

Unfortunately, not every SQL database is always available when we expect it to be. When you're creating automation scripts to discover, add, update or remove records from a remote SQL database, you ...

Microsoft this week posted new test versions of SQL Server 2005, Visual Studio 2005 and the .NET Framework 2.0. Visual Studio and .NET came out in Beta 2 versions. Tightly coupled with those public ...

A free tool to reduce coding for developers who like to surface T-SQL database recordsets in a simple collection of customized POCO objects. Every so often, I find myself wishing that I had a utility ...

As any database admin knows, mastering the subtler nuances of SQL can be likened to the black arts. For me, tuning the efficiency of SQL queries on large, heavily used databases is a perfect example.

Everyone wants faster database queries, and both SQL developers and DBAs can turn to many time-tested methods to achieve that goal. Unfortunately, no single method is foolproof or ironclad. But even ...