Tag Archives: red-gate

Filtering sp_who

Posted on August 27, 2019 by thomasrushton

sp_who – useful – up to a point. Particularly when the server is busy, and you’re looking for something specific (eg to see if certain processes are out of a database before running an update) If the server is busy … Continue reading →

Posted in Uncategorized | Tagged , , , , | 2 Comments

T-SQL Tuesday – Bad Habits – Fixed by SQLPrompt

Posted on February 13, 2018 by thomasrushton

T-SQL Tuesday again. And it’s been a few months since I last blogged, let alone for this blog-party, but, hey, I’m here now. This time, Aaron Bertrand (blog|@aaronbertrand) has given two options – and, given the amount time I’ve been … Continue reading →

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

Redgate SQLPrompt Execution Warnings

Posted on May 14, 2016 by thomasrushton

What? Have you never run a DELETE or an UPDATE without a WHERE clause by accident? Was it on Production data, on the busiest day of the year? Actually, y’know what, that doesn’t matter. Even it happened in the middle … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | 3 Comments

SQL Jobs – On a Calendar?

Posted on April 30, 2016 by thomasrushton

SQL Server backup jobs are IO-intensive, he says, stating the obvious. When you have a lot of servers which have been set up over the years, and you’re new to the environment, and want to see when storage is being … Continue reading →

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

Shock – Red-Gate SQLPrompt Slowed Me Down!

Posted on April 26, 2016 by thomasrushton

Red Gate’s SQL Prompt, touted as a productivity enhancer, actually slowed me down debugging a query. This doesn’t happen very often, so I thought I would share the story, such as it is… Once Upon A Time… I had created … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , | 9 Comments

Memory Pressure in SQL Server

Posted on March 27, 2016 by thomasrushton

Servers with memory pressure are a nuisance – be they badly specified or misconfigured. Either way, they’re not performing properly. But the question is how often and how long are they affected? How to Identify For Memory Pressure Query from … Continue reading →

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

Using Redgate SQL Monitor with Azure Virtual Machines

Posted on November 9, 2015 by thomasrushton

We have an environment built out of SQL Servers installed on Azure Virtual Machines. We want to use Redgate’s SQL Monitor to monitor this environment; however, as of version 4.x it wasn’t completely supported on the Azure platform. Mainly, I … Continue reading →

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

SQL Server Performance Monitor counters missing

Posted on October 17, 2015 by thomasrushton

Another day, another batch of servers to build and add to those being monitored in Redgate’s SQL Server monitor. Reminder – these servers are being built in a consistent process, using a brace of PowerShell / azure scripts and a … Continue reading →

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

Documentation with Red Gate’s SQL Doc

Posted on April 16, 2014 by thomasrushton

Ah, documentation – how do we hate thee? If you’re anything like me, you’re continually frustrated by the lack of adequate documentation about the databases you have to work with, but don’t have the time (or inclination) to write it … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , | Leave a comment

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