Subterranean IL: The ThreadLocal type

I came across ThreadLocal<T> while I was researching ConcurrentBag. To look at it, it doesn’t really make much sense. What’s...

03 May 2012 5 min read

Jean-Philippe Gouigoux

.NET Memory Management and Finalization

In this excerpt from his new book, Practical Performance Profiling: Improving the Efficiency of .NET Code, Jean-Phillipe Gouigoux discusses the...

02 May 2012 12 min read

Louis Davidson

Crazy Week Next Week–SQLRally and SQL Saturday Birmingham

A lot of my time lately has been spent getting ready for next week and I hope to see you...

01 May 2012 2 min read

Jonathan Lewis

Oracle Heap Tables or SQL Server Clustered Indexes? Jonathan Lewis and Grant Fritchey Live Debate

The following video and set of resources are from the webinar broadcast by Red Gate on 7 June 2012. Oracle...

30 April 2012 1 min read

Matt Wrock

Towards the Perfect Build

An automated build and deployment system is no longer a dream. Now that PowerShell has matured as a product, and...

30 April 2012 28 min read

Tony Davis

IT Admin for Thrill Seekers

A developer suggested to me recently that the life of the DBA was, surely, a dull one. My first reaction...

27 April 2012 3 min read

David Atkinson

How the "migrations" approach makes database continuous integration possible

Testing a database upgrade script as part of a continuous integration process will only work if there is an easy...

26 April 2012 3 min read

Karen Morton

How to Gather SQL Resource Consumption Metrics in Oracle

The following video and set of resources are from the webinar broadcast by Red Gate on 8 May 2012. The...

26 April 2012 2 min read

Louis Davidson

What Counts For A DBA – Foresight

Of all the valuable attributes of a DBA covered so far in this series, ranging from passion to humility to...

26 April 2012 4 min read

Greg Larsen

SQL Server Transaction Log Fragmentation: a Primer

Generally, you will have no need to worry about the number of virtual log files in your transaction log. However,...

26 April 2012 17 min read

Robert Sheldon

Implementing Lookup Logic in SQL Server Integration Services

With SSIS, you can perform a lookup on data in the course of a task, using referenced data from any...

26 April 2012 14 min read

Bud Aaron

How to set up a database-driven Azure site

So how easy is it to set up a database-driven application on Azure, using the tools that one is familar...

26 April 2012 12 min read

David Atkinson

Ever wondered what the Object Explorer Details window is for?

Typically, when I install SQL Server Management Studio and run it for the first time, the first thing I do...

24 April 2012 2 min read

Damon Armstrong

Hierarchical Queries with Common Table Expressions

I wanted a simple example of a hierarchical query using a common table expression in SQL Server. MSDN had an...

24 April 2012 2 min read

Richard Morris

Peldi Guilizzoni: Geek of the Week

Peldi is one of the most likeable of the new hybrid IT generation; part entrepreneur, part geek. Balsamiq is Peldi's...

24 April 2012 15 min read

Dino Esposito

ASP.NET MVC: Resolve or Inject? That's the Issue…

Classes should have dependencies only on abstract, rather then concrete, classes. To get around this, you can choose between Service...

23 April 2012 11 min read

Michael Sorens

Practical PowerShell: Pruning File Trees and Extending Cmdlets

One of the most radical features of PowerShell is amongst the least known. It is possible to extend the buit-in...

23 April 2012 21 min read

Louis Davidson

Utility Queries–Column Metadata

Very often, I find myself wanting to query system metadata for columns. Some of the metadata is fairly easy to...

22 April 2012 22 min read

David Atkinson

Using a SQL Prompt snippet with template parameters

As part of my product management role I regularly attend trade shows and man the Red Gate booth in the...

20 April 2012 3 min read

Cary Millsap

Real Developers DO use Tools

This video is a recording from the webinar broadcast by Red Gate on 24th January 2012. You may’ve heard the...

19 April 2012 1 min read

Register for Simple Talk

Articles

Subterranean IL: The ThreadLocal type

.NET Memory Management and Finalization

Crazy Week Next Week–SQLRally and SQL Saturday Birmingham

Oracle Heap Tables or SQL Server Clustered Indexes? Jonathan Lewis and Grant Fritchey Live Debate

Towards the Perfect Build

IT Admin for Thrill Seekers

How the "migrations" approach makes database continuous integration possible

How to Gather SQL Resource Consumption Metrics in Oracle

What Counts For A DBA – Foresight

SQL Server Transaction Log Fragmentation: a Primer

Implementing Lookup Logic in SQL Server Integration Services

How to set up a database-driven Azure site

Ever wondered what the Object Explorer Details window is for?

Hierarchical Queries with Common Table Expressions

Peldi Guilizzoni: Geek of the Week

ASP.NET MVC: Resolve or Inject? That's the Issue…

Practical PowerShell: Pruning File Trees and Extending Cmdlets

Utility Queries–Column Metadata

Using a SQL Prompt snippet with template parameters

Real Developers DO use Tools