(Eric Brown) This chapter covers what’s new in enterprise database administration. It doesn’t just look at the product from a feature list, but groups the features according to some tasks common to database administration.

(Eric Brown) Almost every application has some level of reporting. It may form as something as simple as a query or database view providing the total number of new orders or Web site hits. Yet many companies’ business intelligence only happens in Microsoft Office or static reports, which are printed

(Muthusamy Anantha Kumar) In SQL Server 2005, you can explicitly or implicitly define the execution context. As we all know, a session starts when a user logs on to SQLServer or a connection to SQLserver is made. All operations in that session use the logon credentials used for connecting to SQL Ser

With this study Edison Group has validated the manageability advantage of using Oracle Database 10g over Microsoft SQL Server 2005. With Oracle Database 10g Release 2, DBAs can expect to reduce their daily workload, and businesses can reduce their cost of managing enterprise database systems. (R)

(Neeraj Nagpal) It is difficult to keep track of critical things like backup, space, and error logs in large environments. Different database management tools from third party vendors can help you monitor these but the tools are normally expensive. There is an inexpensive alternative. In this se

Creating an automated SQL query that will retrieve timely data and transmit that information to a person who can act upon it is a basic task for many SQL Server database administrators. However, the process for developing that automated query is not always as obvious as you might expect. This downlo

(Eric L. Brown) In the beta history of the SQL Server 2005 release, significant emphasis has been put on the new features for developing applications. Let’s just say that Microsoft loves developers. But what happened to the features for those who get paged in the middle of the night when mission-cri

(Andrew Calvett) Database Snapshots are a new Enterprise Edition-only tool, introduced in SQL 2005, that provide a read-only, “virtual” copy of a database, at a given point in time. This article will discuss how, as a DBA, you might use snapshots in a production environment and why you might not con

(William Pearson) In this article, we will continue the examination of “MDX for drilling up and down” that we began in Set Functions: The DrillDownMember() Function. We have discussed the nature of drilling, in general, in previous articles of our sub-series, stating that it comprises an analytical

(Bipin Joshi) HTTP is a stateless protocol. To allow users save to state information across requests, ASP.NET provides Session storage. The session variables are stored on per-user basis. In ASP classic, you can store session variables only in the Web server’s memory. However, this approach proves t