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

What is Projectsv13 in SQL Change Automation?

I got this question recently from someone that was evaluating the SQL Change Automation client in Visual Studio. After setting up a new PoC (Proof of Concept), they were confused about why there is a new entry in their list of SQL Servers.

If you’re wondering, this is what you… Read more

1 comments, 69 reads

Posted in The Voice of the DBA on 19 September 2018

The Trigger Roundup–T-SQL Tuesday #106

This month was my turn to host T-SQL Tuesday. I chose Trigger Headaches or Happiness as the topic, and I am glad that there have been quite a few responses.

I started the review almost immediately,and here are a few highlights. I separated these based on how I first thought… Read more

1 comments, 159 reads

Posted in The Voice of the DBA on 18 September 2018

A Summit Contest for registering by Sept 22

If you haven’t registered for the 2018 PASS Summit and plan to go, you might press to get registration done this week. Next week prices increase, but this week you can save.

There is a promotion from PASS that will let you save $200 this week. In addition, you can… Read more

0 comments, 151 reads

Posted in The Voice of the DBA on 17 September 2018

Deleting a User that Owns a Schema

This was an interesting question I saw posted recently. Through SQL Server 2000, trying to delete a user that owned objects was a pain. We had to actually rebuild all the objects, which was problematic. With SQL Server 2005 and later, we got schemas actually added as separate entities, so… Read more

0 comments, 124 reads

Posted in The Voice of the DBA on 17 September 2018

Learn about SQL Source Control in Redgate University

I love the SQL Source Control product from Redgate. It’s not perfect, and it can be slow to run at times, but the simplicity of what it does, of getting my code quickly and easily to a VCS is fantastic. I really appreciate it.

This is one of the tools… Read more

0 comments, 114 reads

Posted in The Voice of the DBA on 17 September 2018

Importing Flat Files in SSMS 17.x Works

One of the more annoying things I’ve found in SSIS/SSMS is trying to import CSV files for some quick analysis. For some reason I constantly seem to get files that the import wizard keeps having issues. On top of that, the defaults are annoying. When I need to get a… Read more

2 comments, 197 reads

Posted in The Voice of the DBA on 12 September 2018

SQL in the City Summits–Coming to New York, London, and Chicago

I love New York. Every time I get to travel to the city, I get excited and look forward to the trip. I was able to spend a night in Brooklyn earlier this year, touring a college with my daughter. Now I’m very lucky to get a second trip this… Read more

0 comments, 192 reads

Posted in The Voice of the DBA on 11 September 2018

Redgate University is Growing

There isn’t a degree to be gained, but you can get a lot of information about Redgate products at Redgate University. This is the place to learn how to best use the products. This is a work in progress and we’ve started with a few of the more popular… Read more

0 comments, 122 reads

Posted in The Voice of the DBA on 10 September 2018

Watch SQL in the City Streamed September 2018

I’m over in the UK and we have SQL in the City Streamed tomorrow. This is our September edition, and Grant, Kathi, and myself are prepping today.

We also have a special guest this time, Rob Richardson. Rob is a fantastic software developer and fellow MVP. I’m… Read more

0 comments, 131 reads

Posted in The Voice of the DBA on 4 September 2018

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

37 comments, 188 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, 199 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, 192 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, 944 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,032 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, 346 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,467 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, 302 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, 961 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,461 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,670 reads

Posted in The Voice of the DBA on 9 August 2018

Older posts