Emoti-phrases

Surely the next radical step in the development of User-interface design is for applications to react appropriately to the rising...

09 December 2010 3 min read

Troy Hunt

Foolproof Atomic Versioning of Applications

Bad things tend to happen to developments where the scripts for the database layer are left out of source control....

08 December 2010 9 min read

Glenn Berry

SQL Server Hardware

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal...

08 December 2010 3 min read

Louis Davidson

Design Book– Third Section (Implementing the Database)

The third section is the primary section that a person who has some decent knowledge and experience doing design will...

07 December 2010 5 min read

Alex Kuznetsov

Tuning SQL Queries with the Help of Constraints

The use of constraints is a valuable way of improving query performance as well as maintaining the integrity of the...

07 December 2010 7 min read

Brad McGehee

Brad’s Sure Guide to SQL Storage Compress

SQL Storage Compress does just that, and encrypts as well, allowing the files associated with a live database to take...

07 December 2010 27 min read

Zenon Ochal

Dynamic Language Integration in a C# World

.NET 4.0 introduced the Dynamic keyword in C#4.0, making it simple to have your .NET code smoothly interact with dynamic...

04 December 2010 14 min read

Michael Sorens

LINQ Secrets Revealed: Chaining and Debugging

LINQ has the capabilities of providing a great productivity boost. LINQ Chaining is particularly powerful magic, giving your code greater...

01 December 2010 30 min read

Louis Davidson

Design Book–Dimensional or No Dimensional, that is..the question

So, it is right there in the title of the book “Relational Database Design” etc (the title is kinda long...

30 November 2010 2 min read

Simon Cooper

Subterranean IL: Pseudo custom attributes

Custom attributes were designed to make the .NET framework extensible; if a .NET language needs to store additional metadata on...

30 November 2010 4 min read

Louis Davidson

Design Book – Second Section (Logical/Conceptual Modeling/Case Studies)

In the first section of the book, we established the skills that are required to do data modeling/design (well, at...

28 November 2010 3 min read

Simon Cooper

Subterranean IL: Custom modifiers

In IL, volatile is an instruction prefix used to set a memory barrier at that instruction. However, in C#, volatile...

26 November 2010 3 min read

Michael Francis

SQL Source Control – Less Pain for Red Jungle

As a dedicated 'twitcher', Michael's eye is caught by a 'tweet' from Red Jungle. In this case, it was not...

26 November 2010 5 min read

Richard Morris

Jorge Segarra: DBA of the Day

Jorge Segarra, also known on Twitter as 'SQLChicken', was one of the finalists of the Exceptional DBA award this year....

26 November 2010 13 min read

Benjamin Nevarez

Index Selection and the Query Optimizer

While we all know that the Query Optimizer uses Indexes to produce better execution plans, we don't all know exactly...

25 November 2010 23 min read

Robert Sheldon

The DELETE statement in SQL Server

Of the big four DML statements in SQL Server, the DELETE is the one least written about. This is odd...

25 November 2010 11 min read

Laerte Junior

Fun with SQL Server Profiler trace files and PowerShell

Running Profiler traces against multiple servers becomes a painful process when it's time to collate and filter all that data....

25 November 2010 13 min read

Nick Harrison

Some NHibernate Best-Practices

NHibernate can help to build a project more quickly if the database it connects to is sound. Otherwise, there are...

25 November 2010 13 min read

Edward Elliott

How The Garbage Collector Can Cause Random Slowness

If your website is suffering from slow performance, it's easy to blame the code, but not always correct. Even in...

25 November 2010 15 min read

Patrick Index

Executing SSIS Packages continued

When Nigel Rivett wrote his article about Executing SSIS packages for Simple-Talk, four years ago, it proved very popular and...

25 November 2010 5 min read

Register for Simple Talk

Articles

Emoti-phrases

Foolproof Atomic Versioning of Applications

SQL Server Hardware

Design Book– Third Section (Implementing the Database)

Tuning SQL Queries with the Help of Constraints

Brad’s Sure Guide to SQL Storage Compress

Dynamic Language Integration in a C# World

LINQ Secrets Revealed: Chaining and Debugging

Design Book–Dimensional or No Dimensional, that is..the question

Subterranean IL: Pseudo custom attributes

Design Book – Second Section (Logical/Conceptual Modeling/Case Studies)

Subterranean IL: Custom modifiers

SQL Source Control – Less Pain for Red Jungle

Jorge Segarra: DBA of the Day

Index Selection and the Query Optimizer

The DELETE statement in SQL Server

Fun with SQL Server Profiler trace files and PowerShell

Some NHibernate Best-Practices

How The Garbage Collector Can Cause Random Slowness

Executing SSIS Packages continued