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

The Security Weak Link

I saw this cartoon, which I think is great: Data Security. It’s from John Klossner, and it perfectly shows that humans are, and probably always will be, a weak link.

I look at this in two ways. First, we need to account for and accept that our users will… Read more

0 comments, 239 reads

Posted in The Voice of the DBA on 11 October 2018

Quick PoSh SQL Provision Databases for New Developers

As part of some presentation work, I wanted to demonstrate some onboarding of new developers. To that end, as part of a demo, I wanted to build a script that would take a few parameters and generate some SQL Provision databases for development. The idea is that an admin can… Read more

0 comments, 181 reads

Posted in The Voice of the DBA on 4 October 2018

The Developer’s Guide to Azure–A Good Overview

Someone sent me a link a few weeks back  about a free book from Microsoft. It’s the Developer’s Guide to Azure, and you can download it in Kindle or other formats. I actually got it for the Kindle on my phone and went through it in my spare time… Read more

0 comments, 2,112 reads

Posted in The Voice of the DBA on 3 October 2018

Redgate Releases Sept 2018–Practicing DevOps

At Redgate, we build tools to help you build software in the entire DevOps cycle. In fact, I love this new graphic that shows the areas that we focus on in the entire software development cycle.

We don’t just preach DevOps, we live it. As an example, here are the… Read more

0 comments, 158 reads

Posted in The Voice of the DBA on 1 October 2018

Understanding a UK Keyboard for a US developer

One of the very interesting parts of my job is that I run into UK keyboards on a regular basis. Redgate is a UK company and most of the trade show laptops that they bring to events are UK layouts. Our VMs are built in the UK, and when I… Read more

0 comments, 574 reads

Posted in The Voice of the DBA on 28 September 2018

Off to #SQLSat Pittsburgh

I’ve never been to Pittsburgh. Actually, in all of my speaking and traveling, I don’t think I’ve even flown through the airport. I’ve been wanting to rectify this, and quite a few friends, like Bill and Konstantine, have been asking me to come for years. The timing hasn’t worked out… Read more

4 comments, 587 reads

Posted in The Voice of the DBA on 28 September 2018

Finding Objects in a Schema #SQLNewblogger

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

One of the things I needed to do recently was move some objects from one schema to another. I wrote about moving an object between schemas recently, but… Read more

5 comments, 798 reads

Posted in The Voice of the DBA on 27 September 2018

No More Mysterious Truncation

If you read the Microsoft White Paper on SQL Server 2019, there’s a gem buried on page 17. It mentions a trace flag, which some of you might appreciate.

Here’s a little repro:

 

As you can see, the plee I made has actually been heard. I don’t know… Read more

6 comments, 2,970 reads

Posted in The Voice of the DBA on 26 September 2018

Practical Refactoring

Today I hosted a webinar with Gene Kim (@RealGeneKim) and we had a fantastic discussion. I was slightly star struck since I’ve been reading his work and quoting him for years in talks about Database DevOps. It feels like I got to work with someone really famous, and I’m hoping… Read more

2 comments, 137 reads

Posted in The Voice of the DBA on 25 September 2018

SOS to ADS

When Microsoft announced SQL Operations Studio last year, I wasn’t thrilled. The move to a VS Code shell was less of a concern to me than having a better SSMS toolset. Actually, with VS moving to MacOS, I was hoping we’d get a slimmer, closer VS version of SSMS that… Read more

1 comments, 2,197 reads

Posted in The Voice of the DBA on 24 September 2018

Moving Objects to a New Schema

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

I haven’t had the need to move an object from one schema to another in years. Really since SQL Server 2000. I wrote about deleting a user that… Read more

1 comments, 2,315 reads

Posted in The Voice of the DBA on 20 September 2018

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

3 comments, 1,239 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, 769 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, 718 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

1 comments, 162 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, 144 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, 2,057 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, 219 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, 143 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, 164 reads

Posted in The Voice of the DBA on 4 September 2018

Older posts