(Nelson King) Social networking, blogs, wikis, RSS feeds, mashups, and other Web 2.0 technologies are hitting businesses like a gale-force wind. IBM recently launched Info 2.0 to capture, focus, and control this energy. The initiative’s ultimate course will depend on its talented (and somewhat surpr
Other News
Flushing a single cursor
(Fairlie Rego) In a very intensive OLTP environment plan stability is of utmost importance as a single sub optimal query can bring the system down to its knees.
RMAN
(Arup Nanda) Advice on data recovery, parallel backup of the same file, and virtual catalogs for security are just a few of the new gems available from RMAN in Oracle Database 11g.
Creating a Job queue in Innodb
(Jay Janssen) So you want to build a system that does jobs. You want the jobs to be able to be run in parallel for speed, but also for redundancy. This system needs to be coordinated so, for example, the same jobs aren’t being done twice, the status of every job is easy to see, and multiple servers
Oracle 11g: Another New Algorithm
(Grégory Guillou) If you are or have ever been a SQL developer, it’s very likely you’ve been asked to return the rows from two joined tables, including all the rows from both tables that do not have a corresponding row in the other table. Oracle 9i introduced the FULL OUTER JOIN syntax to better add
sys.dm_exec_sql_text
(Louis Davidson) This dynamic management object returns the SQL that was saved when a query was executed. This is a very exciting and useful thing to have, as there are dynamic management views that you will be able to use to get statistics for a query, as well as the full SQL for any actively execu
Calculate Percentiles with SQL Server 2005
(Cecil Lew) When you need to analyze numerical data, percentiles are handy for understanding the distribution. Oracle has been providing analytical functions such as NTILE, PERCENTILE_CONT, and RANK since version 8, while SQL Server has been playing catch up. With SQL Server 2005, Microsoft finally
Restoring the Master database in SQL Server
(Steven Warren) As a Microsoft SQL Server administrator, you must know how to recover a corrupt master database. The master database stores your logins and, most importantly, the pointers to all of your databases. Without the master database, you can’t successfully start SQL Server. I’m going to wal
Building Out a BI Infrastructure
Featured Article(s) Is it Time to Terminate an Employee A few years ago I had to make an incredibly hard decision on whether I let an employee go or if I tried to keep that person on my team and develop that persons skill set. Far too often people determine a DBAs skill set by only factoring in how much […]
Business Intelligence – What’s Your Approach?
New SQLonCall Show Posted! Check it out – Chris has put together How to hire a DBA as a show! Tips, tricks – and much more. Find out what you need to know from both the hiring and the being-hired end of things. Watch the show here. > …and, you can catch the most recent SelectViews SQL Server Show here […]