The Voice of the DBA
Archives: August 2018
Custom Data Purging in SQL Monitor
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
0 comments, 363 reads
Posted in The Voice of the DBA on 30 August 2018
Next week is SQL in the City Streamed
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
0 comments, 336 reads
Posted in The Voice of the DBA on 29 August 2018
Redgate Lives DevOps
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
0 comments, 1,085 reads
Posted in The Voice of the DBA on 28 August 2018
Generating a Constrained Random Date–#SQLNewBlogger
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
0 comments, 1,191 reads
Posted in The Voice of the DBA on 28 August 2018
Bringing DevOps to #SQLSat Oslo
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
0 comments, 445 reads
Posted in The Voice of the DBA on 24 August 2018
Remember the Default Window
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
5 comments, 2,646 reads
Posted in The Voice of the DBA on 23 August 2018
Format a Partial Script with #SQLPrompt
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
0 comments, 403 reads
Posted in The Voice of the DBA on 17 August 2018
Another Brick in the Wall–T-SQL Tuesday #105
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
5 comments, 1,038 reads
Posted in The Voice of the DBA on 14 August 2018
The New SQL Provision Dashboard
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
0 comments, 2,593 reads
Posted in The Voice of the DBA on 13 August 2018
Granting CONTROL on a database–#SQLNewBlogger
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
4 comments, 1,799 reads
Posted in The Voice of the DBA on 9 August 2018
Flipping Sides in SQL Operations Studio
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
2 comments, 433 reads
Posted in The Voice of the DBA on 8 August 2018