Ben Emmett

Doh! This is why we run beta programs

I’m a big believer in sharing beta software with users as early as possible. For our users it means getting...

06 February 2013 3 min read

Tony Davis

Making PASS tick…

On the final day of a hectic PASS Summit 2012, in Seattle, I caught up with Bill Graziano (@billgraziano), Douglas...

05 February 2013 1 min read

Feodor Georgiev

SQL Monitor – Using the performance data smartly

How does a Database Consultant use a tool such as SQL Monitor? The seasoned expert doesn't just dive into DMVs...

05 February 2013 8 min read

Phil Factor

Database Deployment: The Bits – Versioning

Although databases have no inherent way of recording their version numbers, SQL Server provides the means of doing so, and...

04 February 2013 11 min read

Robert Sheldon

Getting Started with Extended Events in SQL Server 2012

Extended Events provide a way of unintrusively monitoring what's going on in a SQL Server instance. Unlike SQL Server Profiler...

04 February 2013 16 min read

Ben Emmett

Web Request Profiling in ANTS Performance Profiler

We’ve just shipped another beta build of ANTS Performance Profiler 8, and it’s a big one. It adds new feature...

01 February 2013 2 min read

Jonathan Lewis

Compression in Oracle – Part 3: OLTP Compression

In part two of this series we examined the effect of updates on compressed data when using basic compression, and...

31 January 2013 14 min read

Fabiano Amorim

Using Optimizer_WhatIF and StatsStream to Simulate a Production Environment

SQL Server's Query optimiser judges the best query plan from the data in the relevant tables and the server's hardware....

30 January 2013 9 min read

Andrew Clarke

On taking a more nuanced approach to Cloud services.

Although it makes a lot of sense for an IT department to use the Cloud where possible instead of using...

28 January 2013 2 min read

Neil Anderson

Jonathan Lewis helps to optimize Red Gate’s Oracle tools

Speed, performance, optimization: time is of the essence when you’re waiting for an operation to complete. Our Oracle tools — Schema...

28 January 2013 7 min read

Annette Allen

SSIS Basics: Using the Conditional Split

The Conditional Split can route data rows to different outputs depending on whatever criteria of the data that you wish....

28 January 2013 12 min read

Michaela Murray

Free eBook: 50 Ways to Avoid, Find and Fix ASP.NET Performance Issues

Back in November, I started asking for your top tips on ASP.NET and SQL Server performance. In case you haven’t...

25 January 2013 3 min read

Seth Delconte

Precision Indexing: Basics of Selective XML Indexes in SQL Server 2012

Seldom has a SQL Server Service pack had such an effect on database development as when SQL Server 2012 SP1...

25 January 2013 14 min read

Ben Emmett

Announcing the Beta of ANTS Performance Profiler 8

We spend a lot of time talking to .NET developers, and over the last couple of months it’s been really...

24 January 2013 1 min read

Jonathan Lewis

Compression in Oracle – Part 2: Read-Only Data

In part one of this series we saw that the mechanics of basic table compression came in to play only...

24 January 2013 13 min read

Louis Davidson

One more reason to to understand query plans, not directly performance related

One of the things that separates a good programmer from a great one is a firm understanding about what is...

22 January 2013 11 min read

Kat Hicks

Interviewing Tips for a Database Position

Interviewing for a database position is a careful game of give and take. Knowing what to expect and how to...

22 January 2013 15 min read

Randolf Geist

HAVING Cardinality

When performing aggregate GROUP BY operations an additional filter on the aggregates can be applied using the HAVING clause. Usually aggregates are one of...

21 January 2013 2 min read

Warwick Rudd

Expanding AlwaysOn Availability Groups with Replication Subscribers

High Availability (HA) and Disaster Recovery (DR) can be provided for subscription databases from an AlwaysOn Avaliability Group, but the...

18 January 2013 8 min read

Tony Davis

Getting backs up about backups

I’ve been leafing with interest through the book, Pro Data Backup and Recovery, by Steve Nelson. For anyone predisposed to...

17 January 2013 3 min read

Register for Simple Talk

Articles

Doh! This is why we run beta programs

Making PASS tick…

SQL Monitor – Using the performance data smartly

Database Deployment: The Bits – Versioning

Getting Started with Extended Events in SQL Server 2012

Web Request Profiling in ANTS Performance Profiler

Compression in Oracle – Part 3: OLTP Compression

Using Optimizer_WhatIF and StatsStream to Simulate a Production Environment

On taking a more nuanced approach to Cloud services.

Jonathan Lewis helps to optimize Red Gate’s Oracle tools

SSIS Basics: Using the Conditional Split

Free eBook: 50 Ways to Avoid, Find and Fix ASP.NET Performance Issues

Precision Indexing: Basics of Selective XML Indexes in SQL Server 2012

Announcing the Beta of ANTS Performance Profiler 8

Compression in Oracle – Part 2: Read-Only Data

One more reason to to understand query plans, not directly performance related

Interviewing Tips for a Database Position

HAVING Cardinality

Expanding AlwaysOn Availability Groups with Replication Subscribers

Getting backs up about backups