Tag Archives: Programming

CmdExec vs Powershell – error? What error?

Posted on October 20, 2020 by thomasrushton

Just a quickie Batch file scripts, called by SQL Agent, are not propagating their errors back up to the SQL Server job system because…. they’re being called from a Powershell script? To replicate the problem, create a .bat file containing … Continue reading →

Posted in Uncategorized | Tagged , , , | Leave a comment

A Problem with Boolean Logic

Posted on March 4, 2018 by thomasrushton

Your requirement: to find the things where either A or B is true and C is true. Your first draft might be this: (field, table, function, logic all anonymised to protect the perpetrator) What’s the problem? Operator Precedence, that’s the … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , | 2 Comments

45 Database Performance Tips for Developers

Posted on November 13, 2013 by thomasrushton

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

Posted on February 21, 2013 by thomasrushton

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

Posted on November 6, 2012 by thomasrushton

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

Posted on November 8, 2011 by thomasrushton

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)

Posted on November 8, 2011 by thomasrushton

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

Posted on October 4, 2011 by thomasrushton

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”

Posted on August 1, 2011 by thomasrushton

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

T-SQL Tuesday #20 – T-SQL Best Practices

Posted on July 12, 2011 by thomasrushton

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