Actually, Maryland, but close enough. I’ll be in Chevy Chase this weekend, first for our SQL in the City Seminar on Deployment Friday, and then SQL Saturday #233 on Saturday. Both events are free, so if you can come to one or both this weekend, register and come. The registration… Read more
Run this code:
CREATE DATABASE MyRestoreTest ; GO USE MyRestoreTest go BACKUP DATABASE MyRestoreTest TO DISK ='myrestoretest.bak';…
Day 3, chapter 4.
This one is about commands, and getting familiar with what a cmdlet is, the naming convention, and… Read more
I wrote about transactional consistency recently. Why do we need this?
Imagine that I have an orders table and an ordersdetail table in my database. The orders table has the order header (date, customer, etc) and the detail table includes information about the items purchased (product, qty, price). Let’s say… Read more
Today was Chapter 3, Using the Help System. Another not-so-exciting topic, but one that does matter. There are a ton of… Read more
I got started on Learn Windows Powershell 3 in a Month of Lunches at lunch one day. Working at home makes this easy as I have a computer and a kitchen near each other. In this case, a salad, a bowl of chili, and the laptop next to the book… Read more
I never saw the movie, though it’s on my list to watch sometime. I love the Wachowski’s as directors.
I’m writing this in support of a few talks I give that talk about backups. This is how I see things and it’s based on things I’ve learned over time. Some of this comes from a great explanation on Technet from Paul Randal, but there are misc other sources… Read more
I’ve been wanting to do more with Powershell (PoSh). I’ve seen Allen White present on it for years, and I’ve dabbled in various ways, using it to handle small tasks. However I haven’t really committed to learning a bunch of PoSh.
Last month I was with Grant Fritchey on the… Read more
What does this mean? I had someone ask me in a session recently, and I think I have a good explanation, but I thought this was worth a blog.
Transactionally Consistent means that there is a snapshot of the database at a point in time that ensures committed transactions are… Read more
I got back from SQL Intersection on Wednesday afternoon. I did work a bit, but not too much after traveling and speaking this week. Today I’m in the office, but only today.
Tomorrow I’m outside.
I have more vacation scheduled tomorrow, along with Monday and Tuesday. Given the nature of… Read more
I’m booking vacation. I know I recommend balance, and tell people to take vacation, and that I’m bad at it. My wife is right there with me. I’m not sure who’s worse, but we both struggle to make time away from work. It’s good and bad. We enjoy our careers,… Read more
Probably the most often asked question on SSC is about full transaction logs, and often full disks. It happened again recently. I don’t have an exact count of threads, but rough searches show this to have 70,000+ results, when most other searches I run show many, many fewer results… Read more
It’s fairly easy. At least, I think it is if a salesperson can do it.
Alex Yates, salesman extraordinaire at Red Gate Software, spent a lunch hour recently setting up a CI system so he could better understand how hard, or easy, it can be for customers. He wrote about… Read more
If you haven’t made it to a conference this year, you’ve still got a great one to think about: SQL Intersection. The second installment of this conference, run by SQLskills (Kimberly Tripp and Paul Randal) takes place in two weeks. Come to Las Vegas and learn a ton about… Read more
Yesterday was our first 2013 SQL in the City event in Pasadena, CA. I was excited and nervous, with 3 talk and a keynote that I needed to integrate and work with two others on. We practiced 3 or 4 times on Tuesday and Wednesday morning, trying to get our… Read more
It’s T-SQL Tuesday time, the second Tuesday of the month when we all coordinate our blog posts on a particular topic. This month Kendal Van Dyke has invited us to take a break from technical topics and have a bit more fun. This month’s topic is asking about the swag… Read more
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