Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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

Windows Phone – What Should Microsoft Do?

I’ve been intrigued by Windows Phone as a platform. I’ve never owned one, and while I considered getting one, the dearth of apps led me to an Android instead. I really tried to get down to a list of core apps that I needed, which was 12 or 15 at… Read more

1 comments, 195 reads

Posted in The Voice of the DBA on 17 April 2015

April Blogger Challenge 3 – Filtered Indexes

The April Blogger Challenge is from Ed Leighton-Dick and aimed at new bloggers, but anyone is welcome. I’m trying to motivate and cheer people on.

Why Filtered Indexes

I haven’t used filtered indexes much in my career as they didn’t exist while I was a full time SQL developer and… Read more

1 comments, 172 reads

Posted in The Voice of the DBA on 16 April 2015

SQL Prompt – Killing the Detail Box

I love SQL Prompt and use it constantly. When I don’t have it, my code writing process slows to spurts and stutters, and it’s painful.

However one of the defaults for SQL Prompt is to pop up details about objects when I’m typing, as shown below:

I usually want the… Read more

0 comments, 180 reads

Posted in The Voice of the DBA on 15 April 2015

Have you tried DLM Dashboard?

DLM Dashboard is a new product from Redgate Software that’s free. Free as in beer, which should be attractive to many of you. The product is in Beta, but it’s fairly stable and has worked well for me. It’s still maturing, and we’re certainly looking for feedback on what works… Read more

0 comments, 221 reads

Posted in The Voice of the DBA on 15 April 2015

T-SQL Tuesday #65 – Learning Computed Columns for XML

It’s T-SQL Tuesday time again, and this month the invite comes from Mike Donnelly (@sqlmd). The topic is Teach Something New and it’s a good one.

I try to learn something all the time, and this post is about something I ran into recently with a submission from… Read more

0 comments, 183 reads

Posted in The Voice of the DBA on 14 April 2015

April Blogging Challenge 2 – Primary Key in CREATE TABLE

The April Blogger Challenge is from Ed Leighton-Dick and aimed at new bloggers, but anyone is welcome. I’m trying to motivate and cheer people on.

Designating a Primary Key at Design Time

In the first post on this subject, I noted that I often add a primary key after the… Read more

1 comments, 228 reads

Posted in The Voice of the DBA on 9 April 2015

A New Use Case for SQL Prompt – Shrinking Code

I thought this would work, but I wasn’t sure. I saw some code the other day like this:

DECLARE @char AS CHAR(1); SET @char = NULL; SELECT ISNULL(@char, 0); SELECT COALESCE(@char, 0); SET @char = 'E'

Read more

0 comments, 208 reads

Posted in The Voice of the DBA on 7 April 2015

New Blogger Challenge 1 – Adding a Primary Key

The April Blogger Challenge is from Ed Leighton-Dick and aimed at new bloggers, but anyone is welcome. I’m trying to motivate and cheer people on.

Primary Keys

I firmly believe that every table should have a primary key. At least until you have a reason not to have one. If… Read more

4 comments, 200 reads

Posted in The Voice of the DBA on 2 April 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

2 comments, 120 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, 83 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, 39 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, 6,885 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, 306 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, 177 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, 297 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,048 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, 200 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, 441 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, 245 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, 247 reads

Posted in The Voice of the DBA on 12 March 2015

Older posts