Archives: July 2012
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Here you go. The raw ones.
It’s a holiday, and usually I’m spending time with the family and enjoying the day.
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…
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