Moving Data From Excel to SQL Server – 10 Steps to Follow

SQL Server Integration Services provide a versatile way of reading Excel files into SQL Server. A task like this illustrates...

21 May 2013 15 min read

Grant Fritchey

The DBA Detective: The Case of the Missing Index

When problems arise in SQL Server, we're faced with a server full of suspects, including disk I/O, memory, CPU, incorrect...

15 May 2013 12 min read

Allen White

Backup and Restore SQL Server with the SQL Server 2012 PowerShell cmdlets

There are plenty of occasions when it makes a lot of sense to do backup and restore scripts in PowerShell....

03 May 2013 15 min read

Tools

Michael Sorens in Tools

MySQL Compare: The Manual That Time Forgot, Part 1

Although SQL Compare, for SQL Server, is one of Redgate's best-known products, there are also 'sister' tools that allow you...

03 May 2013 14 min read

Aman Sharma

RAC One Node

In the past few years, technology has become a very important aspect of our lives. There isn’t any moment when we are...

25 April 2013 20 min read

Holger Schmeling

Developing a Report Definition Customization Extension for Multi-Language Reports

When you need to present the same SQL Server Reporting Services (SSRS) report in eight or more different languages, or...

19 April 2013 31 min read

Seth Delconte

Introduction to SQL Server Filtered Indexes

SQL Server filtered indexes can save space and improve performance if they are used properly. Under what circumstances can they...

19 April 2013 13 min read

Randolf Geist

Analyzing and Troubleshooting Oracle Parallel Execution

Watch video The video above is accompanied by the following resources: Analysing and Troubleshooting Parallel Execution presentation slides (.pdf)...

17 April 2013 1 min read

Grant Fritchey

Custom Metrics for Monitoring Database Mirroring

SQL Monitor comes with plenty of metrics, but there are always going to be things that you want to measure...

16 April 2013 7 min read

Martin Giffy DSouza

Console Wrapper 1.0.4

Console Wrapper 1.0.4 is officially out. You can download it from the project page: https://code.google.com/p/js-console-wrapper/ The only change for this release...

11 April 2013 1 min read

Robert Sheldon

tSQLt Tutorial: Unit Testing SQL Server Databases with Test Cases and Fakes

A complete tSQLt tutorial for SQL Server unit testing: setting up the tSQLt framework, creating test classes and test cases,...

08 April 2013 23 min read

Patrick Barel

PL/SQL Subtypes

Technology is dominated by two types of people: those who understand what they do not manage, and those who manage...

03 April 2013 6 min read

Erin Stellato

Managing SQL Server Statistics

Accurate statistics about the data held in tables are used to provide the best execution strategy for SQL queries. but...

03 April 2013 31 min read

Hugh Bin-Haad

TSQL Pivot Rotations using only REPLACE

Pivoting SQL Server tables is always awkward, even with the PIVOT and UNPIVOT operators. If you want to get the...

01 April 2013 8 min read

Doug Burns

Oracle SQL Monitoring – Performance Analysis

This video is a follow up to the webinar broadcast by Red Gate on 27th February 2012. Please leave a...

27 March 2013 1 min read

Nick Celis

A valuable component in your APEX ECO-System

When working with APEX, you also need a number of tools to improve the efficiency of your work. It isn’t...

26 March 2013 2 min read

Kat Hicks

Diagnosing Common Database Ails

When a database starts showing signs of an illness, it's up to the DBA to get to the root of...

25 March 2013 13 min read

Kathi Kellenberger

Solving Complex T-SQL Problems, Step-By-Step

What should you do if your first, most intuitive solution to a problem ends up scanning the data more than...

18 March 2013 19 min read

Tony Davis

Shawn McGehee

Managing the SQL Server Transaction Log: Dealing with Explosive Log Growth

You've just become responsible for a database, only to find that the log file is growing out of control. Why...

14 March 2013 13 min read

Dominic Delmolino

Bridging the Developer/DBA Divide: Advances in Database Source Control

For over 10 years now, I’ve been a huge advocate of integrating database development, design and architecture practices into application...

13 March 2013 7 min read