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

Archives: July 2012

Password Resets

I read this piece from Troy Hunt, which is a long look at the password reset process for a web application. It’s one of the first that I’ve seen which talks about the different implementations, along with the pitfalls and advantages of each.

It’s a great look at passwords,… Read more

0 comments, 696 reads

Posted in The Voice of the DBA on 31 July 2012

Creating a DDL Trigger

One of the most amazing features to an old SQL Server 4.2 guy was the addition of DDL triggers to the server. As with any trigger, these can be problematic in that they can overload a server, and they ALWAYS fire, so you can cause yourself problems, but in terms… Read more

2 comments, 1,588 reads

Posted in The Voice of the DBA on 31 July 2012

#GetHawt – The Summer 2012 Edition

Jen McCown started a #GetHawt set of posts last year and I think it went well. It must have, so she started an invitation for a summer competition. Silly me hadn’t been paying much attention, even though I’d seen the tweets. I finally caught up this last week, and… Read more

0 comments, 680 reads

Posted in The Voice of the DBA on 30 July 2012

Sacramento SQL Saturday Here I Come

Packing for SQL Saturday #144 in Sacramento, CO. Dan Hess, one of the organizers, asked me last November at the PASS Summit if I’d come. I told him I’d try, and the scheduling worked out. As soon as I was sure that weekend was free, I submitted sessions and… Read more

0 comments, 490 reads

Posted in The Voice of the DBA on 25 July 2012

DevConnections – Fall 2012

This fall is the DevConnections SQL Server Connections conference in Las Vegas again. It’s at the Bellagio, setting for one of my favorite movies, Ocean’s 11. It’s a smaller conference this time, and SQLServerCentral only has 4 slots for the event. Both Grant Fritchey and myself will be speaking… Read more

0 comments, 868 reads

Posted in The Voice of the DBA on 25 July 2012

Help others and enter to win a prize

My home state of Colorado has been devastated by wildfires. My vacation this summer was semi-cancelled with a fire closing a local Boy Scout camp. We found another campsite for a few boys for a couple days, but the weeklong camp wasn’t available. There have been floods in the East… Read more

0 comments, 646 reads

Posted in The Voice of the DBA on 23 July 2012

Working at Home Tips for Erin

A friend of mine, Erin Stellato (blog | @erinstellato) is about to change jobs. She’ll go from working in an office to working at home, and I think it’s great. She’s a very smart young lady, and I think this is a terrific opportunity for her to work… Read more

6 comments, 1,491 reads

Posted in The Voice of the DBA on 23 July 2012

The Mentoring Experiment is taking applications

If you would like a mentor, we’ are taking applications at The Mentoring Experiment. We ran this last year and it went well. We’ve been slow to get another round going for a variety of reasons, but we’re finally moving forward.

If you would like someone to help mentor… Read more

0 comments, 658 reads

Posted in The Voice of the DBA on 20 July 2012

Contained Databases – Server Setting Matters

In doing some additional testing on contained databases, I decided to create a new database on a new test VM.

CREATE DATABASE cdb1
 containment = PARTIAL
;

To my surprise, I got this error:

Msg 12824, Level 16, State 1, Line 1

The sp_configure value ‘contained database authentication’ must be… Read more

2 comments, 911 reads

Posted in The Voice of the DBA on 19 July 2012

Send me your pictures

If you got some with me at SQL in the City last week I London, or anytime in the last year, I’d love to have copies.

Pictures are memories for me, and I treasure all the ones I have of my kids. However I don’t have a ton from work,… Read more

0 comments, 472 reads

Posted in The Voice of the DBA on 19 July 2012

T-SQL Tuesday #32 – A Life in the Day

It’s T-SQL Tuesday time again, delayed a week this month, so I had  a whole extra week to get ready. This month the party is hosted by Erin Stallato, fellow MVP, runner, and a SQL Server expert. Such an expert, she was recently hired by SQL Skills, one… Read more

3 comments, 520 reads

Posted in The Voice of the DBA on 17 July 2012

SQL in the City – London 2012

It’s a wrap. Two days of SQL in the City are complete, and I’m back at home, almost feeling normal. I prefer short trips to the UK, but this one was extra hard since it was a conference schedule. For me that’s up at 6:30 to run and usually not… Read more

2 comments, 1,375 reads

Posted in The Voice of the DBA on 16 July 2012

Time Zones

Why don’t we have a function like the one in this article to convert from time zone to time zone? Seems like something SQL Server should have added awhile ago.


Filed under: Blog Tagged: sql server, syndicated, T-SQL

Read more

0 comments, 444 reads

Posted in The Voice of the DBA on 10 July 2012

Back Across the Pond

This coming weekend is SQL in the City – London 2012. Friday, July 13, and Saturday, July 14, I’ll be at One Wimpole Street in London. This is the Royal Society of Medicine, a fantastic venue for events near Oxford Circus. I’m looking forward to the event and the… Read more

2 comments, 482 reads

Posted in The Voice of the DBA on 9 July 2012

The Standing Desk – In the Light

It’s been almost a month since I started the Standing Desk experiment. My first setup was down in the basement, since that was the desk that fit my monitor stand. In the middle I had a week of vacation, where I didn’t do much standing at the desk, though I… Read more

0 comments, 511 reads

Posted in The Voice of the DBA on 5 July 2012

Fourth of July Bloopers

Here you go. The raw ones.

It’s a holiday, and usually I’m spending time with the family and enjoying the day.

In all seriousness though, this is an important day for US citizens. The birthday of our country. Take a moment and read the Declaration of Independence or the Constitution Read more

0 comments, 479 reads

Posted in The Voice of the DBA on 4 July 2012

Decryption and CASTing

In my last encryption post I showed how to encrypt and decrypt data with a symmetric key. However there was a piece of the explanation I left out. If you look at that post, suppose that you ran this query after you’d encrypted the data:

-- decrypt the data
select…

Read more

3 comments, 1,524 reads

Posted in The Voice of the DBA on 3 July 2012

Colorado Wildfires

More than a few people have asked how I’m doing with all the fires in Colorado, so I wanted to drop a quick note. I’m fine and the family is safe. We are near Parker, CO, so not very close to the fires themselves.

We were affected slightly by the… Read more

0 comments, 493 reads

Posted in The Voice of the DBA on 2 July 2012