Jonathan Lewis Execution Plans Part 3: “The Rule” In the first two articles in this series we listed a couple of methods for generating or retrieving execution plans... 25 April 2014 13 min read
Kathi Kellenberger SQL Server Reporting Services Basics: Building SSRS Reports SQL Server Reporting Services is one of the most popular components of SQL Server, but it has always been surprisingly... 25 April 2014 27 min read
Kevin Feasel SQL Injection: How it Works and How to Thwart it This article is an extract from the book Tribal SQL. In this article, Kevin Feasel explains SQL injection attacks, how... 24 April 2014 33 min read
Robert Sheldon SQL Server XML Questions You Were Too Shy To Ask Sometimes, XML seems a bewildering convention that offers solutions to problems that the average database user doesn't have. To make... 22 April 2014 26 min read
Syed Jaffar Hussain How is data security maintained and what’s new in Oracle 12c database security – Part 1 Securing enterprise business-critical data is as important for DBAs as database tuning and data protection. Oracle provides comprehensive and powerful... 16 April 2014 5 min read
Phil Factor Searching for Strings in SQL Server Databases Sometimes, you just want to do a search in a SQL Server database as if you were using a search... 15 April 2014 20 min read
Randolf Geist Parallel Execution Skew – Demonstrating Skew After providing a baseline for Parallel Execution working as expected in the introduction of this series, in this part I’ll... 14 April 2014 8 min read
David Njoku Oracle for Absolute Beginners: Part 5 – PL/SQL A wise man* once said, all software programming is about hoops and loops. You take some variables, give them hoops... 07 April 2014 13 min read
Joe Celko Database Normalization Basics The task of Database Normalization doesn't have to be painful, especially if you follow Old Mother Celko's Normalization Heuristics.… 07 April 2014 20 min read
Phil Factor Continuous Delivery and the Database Continuous Delivery is fairly generally understood to be an effective way of tackling the problems of software delivery and deployment... 03 April 2014 38 min read
Grant Fritchey The DBA Detective: Disturbing Developments Originally one of the articles in the first DBA Team series, Grant wonders what Raymond Chandler or Dashiell Hammett would... 31 March 2014 14 min read
Jonathan Lewis Execution Plans Part 2: Things to see In part 1 of this series we saw two basic ways of creating, or acquiring, execution plans. The first method... 26 March 2014 12 min read
Robert Sheldon 14 SQL Server Indexing Questions You Were Too Shy To Ask One of the first things one needs to understand well about SQL Server is indexes, but somehow many of the... 25 March 2014 22 min read
Dwain Camps High Performance Relational Division in SQL Server Relational division is used in SQL to select rows that conform to a number of different criteria. It is a... 24 March 2014 28 min read
Randolf Geist Parallel Execution Skew – Introduction This is the first part of a mini-series about Parallel Execution Skew and how to address it. Introduction So what... 18 March 2014 10 min read
Jonathan Lewis Execution Plans: Part 1 Finding plans If you have to tackle performance problems in an Oracle database one of the most important skills you need to... 12 March 2014 14 min read
Warwick Rudd AlwaysOn Availability Groups – What Not to do when Adding Databases SQL Server's AlwaysOn Availability Groups provide a very resilient way of providing High-availability for SQL Server databases, but there are... 10 March 2014 10 min read
Joshua Feierman Applying The Scientific Method to SQL Server Performance Tuning Database administrators tend to rely more on science than intuition, and may therefore seem exasperatingly cautious to other IT people.... 10 March 2014 14 min read
Laerte Junior The PoSh DBA – Specifying and Gathering Performance Counters If you are needing to keep tabs on a number of servers and applications in a Windows domain then performance... 07 March 2014 18 min read
Joe Celko On Handling Dates in SQL The calendar is inherently complex by the very nature of the astronomy that underlies the year, and the conflicting historical... 06 March 2014 16 min read
