Shawn McGehee

SQL Backup 6: Wind of Change

One could be forgiven for thinking that there is little more you can do with any third-party Backup software than...

03 August 2009 15 min read

Jacob Sebastian

An Introduction to SQL Server FileStream

Filestream allows us to store and manage unstructured datain SQL Server more easily. Initially, the accounts of FILESTREAM assumed prodigious...

03 August 2009 19 min read

Bart Read

.NET Reflector Support: Does .NET Reflector support unmanaged code?

The answer to this is, unfortunately, no. .NET Reflector will work with any managed assemblies from .NET 1.0 onwards, and...

31 July 2009 1 min read

Robert Sheldon

Defragmenting Indexes in SQL Server 2005 and 2008

Rob Sheldon tackles the subject of Index Defragmentation in SQL Server 2005 and 2008, using the sys.dm_db_index_physical_stats system function. He...

31 July 2009 15 min read

Rodney Landrum

The DBA as Detective: Troubleshooting Locking and Blocking

In this article, taken from Chapter 5 of his great new book, SQL Server Tacklebox, Rodney describes in his own...

31 July 2009 24 min read

Bart Read

.NET Reflector Support: Is it possible to see XML documentation for members and types?

Yes, as long as you have the XML documentation file for the assembly. If the assembly is yours, you just...

30 July 2009 2 min read

Bart Read

.NET Reflector Support: How do I stop .NET Reflector from asking me to locate assemblies all the time?

Open up .NET Reflector and go to View > Options on the main menu. Now click on Browser in the...

30 July 2009 1 min read

Bart Read

.NET Reflector Support: Where’s the .NET 3.5 decompilation support?

.NET Reflector actually does support .NET 3.5 decompilation; it’s just not switched on by default. To enable this support use...

30 July 2009 1 min read

Michael Francis

Why Archive Email?

It is easy for IT People to forget the long time-span that some businesses have to work to. It is...

30 July 2009 3 min read

Brad McGehee

How to Become an Exceptional DBA, 2nd Edition

A 2nd edition of Brad McGehee's popular "career guide" for DBAs, designed to help new and prospective DBAs find their...

30 July 2009 2 min read

Ben Lye

Restricting Outlook Client Versions in Exchange 2007

There are good reasons for preventing old versions of Outlook from connecting to Exchange Server. You'll probably, at least, want...

29 July 2009 7 min read

Jaap Wesselius

Installing Hyper-V and Beyond

In his previous article "Hyper-V, an introduction" Jaap Wesselius explained about the Hypervisor, the parent partition, the child partition, and...

28 July 2009 15 min read

red@work

Check us out…

Many of us are cautious before applying for a job, especially in an office. When I was fresh out of...

27 July 2009 3 min read

Louis Davidson

Should I write about what I think people ought to hear about?

As I sat at home convalescing after a well twittered surgery, I have talked to several of my friends on...

27 July 2009 9 min read

Tony Davis

The Horse’s Mouth

It was one of those wonderful moments when a task that was, a moment ago, frustrating and nigh-impossible, suddenly became...

23 July 2009 3 min read

Joe Celko

Celko’s Summer SQL Stumpers: Prime Numbers

Joe Celko kicks off our series of Summer SQL Stumpers with a challenge to improve on his solution to calculating the...

23 July 2009 6 min read

Roger Hart

Continuous Integration with SQL Toolbelt

Sometimes, you wish you had a tool to run a software development process exactly the way you need it to...

23 July 2009 17 min read

Richard Morris

Richard Stallman: Geek of the Week

Many famous geeks work away at their programs without considering the wider implications of what they, and others, are doing....

20 July 2009 12 min read

red@work

CSR. Several days in the life of…

It’s not every day at work that you are serenaded by Santa Claus* playing a ukulele. It’s not every company...

17 July 2009 6 min read

Damon Armstrong

Beating up my Code with ANTS Performance Profiler

Ty Anderson assumed that his cryptographic library was perfect until he tried it out with ANTS Performance Profiler. Within twenty...

17 July 2009 16 min read

Register for Simple Talk

Articles

SQL Backup 6: Wind of Change

An Introduction to SQL Server FileStream

.NET Reflector Support: Does .NET Reflector support unmanaged code?

Defragmenting Indexes in SQL Server 2005 and 2008

The DBA as Detective: Troubleshooting Locking and Blocking

.NET Reflector Support: Is it possible to see XML documentation for members and types?

.NET Reflector Support: How do I stop .NET Reflector from asking me to locate assemblies all the time?

.NET Reflector Support: Where’s the .NET 3.5 decompilation support?

Why Archive Email?

How to Become an Exceptional DBA, 2nd Edition

Restricting Outlook Client Versions in Exchange 2007

Installing Hyper-V and Beyond

Check us out…

Should I write about what I think people ought to hear about?

The Horse’s Mouth

Celko’s Summer SQL Stumpers: Prime Numbers

Continuous Integration with SQL Toolbelt

Richard Stallman: Geek of the Week

CSR. Several days in the life of…

Beating up my Code with ANTS Performance Profiler