Alas, this isn’t really a SQL post, but thoughts on efforts to share work that has been previously done by one person! For the past two years I’ve handled almost all of the work leading up to SQLSaturday Orlando, bringing in volunteers close to the event to help with logistics.… Read more

Or “It’s 10pm, do you know where your log records are?”

Something that I’ve started to see recently is the idea that Backup Log … With Truncate Only, which was deprecated in SQL 2005 and gone in SQL 2008 can be simulated by backing the log up to… Read more

Read more

Well, I had a pretty good week this week.  I made an effort and met all my goals:

1. Eat smaller portions – this is going well.  My body has adjusted to eating smaller portions so I am “filling up” faster and not feeling hungry as much.
2. Healthier snacks – did…

Read more

Well after much deliberation I have decided to submit an application for the PASS Board of Directors.  I embark on this journey as a true learning experience.  Hopefully, I will make it to the interview stage and gain some additional insight on the selection process.  As the process proceeds I… Read more

We have been working hard trying to get speakers to complete the year for our SQL Lunch schedule. I am excited to announce that the calendar is almost complete. There are still a few openings in December if any of you are brave enough to give us fifteen to thirty… Read more

I drove up to Jacksonville Friday afternoon for the 2009 Jacksonville Code Camp led by my friend Bayer White. I left early enough to beat the Fri afternoon traffic and to give me some quality book store time before the 7:30 pm speaker party. Attendance at the party was… Read more

Compression is one of the major features introduced in SQL Server 2008, and one that can significantly reduce disk storage.  Compression basically eliminates the “white space” in your data, using different internal algorithms depending on the type of compression the engine is using.  There are both backup and… Read more

I'm somewhat conservative with my machines. These days it's a tool for me, and I'm not looking for the coolest thing, I'm looking for something that works.

I started running Windows 7 RC a few months ago when some friends had gotten it working pretty well on their machines with… Read more

There is a lot of advice out there about how to get more done and how to accomplish one's dreams. I know research has shown that when folks write down their goals, they are more likely to get them done, as I explained when I introduced my goals blog. However,… Read more

Dan English put up a blog post on his experiences with installing Gemini. His post is loaded with screen shots and walks you through the install.  He then has a few screen shots of Gemini in action.  Dan also includes several links that you can access for additional information on… Read more

Read more

Read more

Read more

Read more

 Now that the kids have interest in computers, I sometimes find myself competing with them.  I recently purchased a business class Dell laptop, and suddenly find it bursting with downloads and nickJr games.  He has a computer in his room, but the laptop being portable in the family room, seems more… Read more

I was up this morning, starting to work on my desktop. I rebuilt it yesterday, or started, with Windows 7 RTM (from Windows 7 RC) and wanted to get it done. I had a couple items for work to finish as well, so I was looking over them when I… Read more

Microsoft has recently unveiled their newly updated, public MVP website, that does a great job of explaining exactly what a Microsoft MVP (Most Valuable Professional) is, along with lots if interesting tidbits about the program, such as the fact the MVPs live in 90 different countries, speak… Read more

Read more

I had a need to export permissions to be run against the database once an older version was restored (but which didn't have the permissions yet). I'm sure there are 101 versions of the script out there, but here's mine:

SELECT
   CASE dp.state_desc
     WHEN 'GRANT_WITH_GRANT_OPTION' THEN 'GRANT'
     ELSE dp.state_desc … Read more