The .NET Team

Simple Talk Labs – Let the Science Begin

In which I introduce a new project, explain the why and wherefore, and ask for a little help. Some Context...

10 August 2012 4 min read

Red Gate Software BI Tools Team

Business Intelligence Adoption Survey Results

A month ago Nick published a blog post about the path to adopting common business intelligence practices. At the same...

09 August 2012 4 min read

Michael Sorens

Practical PowerShell for SQL Server Developers and DBAs – Part 2

Having shown just how useful PowerShell can be for DBAs in executing queries, Michael Sorens now takes us through navigating...

09 August 2012 24 min read

Jonathan Allen

A quick look at: dm_db_index_usage_stats

I recently wrote a post with a similar title, reviewing the dm_db_index_physical_stats so it seemed logical to pick a closely...

08 August 2012 5 min read

Annette Allen

SSIS Basics: Introducing Variables

In the third of her SSIS Basics articles, Annette Allen shows you how to use Variables in your SSIS Packages,...

08 August 2012 20 min read

Wissem El Khlifi

Data Guard Physical Standby Database Best Practices – Part 1

Oracle Data Guard is one of the software solutions provided by Oracle Corporation to maximize high availability of Oracle databases....

07 August 2012 8 min read

Louis Davidson

What Counts For a DBA: Tenacity

By ‘tenacity’, I mean working passionately at some task until you complete it, it kills you, or what you were...

07 August 2012 3 min read

Phil Factor

The SQL Looks good but does it parse?

In honour of Dave Ballantyne’s excellent article ‘Cleaning Up SQL Server Deployment Scripts‘, here is a PowerShell routine that checks...

06 August 2012 3 min read

Jonathan Allen

Keeping the Scary DBA from your door.

Have you seen the video from Grant Fritchey regarding database backups for the impatient people that are as yet to...

03 August 2012 5 min read

Red and the Community

SQL in the City – a Newbie's Experience

Having joined Annabel and Hannah on the Communities team 4 months ago, it has been a busy and exciting time....

03 August 2012 3 min read

Laila Lotfi

Automated error reporting: the beginning of a beautiful relationship?

Whether recognized or not, customer relations is embedded in the fabric of every software development and IT organization. Automated error...

03 August 2012 6 min read

Simon Cooper

Inside the DLR – Callsite binders

So, we’ve looked at how the C# compiler produces a CallSite object for every dynamic call that is made, and...

03 August 2012 4 min read

Opinion Pieces

Buck Woody in Opinion Pieces

Learn Where You Are

In order to make progress in your career in IT, you need to actively plan your professional development rather then...

03 August 2012 10 min read

Tony Davis

Automating Sanity Checks for Database Deployments

Although development teams are inching closer toward their ideal of a fully automated build and deployment strategy for their applications,...

02 August 2012 3 min read

Randolf Geist

Oracle Cost-Based Optimizer Advanced

This video and set of resources is a follow up to the webinar broadcast by Red Gate on 01 August...

02 August 2012 2 min read

Dave Ballantyne

Cleaning Up SQL Server Deployment Scripts

Although, generally speaking, source control is the truth, a database doesn't quite conform to the ideal because the target schema...

02 August 2012 22 min read

Randolf Geist

Incremental Partition Statistics Review

Here is a summary of the findings while evaluating Incremental Partition Statistics that have been introduced in Oracle 11g. The...

01 August 2012 2 min read

Doug Burns

Statistics on Partitioned Tables

When Jonathan Lewis decided it was time to post a list of the Partition Stats posts on his blog and...

01 August 2012 1 min read

Michael Williamson

Simple Talk development: sites and modules

In the last post, I described Simple-Talk’s original architecture: four .NET applications sharing the same database with very little separation...

01 August 2012 5 min read