-->
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

T-SQL Tuesday #106 – Trigger Headaches or Happiness

Since I took over the T-SQL Tuesday a few months ago, I decided I ought to host again. Especially since I’ve done it twice, but Wayne Sheffield got his third spot last month. Gotta keep up with Mr. Sheffield.

Triggers, for fun and frustration

I’ve been working with SQL Server… Read more

10 comments, 214 reads

Posted in The Voice of the DBA on 4 September 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, 233 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, 220 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,011 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,099 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, 365 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,546 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, 325 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, 979 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,518 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,703 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, 361 reads

Posted in The Voice of the DBA on 8 August 2018

Day 2–#SQLCareer

This is a series of posts on what my day is like. I don’t do a lot of production technical work, but life as an evangelist is interesting, so here goes. Join the #SQLCareer movement and post about your day. Just a random day, not one that is anything special. Read more

0 comments, 838 reads

Posted in The Voice of the DBA on 25 July 2018

Off on Holiday

Another break for me. This might actually be the first year I use all my vacation allowance.

In any case, I’m going to be gone for two weeks from work. Likely I won’t do any email or respond to anything, so if you’re looking for me, wait until then.

Read more

1 comments, 765 reads

Posted in The Voice of the DBA on 23 July 2018

Silly Photos at Work

Someone I stumbled across this picture of @brento on my drive.

This might be the best one:

And this was a good time:

However, I have a collection of silly moments. Enjoy.

Read more

2 comments, 253 reads

Posted in The Voice of the DBA on 20 July 2018

My #SQLCareer Day–July 19

I’ve asked for #SQLCareer posts, and I haven’t done any. My job isn’t a data platform DBA or developer, but it is SQL related, so a glimpse of the nonsense I perform. I’m asking for more posts, so a note at the bottom.

This should have been a cool day,… Read more

2 comments, 355 reads

Posted in The Voice of the DBA on 20 July 2018

Data Masker for SQL Server and Temporal Tables

A customer had a question recently about using Data Masker for SQL Server and temporal (or system versioned) tables. I decided to make a quick demo that will show how this works.

This is a simple demo, using just a few changes, but the concepts are useful for larger systems. Read more

1 comments, 793 reads

Posted in The Voice of the DBA on 18 July 2018

Is this a SQL Provision Cloned Database?

As I work with SQL Provision, I keep finding new questions and concerns from clients and customers. Recently I had someone wonder if we could determine whether or not a database on which they were working was a SQL Clone cloned copy.

You can, and it’s easy to check.… Read more

0 comments, 600 reads

Posted in The Voice of the DBA on 18 July 2018

Working Hard in Baton Rouge

I’m heading back to Baton Rouge for SQL Saturday #749 this August. This is one of the largest SQL Saturdays in the US, and one I really enjoy. I’ve been there 5 or 6 times, and I was honored to be selected again.

But they’re working me. The schedule is… Read more

0 comments, 354 reads

Posted in The Voice of the DBA on 18 July 2018

The Figleaf Data Masking Beta

I’ve been using the Redgate Software Data Masker for SQL Server in a number of situations to help customers. This is a tool we purchased in 2017 and is a part of the SQL Provision bundle to make building safe, secure dev and test databases.

Project Figleaf is the next… Read more

0 comments, 1,740 reads

Posted in The Voice of the DBA on 17 July 2018

Newer posts

Older posts