Alexzander Nepomnjashiy continues his series focusing on SQL Server alerts and errors with a detailed look into using the Windows Performance Monitor to proactively track SQL Server performance.
Other News
Configuring a Mail Profile for SQL Server
You can configure a SQL Server mail profile so you can send and receive e-mail by running Transact-SQL code (for example, by using the xp_sendmail extended stored procedure to send e-mail). You can also configure a mail profile for SQL Server Agent so that e-mail will be sent to operators automatica
ROLLUP feature in Oracle 8i
By Srinivas Chittimalla – If you wish to find, for example, the number of employees by department, you can use the following query (using the standard demo tables in Oracle).
Storing Your Data in Oracle
Compared to SQL Server, Oracle allows a DBA to go much further under the hood to properly manage data space requirements. However, space allocation in Oracle is complicated. Joe Lax shows you how locally managed tablespaces can let the database engine make most of the decisions for you.
SQL Server: The Sequel
By John Foley – Microsoft’s SQL Server has been playing catch-up for years. As the database software turns 10 and prepares for a 64-bit power boost, is it what big business needs?
A decade of data — Seattle summit to celebrate SQL Server, preview Yukon
By Margie Semilof – It may be the 10th anniversary of Microsoft’s SQL Server, but database administrators at the annual SQL Server user group meeting next week in Seattle are more likely to be buzzing about the first Yukon beta scheduled for early in the new year.
SQL Server’s Future: Better, Faster, Easier
Brian Moran has gained a new appreciation for the value of stored procedures exposed as Web services. Will this functionality, which Microsoft will enhance in Yukon, make his current theory of extreme performance irrelevant?
IBM, Sharp Build Linux Platform for PDAs
By Jay Wrolstad – IBM and Sharp want to bring Linux to the mobile worker. Sharp’s strategy is to create an open standards Linux/Java platform with support for enterprise applications and databases from IBM, Microsoft, Oracle and Sybase, among others.
Microsoft scraps server OS plans
Microsoft has scratched plans for a major overhaul to an upcoming version of its Windows operating system for servers, the company confirmed Tuesday.The Redmond, Wash.-based software maker has been working on delivering the next major desktop and server versions of Windows–code-named Longho
Generate a bar graph for tablespace utilization, part 2
By Dilbagh Singh – This is a good tip indeed but it takes two or three steps before one can see the graph. Here is a Perl version of it that does the same with one click. It works very well except for the password part; I am using OPS$ id in the real script.