Next-Gen Profiling

Dear .NET community, I’d like to introduce you to the newest version of ANTS Performance Profiler: 7.3. With a version...

13 July 2012 2 min read

Jonathan Kehayias

Optimizing tempdb configuration with SQL Server 2012 Extended Events

One of the most obvious bottlenecks in the performance of tempdb is caused by PAGELATCH, in-memory latch contention on the...

13 July 2012 20 min read

Michael Williamson

Code reviews at Red Gate

A couple of other Red Gate developers, namely Mat Burton and David Conlin, and I were tasked by Jeff Foster,...

12 July 2012 4 min read

Red Gate Software BI Tools Team

Testing SSAS Compare

By Jonathan Watts I try to pretend I am not a geek, but with fifteen cameras (film and digital), three...

11 July 2012 5 min read

Buck Woody

Distributed Computing – Hybrid Systems Considerations

When the Cloud was new, it was often presented as an 'all or nothing' solution. Nowadays, the canny Systems Architect...

11 July 2012 16 min read

Nick Harrison

jQuery Fast Food Cook Book

Anyone in IT should be aware of jQuery. This free, open-source JavaScript library has become amost essential to anyone creating...

11 July 2012 17 min read

Chris Farrell

.NET Memory Management Basics

.NET memory management is designed so that the programmer is freed from the chore of consciously having to allocate and...

11 July 2012 19 min read

Doug Burns

Falling in Love All Over Again: OEM 12c Performance Page Enhancements

Oracle Enterprise Manager 12c introduces the latest evolutionary stage of the Performance Pages demonstrated in the previous webinar. This session...

10 July 2012 1 min read

Seth Delconte

NULL-Friendly: Using Sparse Columns and Column Sets in SQL Server

Sparse columns and column sets in SQL Server 2012 provide a way of accomodating the less-structured data that has always...

10 July 2012 14 min read

Jonathan Allen

It’s time that you ought to know what you don’t know

There is a famous quote about unknown unknowns and known knowns and so on but I’ll let you review that...

09 July 2012 3 min read

Tony Davis

When done is not done

Most developers and DBAs will know what it’s like to be asked to do “a quick tidy up” on a...

05 July 2012 3 min read

Randolf Geist

Dynamic Sampling (III) – Real-Life Data – Part II

In the previous installment of this series we saw that Dynamic Sampling wasn’t of great help when dealing with certain...

05 July 2012 11 min read

Warwick Rudd

Encrypting Your SQL Server 2012 AlwaysOn Availability Databases

It is likely that you'll want to add a database with TDS Encryption to your AlwaysOn Availability Group. If you...

04 July 2012 8 min read

Jonathan Allen

A quick look at: dm_db_index_physical_stats

A quick look at the key data from this dmv that can help a DBA keep databases performing well and...

03 July 2012 11 min read

Phil Factor

At times, you need to hire a professional.

After months of increasingly demanding toil, the development team I belonged to was told that the project was to be...

03 July 2012 6 min read

Robert Sheldon

Working with SSIS Data Types

In order to be able to take data from a variety of sources, manipulate it, and then export it to...

02 July 2012 14 min read

Louis Davidson

Utility Queries–Database Files, (and Filegroups)

It has been a while since I last posted a utility query, and today, to avoid other work I am...

01 July 2012 8 min read

Alex Davies

You can step over await

I’ve just found the coolest feature of VS 2012 by far. I thought that being able to silence an exception...

01 July 2012 2 min read

Phil Factor

Handling Constraint Violations and Errors in SQL Server

The database developer can, of course, throw all errors back to the application developer to deal with, but this is...

29 June 2012 27 min read

Richard Morris

James Hong: Big in the IT Business

James Hong was one of a generation of entrepreneurs who fell into the role almost accidentally by creating an application...

28 June 2012 11 min read

Register for Simple Talk

Articles