(Iain Thomson) Microsoft has revealed some of the changes in the forthcoming release of its SQL 2005 database, scheduled for later in the year.

(Eli Leiba) There are cases, especially in large organizations, where the DBA team is too small to handle all the database management tasks on all the SQL Servers across the organization. In these cases, the DBA can grant programmers the db_owner role. (R)

(Brad M. McGehee) Virtually every SQL Server runs one or more daily jobs. And most likely, runs many weekly jobs. Unfortunately, most DBAs set up jobs, and then forget about them, unless of course they break. But if they run day after day without any problems, most jobs are forgotten about.

(Raghu Donepudi)

As we develop SQL Server applications with more and more concurrent users, there is inevitable contention as users compete for data resources. They are either forced to wait for each other or face the risk of reading inconsistent data due to in-progress changes. This trade-off between correctnes

(Muthusamy Anantha Kumar) Many Enterprises create and maintain applications that reside on “IBM Lotus Domino Server.” Since the Lotus Domino server has the capability of handling applications and messaging, it has become a prime requirement for a SQL Server DBA to cross- reference data or import and

When a large deallocation occurs in Microsoft SQL Server 2000, SQL Server may temporarily stop responding to other requests. Operations, like dropping tables, dropping work files, and dropping indexes, that are performed on objects that are multiple gigabytes in size may cause 17883 error messages i

(Ramunas Balukonis) In my previous article (Analysis About Analysis Services) I showed how to make analysis from the log of Analysis Services. As the information about olap queries are modest, we should try to get as much information from the log as we can. For example, we should known how many part

Discover new consolidation techniques that dramatically simplify management of SQL Server and maximize use of existing server and storage assets. Presenter Michael Callahan, CTO of PolyServe, discusses breakthroughs in clustering technology for lower-cost, highly available database deployments. (R

(Kalen Delaney) As I’ve mentioned, I get many article ideas from questions that people ask me directly or that come up on the public newsgroups. When the same question comes from several directions at once, I start thinking that maybe it’s time to write about that question. My idea for this month’s