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
Seth Delconte Getting Started With XML Indexes XML Indexes make a huge difference to the speed of XML queries, as Seth Delconte explains; and demonstrates by running... 25 September 2012 17 min read
Satishbabu Gunukula Convert Single Instance to RAC – Part 1: Duplicate DB using RMAN This article is for users of Oracle Database version 10g+ who want to convert their Oracle single instance database to... 20 September 2012 11 min read
Steve Harville Migrating a 2TB database to a new operating system with different endianness I recently moved a 2TB database from Linux, Oracle 11.1 to AIX, Oracle 11.2 using impdp with network_link and parallel... 19 September 2012 1 min read
Glenn Berry Provisioning a New SQL Server Instance – Part Three Once you've installed and configured SQL Server 2012, there are some tasks that should be done to ensure that maintenance,... 18 September 2012 12 min read
Laerte Junior The PoSh DBA: Solutions using PowerShell and SQL Server PowerShell is worth using when it is the quickest way to providing a solution. For the DBA, it is much... 18 September 2012 15 min read
Joe Celko Matrix Math in SQL Relational Databases have tables as data structures, not arrays. This makes it tricky and slow to do matrix operations, but... 17 September 2012 10 min read
Robert Sheldon Report Builder 3.0: Formatting the Elements in your Report There is a lot that can be done to make basic tabular reports more readable, using Microsoft's free Report Builder.... 12 September 2012 16 min read
Martin Giffy DSouza PL/SQL Exceptions Propagation during Variable Declaration It’s always good to know how any language handles and propagates exceptions, Oracle PL/SQL being no different. They’re plenty of... 11 September 2012 1 min read
Grant Fritchey Why is that SQL Server Instance under stress? There are several reliable indications, using SQL Queries, of the what is causing SQL Server performance problems. Some of these... 11 September 2012 14 min read
Dave Green Ten Things I Wish I’d Known When I Started Using tSQLt and SQL Test The open-source Unit Test framework tSQLt is a great way of writing unit tests in the same language as the... 11 September 2012 12 min read
Gert Poel Generating XML from SQL and PL/SQL – Part 1: Introduction From time to time you’ll have to represent your data stored in a database in an XML format, eg. to... 05 September 2012 5 min read
Patrick Barel Checking for NULL with Oracle SQL The art of doing mathematics consists in finding that special case which contains all the germs of generality. David Hilbert... 30 August 2012 7 min read
Phil Factor Registered Servers and Central Management Server Stores SQL Server Management Studio (SSMS) has many features that make it particularly convenient for the database developer and DBA. Registered... 28 August 2012 14 min read
Robert Sheldon Report Builder 3.0: Creating a Basic Report Report Builder is underrated as a BI and report-authoring tool. It is a free stand-alone application from Microsoft that provides... 24 August 2012 18 min read
