David Njoku Oracle for Absolute Beginners: Part 4 – Multi-table queries Part 1, Part 2, Part 3 A wise man* once said: To build the Great Wall of China, you must... 03 March 2014 10 min read
Syed Jaffar Hussain Gaining maximum benefits from Oracle Data Guard When Oracle initially introduced the standby database concepts, the solo intention was to deliver the solutions to protect enterprise critical... 26 February 2014 6 min read
Robert Sheldon Seven SQL Server Under-Used Utilities There are more than ten useful command-line applications that are either associated with, or are distributed with, SQL Server. Some,... 25 February 2014 13 min read
Fabiano Amorim Fixing Cache Bloat Problems With Guide Plans and Forced Parameterization Imagine it. You've been asked to fix a dire performance problem with a SQL Server database. You find a severe... 20 February 2014 10 min read
Dwain Camps Calculating Gaps Between Overlapping Time Intervals in SQL There are a number of real-life reporting tasks in SQL that require a 'gaps and islands' analysis. There are a... 14 February 2014 21 min read
David Njoku Oracle for Absolute Beginners: Part 3 – Update, Insert, Delete Part 1, Part 2. A wise man* once said: So no-one told you life was gonna be this way. Your... 13 February 2014 10 min read
David Tate Guerrilla Project Management for DBAs All DBAs need to engage in a little project management to help make sure everything runs smoothly. In this extract... 13 February 2014 27 min read
Jes Borland SQL Server Indexed Views: The Basics Views are a valuable tool for the SQL Server Developer, because they hide complexity and allow for a readable style... 12 February 2014 23 min read
Joe Celko SQL Server SEQUENCE Basics The SEQUENCE statement introduced in SQL Server 2012 brings the ANSI SQL 2003 standard method of generating IDs. This is... 06 February 2014 13 min read
Patrick Barel Result Cache (Part 2) Insanity: doing the same thing over and over again and expecting different results. – Albert Einstein In part 1 we... 04 February 2014 5 min read
Nirmal Sharma Hosting SQL Server in Hyper-V Replica Environment A Hyper-V replica will provide a rapid disaster-recovery by simply replicating to a standby site a VM running at the... 04 February 2014 26 min read
Patrick Barel Result Cache (Part 1) First, solve the problem. Then, write the code. – John Johnson We are always looking for ways to do things... 28 January 2014 5 min read
Feodor Georgiev Collect Your SQL Server Auditing and Troubleshooting Information Automatically If you have a number of SQL Server instances with versions ranging from 2005 upwards, with a whole host of... 28 January 2014 12 min read
Joe Celko Nesting Levels in SQL The 'Structured' part of SQL denotes the fact that queries can be nested inside each other in such a way... 27 January 2014 13 min read
Robert Sheldon The SQL Server Sqlio Utility If, before deployment, you need to push the limits of your disk subsystem in order to determine whether the hardware's... 27 January 2014 14 min read
Dwain Camps The Performance of the T-SQL Window Functions Window Functions in SQL greatly simplify a whole range of financial and statistical aggregations on sets of data. Because there... 17 January 2014 16 min read
Gail Shaw SQL Server Deadlocks by Example When a SQL Server instance deadlocks, it can be anything from minor irritation to something far more severe. In this... 16 January 2014 54 min read
Hugo Kornelis Generating Test Data in TSQL To test SQL, you need test data. There are usually many reasons why you can't use production data. Although it... 14 January 2014 30 min read
David Njoku Oracle for Absolute Beginners: Part 2 – SQL A wise man* once said, no one’s ever learned how to cook just by reading recipes. And so, since we... 13 January 2014 13 min read
Laerte Junior The PoSh DBA – Reading and Filtering Errors DBAs regularly need to keep an eye on the error logs of all their SQL Servers, and the event logs... 10 January 2014 31 min read
