Dev Nambi Agile Database Development Agile methodologies work well with database developments only if great care is taken to do things right. It requires good... 03 January 2014 28 min read
Robert Sheldon The SQL Server Sqliosim Utility The sqliosim utility is provided with SQL Server to test the I/O stability and 'correctness' of a server. It doesn't... 02 January 2014 14 min read
Dwain Camps Calculating the Median Value within a Partitioned Set Using T-SQL It is ironic that one of the most essential of statistical aggregations, the median, has been so difficult in the... 17 December 2013 12 min read
David Njoku Oracle for Absolute Beginners: Part 1 – Databases A wise man* once said, an expert is someone who uses big words and acronyms where simple phrases would do... 10 December 2013 8 min read
Laerte Junior The PoSH DBA – SQLPSX: SQL Server PowerShell Extensions Every DBA needs to know about SQLPSX, the PowerShell module library that is built by DBAs for DBAs, and designed... 10 December 2013 26 min read
Grant Fritchey SQL Enlight for SQL Server Management Studio The process of doing SQL code-reviews used to be tedious and error-prone. Until SQL Enlight, it was a process that... 10 December 2013 17 min read
Jan Leers Error Handling Most programmers don’t like exceptions, but you should consider them as your closest friends. They are the ones that honestly... 06 December 2013 8 min read
Learn SQL Server Phil Factor in Learn SQL Server Primary Key Primer for SQL Server Every database developer uses keys, but without always understanding all the ramifications. They come with few hard and fast rules,... 02 December 2013 22 min read
Robert Sheldon SQL Server tablediff utility Rob Sheldon continues on his quest to explain all those command-line tools such as SQLCMD, Logparser, SQLIO and tablediff that... 02 December 2013 23 min read
David Njoku A Beginner’s Guide to Optimizer Hints It is often easy to forget this, but in many ways it is after we hit the execute button that... 25 November 2013 7 min read
Kirill Loifman High Availability and SLA requirements for Oracle database Designing a highly available database system involves taking various elements and combining them to suit your business needs and requirements.... 24 November 2013 1 min read
Alex Kuznetsov Lessons Learned from Six Years of Agile Database Development Alex Kuznetsov describes the agile principles, techniques and tools that allowed his development team to make frequent database refactoring a... 19 November 2013 26 min read
Robert Sheldon Microsoft’s Log Parser Utility: Swell ETL For loading text, CSV or XML files into SQL Server, the Log Parser utility, with its amazing SQL engine, is... 12 November 2013 21 min read
Laerte Junior The PoSh DBA – Getting Airborne with PowerShell Maybe the best way of helping the busy database professional to get started with practical PowerShell-based administration is to pull... 31 October 2013 26 min read
Joe Celko Window Functions in SQL SQL's windowing functions are surprisingly versatile, and allow us to cut out all those self-joins and explicit cursors. Joe Celko... 31 October 2013 16 min read
Bobby Curtis Overview of a few features in Oracle Pluggable Database 12c By now, many of us have downloaded, installed and either played with or implemented the latest release of the Oracle... 22 October 2013 6 min read
Dwain Camps Calculating Values within a Rolling Window in Transact SQL Before the SQL Window functions were implemented, it was tricky to calculate rolling totals or moving averages efficiently in SQL... 17 October 2013 19 min read
Jonathan Lewis Histograms Part 3 – When? In part 2 we looked at the way that Oracle collects and uses height –balanced histograms, and raised the problem... 16 October 2013 11 min read
Annette Allen SSIS Basics: Using the Merge Join Transformation SSIS is able to take sorted data from more than one OLE DB data source and merge them into one... 16 October 2013 19 min read
Nigel Rivett The ETL from Hell – Diagnosing Batch System Performance Issues Too often, the batch systems that underlie a lot of database processing just grow without conscious design. When runs start... 15 October 2013 17 min read
