Gert Poel Generating XML from SQL and PL/SQL – Part 2 In this second part I’ll show you how you can generate XML from table data in PL/SQL. … 29 November 2012 10 min read
Feodor Georgiev How come the Hourglass? Why database applications slow down It is frustrating when you hit 'submit' and you get the hourglass big-time. Is it the database to blame? It... 28 November 2012 12 min read
Annette Allen SSIS BASICS: Introducing the Foreach Loop Container The Control flow components of SSIS can cause a great deal of puzzlement to anyone learning SSIS, especially the Foreach... 27 November 2012 14 min read
Feodor Georgiev Handling Backups for Rapid Resilience The backup and restore system in SQL Server hasn't changed a great deal over the years despite a huge growth... 20 November 2012 10 min read
Robert Sheldon Report Building 3.0: Adding Maps to Your Reports With Report Builder and SSMS, there isn't much you can't do in the way of the common reports and visualisations.... 13 November 2012 17 min read
Feodor Georgiev How come the Hourglass? Why database applications slow down It is frustrating when you hit 'submit' and you get the hourglass big-time. Is it the database to blame? It... 10 November 2012 12 min read
Joe Sack Fixing Gatekeeper Row Cardinality Estimate Issues The Query Optimiser needs a good estimate of the number of rows likely to be returned by each physical operator... 01 November 2012 18 min read
William Brewer Database Deployment Cribsheet As part of our long-running Cribsheet series, we asked William to write a guide to deployment that described in general... 29 October 2012 14 min read
Patrick Barel Edition Based Redefinition – Part 1 One of the ‘killer’ features of the Oracle Database version 11g Release 2 is probably Edition Based Redefinition. This functionality... 25 October 2012 7 min read
Seth Delconte Manipulating XML Data in SQL Server When the average database developer is obliged to manipulate XML, either shredding it into relational format, or creating it from... 23 October 2012 14 min read
Dmitri Korotkevitch Partitioned Tables, Indexes and Execution Plans: a Cautionary Tale Table partitioning is a blessing in that it makes large tables that have varying access patterns more scalable and manageable,... 23 October 2012 20 min read
Annette Allen SSIS Basics: Using the Execute SQL Task to Generate Result Sets The Execute SQL Task of SSIS is extraordinarily useful, but it can cause a lot of difficulty for developers learning... 23 October 2012 14 min read
Jonathan Lewis Temporary Tables in Oracle and SQL Server This video is a follow up to the webinar broadcast by Red Gate on 13th September 2012. Please leave a... 15 October 2012 1 min read
Feodor Georgiev Designing Databases for Rapid Resilience As the volume of data increases, DBAs need to plan more actively for rapid restores in the event of failure.... 15 October 2012 12 min read
Robert Sheldon Report Builder 3.0: Adding Charts to Your Report Charts are one of the commonest ways of visualizing reports from data. Report Builder provides a way of generating charts... 11 October 2012 13 min read
Louis Davidson Tim Ford Tune Your Indexing Strategy with SQL Server DMVs SQL Server Indexes need to be effective. It is wrong to have too few or too many. The ones you... 11 October 2012 42 min read
Satishbabu Gunukula Convert Single Instance to RAC – Part 2: Manually Convert to RAC This article will focus on converting the single instance to RAC.… 10 October 2012 13 min read
Michael Sorens Database Source Control Basics: Getting Started It makes a lot of sense to do it, but how do you get started? Whatever you use to build... 09 October 2012 17 min read
Joe Sack Exploring Semantic Search Key Term Relevance SQL Server's 'Semantic Search' feature seemed an exciting feature when first shown. Was it really true that Microsoft had come... 09 October 2012 7 min read
Wissem El Khlifi Data Guard Physical Standby Database Best Practices – Part II In this second part we will setup the standby database and enable Fast Start Fail Over.… 27 September 2012 9 min read
