(Serdar Yegulalp) It’s always good to be on top of the latest technology, and many DBAs with SQL Server 2000 or 7.0 setups are eyeing a migration to SQL Server 2005. The same DBAs typically have to rework applications to operate correctly with SQL Server 2005, such as custom databases, in-house fron

(Scott Bekker) Six months after its launch, SQL Server 2005 remains free of showstopper bugs or known security issues. Still after five years between database releases, Microsoft hasn’t shown evidence yet that there’s huge pent-up demand for SQL Server.

(Madjarov.D.N) A few months ago I were involved to test and estimate new options which Microsoft Reporting Services 2005 provide to developers to make a better reports. One of these options is the great ability to use as a data source one ore more WebServices. Unfortunately the Microsoft Help which

(Mike Gunderloy) It’s a familiar problem for most developers. The application is just about finished, the near-final bits are rolled out to the test servers…and things aren’t quite fast enough to suit everyone. As you scramble around looking for places to squeeze out another few percentage points

(Greg Robidoux) If you haven’t done much yet with SQL Server 2005, the time has come. It has been six months now since Microsoft released the new DBMS to manufacturing (RTM), and a month since it released its first service pack — yet many people haven’t taken the time to prepare or even think about

(Wade Wilbur) For low-volume databases, those that are predominantly read and not written to, or database tables that are designed to not be updated or only updated under rare circumstances, a DBA or developer may be interested in being notified whenever the data in a particular table is modified. O

(Adam Machanic) Exception handling is a key component of any solid software development methodology. Fact is, bugs do exist and exceptions will occur at some point when code runs. But what should you do to deal with exceptions and ensure they don’t cause problems? Unfortunately, when programming SQL

(Abdul (Rajib) Bahar) Try and Catch is very popular among the developer community writing code in C#, C++, or other high level languages. The conventional term referring to Try-Catch blocks is Exception Handling. Exception Handling is simply a breach of an application’s predefined assumptions. It en

(Scott Klein) There is a plethora of new T-SQL features and enhancements in SQL Server 2005, and you could probably write a small book talking about all of them. However, this article will focus on one of them — specifically, Common Table Expressions (CTE), because personally they have come in handy

(Andras Belokosztolszki, David Connell, Tom Harris and Richard Mitchell) Last month saw the release of the SQL Bundle 5. Here, some key members of the Red Gate development team offer insight into some of the major new features, and the technical challenges they faced in implementing them.