I’ve learned that the dash (-) is going to be my friend. Filtering and comparisons are the backbone of SQL. We… Read more
I saw this as a problem recently from someone and thought it would make a good post. As I was building a quick solution, someone else posted theirs, but I decided to save mine as a blog post. It was a good, quick, T-SQL exercise for me to work on. Read more
My first flight of 2014 will be to Cleveland to run a SQL in the City seminar and then speak at SQL Saturday #241. Both are free events, taking place on February 7th and 8th, respectively, and it’s a great chance for you to improve your SQL Server skills,… Read more
It’s a little less than two weeks until SQL Saturday #271 – Albuquerque. The second event in that great city, and the beautiful state of New Mexico. I rarely get there now that my brother moved away, but’s always neat to visit.
I was lucky enough to get chosen… Read more
I missed last month and I was a bit sad, but I was traveling the week before and speaking, and then was on vacation. No time to write a post, and it was a tough topic from Robert Davis. However I’m back this month, and I’m thrilled to participate in… Read more
The authors note this is an optional chapter, one that isn’t necessarily one you need to read. After going through it,… Read more
What are objects? I’ve always found that to be a hard question to answer if I’m talking to someone that doesn’t… Read more
I’ve got a torn ACL. I found out yesterday at a visit with a surgeon that gave me the results of his exam and an MRI I had last week.
Don’t feel too bad for me. I’ve had this for (I’m guessing) eleven years. In that time I’ve
Post holidays, day 7 looks at the shell itself and adding in snap-ins and modules. I have to say that the… Read more
It’s been a month and a half in real time since I started the Powershell Challenge. In that time, I had a business trip and 9 days of vacation and the holidays that impacted the event. After a week of working on the book, I ended up sporadically getting back… Read more
I announced in the Christmas editorial that I was discontinuing the video podcasts. Needless to say I heard a complaint from my Mom that afternoon. She enjoys the podcasts, even though she doesn’t understand all the technology. I did get a couple other notes from people and thought I should… Read more
I’ve written a bit about phones recently as I’ve experienced the switch back to iOS from Android. There are a few other posts in this series:
I wanted to stop and take a moment and think about design… Read more
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love the tool and had a copy before Red Gate bought the technology from the original developer. Recently I’ve run into a few people that weren’t aware of some of… Read more
Not in many ways, and certainly not in enough for me to stick with Android over iOS, but here are a few things I do think.
If you’re slightly lost, I’ve written on Android v iOS after moving to a G4, my move back to iOS, and why I left.… Read more
Day 6. This is where I found the idea of Powershell getting interested. I used pipes extensively back in my Unix… Read more
It was a busy year for me. As I look back at my speaking CV for 2013, here’s what I see:
- Richmond SQL Server User Group
- SQL in the City Seminar – Richmond,…
Day 4, and 5. This wasn’t a long chapter, but it came right around travel and vacation, and as a result,… Read more
One of the encryption options in SQL Server is symmetric key encryption. This is the type of encryption most people think about when they consider encrypting data. In symmetric key encryption, we use a key to encrypt data, and then also use a key to decrypt data.
The key used… Read more
I wrote last week that I had switched back from Android to iOS, but I didn’t list out specific gripes or issues I had. This post looks at some of my complaints with Android, and specifically the S4. I’ve also included a few things that I think I’ll miss, or… Read more