Scott Swanberg Exploring Your SQL Server Databases with T-SQL Most DBAs hoard their own favourite T-SQL scripts to help them with their work, often on a USB 'thumbdrive', but... 09 October 2014 40 min read
William Sisson Set-based Constraint Violation Reporting in SQL Server When you're importing data into an RDBMS in bulk and an exception condition is raised because of a constraint violation,... 07 October 2014 18 min read
Robert Sheldon Questions about Primary and Foreign Keys You Were Too Shy to Ask It is strange that one can ask simple questions about extended events or Hekaton at professional events and conferences without... 06 October 2014 36 min read
Satishbabu Gunukula Oracle Database 12c – RMAN New Features: Part1 Oracle Database 12c has new enhancements and additions in Recovery Manager (RMAN). The Recovery Manager continues to enhance and extend... 29 September 2014 8 min read
Edward Elliott Improving the Quality of SQL Server Database Connections in the Cloud To access SQL Server from the client, you use TDS protocol over TCP. This is fine over reliable LANs but... 22 September 2014 20 min read
Dwain Camps Filling In Missing Values Using the T-SQL Window Frame Since SQL Server delivered the entire range of window functions, there has been far less justification for using the non-standard... 18 September 2014 18 min read
David Njoku Introduction to Oracle Password Verification and Complexity Function Security is in the news again. It seems there’s no greater click-bait than a story about indecent photos of beautiful... 16 September 2014 5 min read
Robert Sheldon Importing Excel Data into SQL Server Via SSIS: Questions You Were Too Shy to Ask The job of retrieving data from Excel, and importing it into SQL Server hasn't the same appeal or glamour as,... 11 September 2014 31 min read
Jonathan Lewis Execution Plans Part 10: Guesswork In part 9 we saw an example of a simple nested loop join where the basic method for interpreting the... 09 September 2014 9 min read
Joshua Feierman The Mindset of the Enterprise DBA: Harnessing the Power of Automation After you have done the necessary groundwork of standardizing and centralizing your database administration processes, you are now in a... 02 September 2014 16 min read
Jonathan Lewis Execution Plans Part 9: Multiplication In part 8 we looked at a very simple execution plan involving a hash join; but that example was too... 29 August 2014 7 min read
Kathi Kellenberger SQL Server Reporting Services Basics: Customizing SSRS Reports While the Reporting Wizard and basic report tables will do for prototyping, very soon we'll want to add some finesse... 27 August 2014 23 min read
Satishbabu Gunukula Should you install or clone Oracle Home? What is cloning? Cloning is a process of copying an existing installation to a different server or location. Cloning is... 20 August 2014 11 min read
Jonathan Lewis Execution Plans Part 8: Cost, time, etc. It’s time to move away from the shape of an execution plan and turn our attention to some of the... 19 August 2014 11 min read
Robert Sheldon Questions about T-SQL Expressions You Were Too Shy to Ask Nobody seems to ask questions about SQL Expressions in forums, even though expressions can cause all sorts of problems. Even... 13 August 2014 43 min read
Joshua Feierman The Mindset of the Enterprise DBA: 8 Ways To Centralize Your Work Although it is possible to provide good service to small to medium companies as a DBA without putting in place... 12 August 2014 10 min read
Phil Factor Quickly Investigating What’s in the Tables of SQL Server Databases From SQL Server Management Studio it is difficult to look through the first few rows of a whole lot of... 12 August 2014 27 min read
Matthew Skelton Common database deployment blockers and Continuous Delivery headaches Deployability is now a first class concern for databases, so why isn't it as easy as it should be? Matthew... 06 August 2014 17 min read
Joe Celko The SQL of Membership: Equivalence Classes & Cliques It is awkward to do 'Graph databases' in SQL to explore the sort of relationships and memberships in social networks... 28 July 2014 11 min read
Randolf Geist Parallel Execution Skew – Skew Caused By Outer Joins In the final part of this series I want to cover one last source of Parallel Execution Skew: Skew caused... 23 July 2014 6 min read
