Tag Archives: Programming

45 Database Performance Tips for Developers

Just a quick post to point out that Red Gate has just put out an e-book of 45 Database Performance Tips for Developers. It’s free. And to sweeten the deal, they’re bundling it with a 14 day free trial licence … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , , , | 1 Comment

SQL Saturday 194 Exeter Pre-Con – PowerShell 3.0 for SQL Server Administrators and Developers

OK, Yes, it’s (yet) another post pimping a SQL Saturday 194 Exeter Pre-Con session. This time, André Kamman (blog|twitter)and his day of PowerShell. I’ve seen André perform at a SQLBits conference, where he gave a session “RoboDBA” about PowerShell, and … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , | Leave a comment

Disaster Prevention by Triggers

In my previous post, I discussed recovery from a situation where a user had updated every row of a table rather than the one that he was aiming at. At the end of that post, I suggested that a way … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , | Leave a comment

T-SQL Tuesday #024 – Prox & Funx – Maintenance / Release Tip

T-SQL Tuesday is a monthly SQL Server blogging event.  One of us sets a topic for the month’s event, and we all have a week in which to write a blog post that fits that topic.  This month’s event is … Continue reading

Posted in SQLServerPedia Syndication, T-SQL Tuesday | Tagged , , , | Leave a comment

T-SQL Tuesday #024 – Prox ‘n’ Funx (Procedures & Functions)

T-SQL Tuesday is a monthly SQL Server blogging event.  One of us sets a topic for the month’s event, and we all have a week in which to write a blog post that fits that topic.  This month’s event is … Continue reading

Posted in SQLServerPedia Syndication, T-SQL Tuesday | Tagged | Leave a comment

T-SQL Tuesday #23 – Non-ANSI JOINs Discontinued in Denali

T-SQL Tuesday is a monthly SQL Server blogging event.  One of us sets a topic for the month’s event, and we all have a week in which to write a blog post that fits that topic.  This month’s event is … Continue reading

Posted in SQLServerPedia Syndication, T-SQL Tuesday | Tagged , , , | 1 Comment

Meme Monday – August 2011 – “Crappy Code”

This month’s Meme Monday, as run by Thomas “SQL Rockstar” LaRock (blog|twitter) is an exercise in writing about the worst pieces of code we have seen. Once upon a time… …I noticed that, what should have been a relatively simple … Continue reading

Posted in Meme Monday, SQLServerPedia Syndication | Tagged , | Leave a comment