This weekend is the fall camporee for my middle son’s Boy Scout troop. He’s one of the senior scouts in the group, and he’s committed to help run some of the training sessions and competitions for younger boys. He asked if I’d go along on the trip and help out,… Read more
Five days. That’s how long I’m in Denver after my last trip before I head back to the airport for the 2013 US SQL in the City tour! Once again the crew from Red Gate is traveling around the country, putting on our one day, free, educational SQL in the… Read more
I had a great time at DevConnections this week, It was a fairly quick trip for me, with lots of other events, but a good time. I presented two sessions and both went well. I had some good questions from the audience and people seemed to enjoy the talks. In… Read more
The PASS Summit is just over a week away, and one again Andy Warren and I are hosting a networking dinner on Monday night. This is a free, informal event to help people get to know each other. Whether you are new to the community or have been to many… Read more
It’s just a week until Dev Connections. This is one of the great conferences for the hybrid technology person, with a variety of technologies being talked about, all for a single admission price. I’ll be speaking at SQL Server Connections, but wandering over to the development side at… Read more
I agree that detaching databases in some cases is bad, but it’s not necessarily something I’d avoid. Detach is a good way to prep for upgrades, movement, etc. It may… Read more
This weekend is SQL Saturday #249 in San Diego. I’m looking forward to the trip for a few reasons, but mostly because I used to live in the Northern San Diego area and love going back to spend time near the beach. I’m not sure what I’ll have time to… Read more
I wrote a post about creating a Filetable, which just covered the basics of how to build one. How do you work with the data in this table? In this post I’ll look at a few things you can do from the T-SQL side.
From the last post, I… Read more
It’s T-SQL Tuesday time again. This is the monthly blog party where we all write on a topic. This month the topic is the Rube Goldberg Machine, as it might relate to SQL Server. You can read the invitation linked above from Rick Krueger and write your own post… Read more
I like most of the SQL Server people I meet. Most of you are polite, cheerful, friendly, and it’s nice to share a few minutes of my life with you, chatting about anything. Whether that’s technical issues with SQL Server, running, books, or anything else, I often find my life… Read more
It seems fitting with the anniversary of Martin Luther King’s “I have a dream” speech that I would write about discrimination this week in my piece “Stunned”. There’s a long discussion over at SQLServerCentral, and along with a phone call with a friend, I thought a bit about… Read more
If you’ve enabled TDE, you need to be sure you have a copy of the certificate that protects the Database Encryption Key (DEK). If you follow my instructions, then you have one.
If you didn’t make a backup, or you have just discovered a TDE database, make one now,… Read more
I was looking over my travel calendar this fall, and I’m somewhat amazed at the variety of events that are being held for SQL Server professionals. There are a number of SQL Saturdays, and if you can attend those, I’d highly urge you to do so. Most are free,… Read more
If you’ve got a Windows Phone, or any of the Windows devices that support podcasts, the Voice of the DBA podcast is in the store. I did a quick search and found it, though the image isn’t there yet.
I was visiting a Red Gate customer last week and one… Read more
It’s on the GoogleGuide site and lists and defines the operators. I’d encourage you… Read more
You’ve enabled Transparent Data Encryption (TDE) on one of your databases, and the server has failed. How do you get this database working on a new instance? This short post will show you how this works.
There are two files you need in order to restore the database. Read more
I ordered my first new new phone this year. I’ve never purchased a new, unreleased model of a cell phone before. I’ve gotten some nice phones, but always 6-12 months after other people have had a chance to use, review, and complain about them. However my wife’s Galaxy S3 was… Read more
It’s T-SQL Tuesday time again, and this month Mickey Stuewe hosts the party. It’s an interesting topic, and one that I think is important, and will be more important, as we capture, store, analyze, and depend on more and more data.
The topic this month is auditing, and you can… Read more
At work my boss this week my boss gave me some quotes about me. We solicit feedback twice a year from co-workers and use that to evaluate how employees are doing. This goes up and down the chain, so everyone from the CEO down gets anonymous quotes.
A few of… Read more
Years ago I worked at an ISO certified organization, where we took our administration and planning seriously. We ensured everything was backed up, we had backup drills, we each practiced recovering systems, loading tapes, even calling the company that rotated our tapes from an offsite location.
One of our administrators… Read more