In talking to a customer recently, they were worried about the amount of data kept by SQL Monitor. That’s a fair concern as monitoring a large number of servers can result in lots of data.

As an aside, data management is one of the reasons that I’d always want… Read more

This picture is out of date. I’ll make sure we get a new one next week at SQL in the City Streamed that includes Kendra Little.

On Sept 5th, is SQL in the City Streamed. Register today and watch us talk about Azure, Machine Learning, full stack development, and… Read more

At Redgate, we release a lot of changes to our products. In fact, this is the “About Redgate” slide I’ve been using in talks related to the company.

If you look in the lower right, you’ll see product releases from last year (2017). We have 30-ish products, so that’s roughly… Read more

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

There have been lots of posts on the topic of generating random values, and some great articles. One of my favorites is Jeff Moden’s Generating Test Data: Part… Read more

As my kids get older and I spend less time with them, I look forward to visiting new countries. While I’ve been to Norway and Oslo before, I wasn’t able to make the SQL Saturday last year. I am lucky that they accepted my submission and I’m heading  SQL Saturday… Read more

I ran across a question recently from a user about why they had strange results from a windowing query. This is better explained with an example, so let’s look at one.

I have some data in a table. This is NFL data, and a sample of it looks like this: Read more

SQL Prompt is amazing and it’s my favorite tool. It’s actually what many people want first from Redgate because it makes coding much easier. One of the most used features is the reformat feature (CTRL+K,Y), since formatting really matters to developers.

One of the neat features of SQL Prompt is… Read more

It’s that time again, and this month we have a good topic from Wayne Sheffield. We’re asked about getting stuck, about being blocked, about encountering a brick wall.

I have to say that I don’t think I encounter these very often, usually because I try to be effective, even… Read more

As much as I liked the ability to quickly and easily build development and test databases with SQL Provision, I thought the dashboard of cloned databases was hideous. It left a lot to be desired, and frankly, the dark theme is annoying to me. Here’s my old dashboard.

I… Read more

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I wanted to grant a login the CONTROL permission on a database. This wasn’t a simple as I expected. I had a login (JoeDev) with no user mappings… Read more

I’ve been starting to use SQL Operations Studio (SOS) a bit more. This is a small, lightweight editor that is based on Visual Studio Code. It’s fairly limited, though it’s still in preview. You can download it and give it a try.

One of the things that I like is… Read more