Archives: June 2012
In my Encryption Primer talk, I do demo on symmetric key use, and wanted to document it here. Encryption is a serious subject, and please do your research and education, as well as testing, before you implement it.
This post will look at some simple encryption and decryption using symmetric… Read more
Just a reminder: you have until this Friday to enter the 2012 Exceptional DBA awards. I’m judging, and looking forward to reading the entries next week, so get them in.
A hint: communication skills matter. Take some time and think about what you want to write for each question. Read more
I came back from vacation to find the home DSL line bouncing up and down a bit. I wasn’t overly worried, and the kids knew to restart the router when it went down, crossing their fingers for a good connection. I suspected the router might be dying, and was getting… Read more
I took four beta tests earlier this year for SQL Server 2012. I had debated writing another book, and I’ve worked on a few of the cert books in the past, so I thought this would be a good chance to look at the tests. Since I had free invites… Read more
I’m off for a week to Camp Alexander near Pikes Peak for Boy Scout summer camp. My 13year old is attending and working his way toward Eagle Scout. He’s a Star scout now, and with any luck, this week we’ll get 3 more of the Eagle required… Read more
It’s T-SQL Tuesday time again, and this month Aaron Nelson (blog | @sqlvariant) is hosting. The topic is logging, and if you’re like to participate, read Aaron’s post and learn the rules. We do this on the second Tuesday of every month.
If you’d like to host, contact… Read more
I know some people like long holidays, but I tend to prefer short ones. Today is one of those breaks for me. I’m coming back from Pensacola and SQL Saturday #132, taking the day off as I spent Sunday and the morning with my daughter.
This was a combination of… Read more
It’s hard to believe that it’s time for the Exceptional DBA awards once again. It was just a few months ago that I watched the presentation of the award to Jeff Moden in Seattle. However time flies, especially as… Read more
One of the demos from my Contained Databases talk looks at the issues you can have when your database collation does not match your server collation. I’ll walk through the issue here. I’ll show the issue, and then the fix with contained databases.
First, let’s create a database and a… Read more
How do you create a filetable? I assume you’ve enabled Filestream and created a filegroup for your filestream and filetable data. Then you just do this:
-- Create a filetable CREATE TABLE AuthorDrafts AS FileTable GO
The only optional part of this statement is the table name. No other… Read more
This will be my fourth trip to Pensacola for SQL Saturday #132. I’ve enjoyed going every time and I usually take a day or two off from work on the trip to spend with my daughter. Last year we both got shirts, and had a good time at the… Read more
I finally got my standing desk working last weekend and started on Tuesday (after Memorial Day) working at it on a regular basis.
This was the initial setup
I used a box of books, with 4 more under the keyboard and another box for the mouse. I had two monitors… Read more