-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

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, 231 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, 218 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,008 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,097 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, 363 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,544 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, 323 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, 977 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,514 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,698 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, 359 reads

Posted in The Voice of the DBA on 8 August 2018