Tag Archives: red-gate

Redgate SQLPrompt Execution Warnings

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 , , | 2 Comments

SQL Jobs – On a Calendar?

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 , , , , , , , | 18 Comments

Shock – Red-Gate SQLPrompt Slowed Me Down!

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

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

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

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

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