-->
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: March 2015

Microservices and Databases

I ran across a post on microservices recently and was intrigued. I always like the idea of loosely coupled, independent items in software. However the idea of microservices causes issues with databases. Here’s the section in the piece by Netflix: Create a separate data store for each microservice.

I… Read more

3 comments, 1,861 reads

Posted in The Voice of the DBA on 31 March 2015

Toshiba Portege Z30 Review

I saw recently that Grant Fritchey wrote a review of his laptop, the Portege Z30. I had noted Grant’s issues with laptops and waited to see what he got last year before I replaced mine. I actually had the chance to compare his Z30 with my old Lenovo T430… Read more

0 comments, 1,038 reads

Posted in The Voice of the DBA on 30 March 2015

The April Blogger Challenge

I’d encourage you to take Ed Leighton-Dick’s challenge to blog in April. Read his post, start writing, and put your post out there. Tweet about it, and be proud.

However, if you’ve never blogged, I have a modification for you. Publish privately. The important thing is to just… Read more

3 comments, 457 reads

Posted in The Voice of the DBA on 27 March 2015

tSQLt with TRY..CATCH

Someone asked me the question recently about how tSQLt works with TRY..CATCH blocks and the exceptions that we might test for. It works fine, just as it would with other code, but you need to understand that a CATCH still needs to re-throw an exception.

Here’s a short example. I’ve… Read more

0 comments, 8,041 reads

Posted in The Voice of the DBA on 25 March 2015

The Basic TRY..CATCH

Have you written a TRY..CATCH statement in T-SQL? I hadn’t done it for most of my career, since the construct hadn’t existed. As a result, my code over the years is littered with catching @@error in a variable and then acting on that result. 

However I’m trying to do better,… Read more

2 comments, 998 reads

Posted in The Voice of the DBA on 24 March 2015

Speaking at SQL Saturday #389 – Huntington Beach

I’ll be traveling to CA next month for SQL Saturday #389 – Huntington Beach as well as a Red Gate DLM training session run by Ike Ellis. I’m assisting Ike in running a Database Continuous Integration class. It’s a paid for event, but you’ll learn how to set up and… Read more

1 comments, 735 reads

Posted in The Voice of the DBA on 23 March 2015

Career Ratings

I wrote the other day about measuring your career, and I gave some general advice, but I wanted to give you some thoughts to take away about how you might rate your career.

These are some suggested areas, with a note or two in there. I’m not saying any of… Read more

0 comments, 1,154 reads

Posted in The Voice of the DBA on 20 March 2015

Measuring My Career

I’m going to do a shorter editorial on this, but really I think this deserves more treatment here.

I saw Brent Ozar write a post on measuring your career. In it, he talks about the fact that many people measure their career as a function of their salary. He… Read more

5 comments, 6,906 reads

Posted in The Voice of the DBA on 19 March 2015

ALTER SCHEMA TO ADD PERMISSIONS

I’m sure some of you have wanted to do this:

ALTER SCHEMA Steve AUTHORIZATION Steve

You realize this doesn’t work, and you can’t grant the user Steve, rights to his schema after it’s created. You can do this:

CREATE SCHEMA Steve Authorization Steve

UPDATE: Someone pointed out this works after… Read more

0 comments, 766 reads

Posted in The Voice of the DBA on 18 March 2015

The Demo Setup–Attaching Databases with Powershell

I found another use for Powershell, one actually suggested by someone else: attaching specific SQL Server databases.

TL;DR I have a script that detaches all user databases from a SQL Server instance and then reattches certain ones. Full script at the end.

The Issue

We have a lot of demo… Read more

1 comments, 3,776 reads

Posted in The Voice of the DBA on 16 March 2015

Allowing a User to Create Objects in a Schema

I was testing something the other day and realized this was a security area I didn’t completely understand. I decided to write a few posts to help me understand the issues.

I want to give a developer rights to create objects in a schema. In this case, I’ll stick with… Read more

1 comments, 705 reads

Posted in The Voice of the DBA on 12 March 2015

Altering a Column with NOT NULL

A short piece, as I ran into the need recently to alter a column to NOT NULL status. I’ve rarely done this in the past, usually specifying NOT NULL when I create the table. Often in future changes, I’ve been wary of not allowing NULLs since I’ll always find an… Read more

0 comments, 669 reads

Posted in The Voice of the DBA on 12 March 2015