The Seven Sins against TSQL Performance

There are seven common antipatterns in TSQL coding that make code perform badly, and three good habits which will generally...

31 July 2012 15 min read

Alex Davies

Web developers rejoice – .NET Demon can reload your browser

I had a bit of spare time last week, so .NET Demon has a new feature for web developers. It’s...

30 July 2012 2 min read

Damon Armstrong

Setting Boolean Values in a SharePoint SPItemEventReceiver

One of the confusing things about implementing an SPItemEventReceiver that modifies properties on an SPListItem is that while you are...

27 July 2012 2 min read

Red Gate Software BI Tools Team

Self-service BI and SSAS Tabular

By Nick Sutherland Most of the BI professionals I’ve spoken to use enterprise BI – that is, they create analysis...

26 July 2012 3 min read

Richard Morris

Geek of the Week: Niklaus Wirth

When looking for a suitable Geek of the Week, we wondered whether a suitable candidate might be the man who...

26 July 2012 9 min read

Richard Morris

Database Continuous Integration with Bamboo

We were so interested in Atlassian's Bamboo, and it's role in Continuous Integration, that we wanted to find out more,...

26 July 2012 15 min read

Jonathan Allen

SQL In the City – What an event!

A guest blog from @Mrs_Fatherjack Well to repeat Mr Fritchey – WOW, what an event. They went. . . They...

25 July 2012 3 min read

Richard Morris

Ron Gruner: Geek of the Week

Ron Gruner helped to crate some of the best of Data General's Minicomputers, and then co-founded Alliant, producer of the...

25 July 2012 12 min read

Simon Cooper

Inside the DLR – Callsites

The DLR was introduced in .NET 4 to allow dynamic languages, like Python or Ruby, to run on the CLR....

23 July 2012 4 min read

Dino Esposito

Simulating Web API – JSON Formatters in ASP.NET MVC

The Web API framework is a useful tool for building RESTful ASP.NET MVC4 applications, but it's not essential. Dino Esposito...

23 July 2012 10 min read

Michael Sorens

Practical PowerShell for SQL Server Developers and DBAs – Part 1

There is a lot of confusion amongst DBAs about using PowerShell due to existence the deprecated SQLPS mini-shell of SSMS...

23 July 2012 16 min read

Louis Davidson

What Counts for a DBA: Time

As far as I know, nobody’s last words, when their time was up, were “I wish I had worked more.”...

20 July 2012 3 min read

Phil Factor

PowerShell SMO: Just Writing Things Once

Sometimes, you can tire of writing the same PowerShell code once again. After this happened to Phil whilst keying in...

19 July 2012 26 min read

Patrick Barel

ANSI SQL

if you can’t beat them, join them. Gregory Y. Titelman Since Oracle 9i, Oracle SQL supports the ANSI SQL...

18 July 2012 6 min read

Jonathan Lewis

ANSI Outer 2

A comment on a recent post of mine pointed me to a question on the OTN SQL and PL/SQL Forum where someone...

17 July 2012 1 min read

Jonathan Allen

SQL in the City 2012 – London

Redgate software first ran their SQL in the City event in 2011 in London and I was highly honoured to...

17 July 2012 7 min read

Richard Morris

Kohsuke Kawaguchi: Geek of the Week

Jenkins, formerly called Hudson, is an open-source server-based Continuous Integration tool that works with all the major Source Control Management...

17 July 2012 11 min read

Dominic Delmolino

Hate the player, not the game — or my case for Data Engineers

Has “database” become a dirty word within your organization lately? If you’re someone who has been a data technologist for...

16 July 2012 4 min read

Chris George

Antenna Aligner Part 9: Progress and Updates

It’s been a while since my last post, and things are going well. I’ve currently got over 260 users, and...

16 July 2012 3 min read

Jonathan Allen

SQL Server Query Time Out when referencing data on a Linked Server

I recently had an issue where an overnight job that had a history of working successfully on a reliable basis...

16 July 2012 6 min read

Register for Simple Talk

Articles

The Seven Sins against TSQL Performance

Web developers rejoice – .NET Demon can reload your browser

Setting Boolean Values in a SharePoint SPItemEventReceiver

Self-service BI and SSAS Tabular

Geek of the Week: Niklaus Wirth

Database Continuous Integration with Bamboo

SQL In the City – What an event!

Ron Gruner: Geek of the Week

Inside the DLR – Callsites

Simulating Web API – JSON Formatters in ASP.NET MVC

Practical PowerShell for SQL Server Developers and DBAs – Part 1

What Counts for a DBA: Time

PowerShell SMO: Just Writing Things Once

ANSI SQL

ANSI Outer 2

SQL in the City 2012 – London

Kohsuke Kawaguchi: Geek of the Week

Hate the player, not the game — or my case for Data Engineers

Antenna Aligner Part 9: Progress and Updates

SQL Server Query Time Out when referencing data on a Linked Server