One of the things that’s bothered me is the way the charms bar frequent popping out as my mouse moves to the upper or lower right. I do this as I’m trying to reach the “x” to close a window or adjust time zones. The bar pops out and it’s… Read more
I saw a post recently where someone noted they had moved tempdb like this:
USE master; GO ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'c:\tempdb.mdf'); GO ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = 'c:\templog.ldf')
This gives you the… Read more
It’s just two weeks until my next trip. It feels like I just got back from London, and one again I’m prepping to leave again. This is my only trip in July, which I appreciate. It’s been a busy year so far, with lots of travel for me and I… Read more
Test your restores: he first tip in my Hard Earned Lessons of a DBA piece.
I can’t emphasize this enough. I’ve been called in as an employee and consultant to companies that never had tested a restore. Quite a few of those times there has been data loss.
It’s T-SQL Tuesday time again. This is the monthly blog party, started by Adam Machanic. If you’d like to participate, write a post on the topic and publish it on the second Tuesday of the month. If you’d like to host, contact Adam.
This month the topic is hosted by… Read more
“The hashing alone being MD5 tells me that they really don’t care about their passwords too much, so it’s probably some pre-generated site.”
That was from this article on an Anatomy of a Hack. It’s an interesting quote, and it shows a few things.
First, we have a history… Read more
Today was a rehearsal day. Actually the last 2-3 days of work have been split between rehearsing talks that I’m giving at SQL in the City this week, and handling the other daily work I need to do. With an extra load of family chores this week, I’ve had some… Read more
This week is the kickoff of the third year of SQL in the City from Red Gate. As we have the other years, we start 2013 off in London, and I’ll be leaving Wednesday on a quick trip across the water to speak. I’m looking forward to seeing lots of… Read more
It’s T-SQL Tuesday time, and this one is a bit of a challenge for me. Rob Farley is hosting, and asking for people to write on Plan Operators, those various elements that go into the execution plans in T-SQL. I don’t dive too deeply into these items, unlike… Read more
The CHOOSE command is new in the T-SQL as of SQL Server 2012. I hadn’t ever had the chance to work with it, but after seeing someone submit a piece recently, I decided to play with it a bit.
This feature is essentially an indexing value from an array. Here’s… Read more
About 3 or 4 years ago I was talking with my wife and a colleague of hers that worked in the mobile industry. This person and my wife thought that the mobile industry would explode, and it’s impact and expansion would dwarf the PC revolution that had most of our… Read more
After creating my Azure account, I wasn’t sure where to go next. Fortunately I had an immediate project that occupied my attention: a public Adventureworks database.
Once again, Red Gate is planning on a tour of the US for the SQL in the City events. Last year we had a large tour, hitting 6 cities in the US during October and November of 2012. It was great fun, and very well received by the attendees.… Read more
It’s amazing how software has advanced. I look at the software I use, and I’m amazed. I still remember texting to 40404 for basic twitter usage on my Windows 6.5 Mobile. That seems miles away from the apps I know use on my current iPhone 4S. I almost can’t comprehend… Read more
I’ve been meaning to do this, and I finally had the chance recently to start working with Azure. Red Gate is investing in cloud tools, and more development tools, so it’s something I need to work on.
I went to the Azure page, and noticed a “Member Offers” link.
When… Read more
When Andy Warren (b | t | Li)started SQL Saturday with #1 in Orlando, we weren’t sure it would succeed. After a few events, we dreamed and wondered if we’d ever get to 50 events. Despite our success in the past, we weren’t sure if a free event,… Read more
I ran across someone that was building a restore script to automated their restores. This person wanted their script to work with any instance, and that means they’d need to find the path for the database files, if the database already existed.
It was interesting to me, and I decided… Read more
I know it’s not schizophrenic, but that sounds better. It’s really a split personality.
I wrote recently about Windows 8 and what I consider to be poor design in the update system. Today I want to look at another aspect that troubles me.
I’ve gotten used to the… Read more
Someone suggested Newsblur to me, and I went to their home page. Like many sites, it asks you to sign up, so I decided to give it a try.
The import from Google Reader caught my attention, so I clicked it. It asked for an authorization from Google, and then… Read more
It’s T-SQL Tuesday time, this month hosted by Wendy Pastrick who asks you to talk about the Long and Winding Road. Wendy asks us to talk about your job, your road map to the future, and what might be in store for you.
T-SQL Tuesday is a monthly blog… Read more