Archives: February 2009
I haven’t reported on how my resolutions are going yet this year, but after speaking at the Boulder User’s Group recently, and then committing to another presentation in March, I thought it was time to do this.
My initial resolutions were in this post: Goals for 2009
I’ve been trying… Read more
You can read the previous posts here. To finish up (I think), I want to share a networking technique I stumbled on a few years ago, and talk about one more good reason to network.
I've been working with SQL Server for 10 years or so, and while I can't… Read more
This is something that hit me as I was presenting to the Charlotte SQL Server User Group last night.
3 comments, 3,133 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 18 February 2009
Question: Why does Database Mirroring Monitor report that my mirror is disconnected?
This question was sent to a discussion list via email. My reply follows.
Sometimes, I have seen a behavior where the Principal was unable to connect to the Mirror. What is the reason for this behavior? Could it… Read more
0 comments, 1,323 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 18 February 2009
Last night I went to the February Boulder SQL Server User’s Group meeting up in Broomfield, CO to deliver my presentation on The Modern Resume. It was a windy, chilly day where few people were wandering about. Perhaps President Obama being in town had something to do with it as… Read more
MySpace has been the Premier SQL Server site, and probably the largest SQL Server site, on the Internet. It’s a case study that is fascinating, and they’ve been surprisingly candid at times about how their systems are built.
Many of us in IT are competitive, maybe slightly more so than in other professions. Competition adds a little spice to whatever you're doing, but the part that I find interesting personally is deciding when and what I want to be competitive about. Maybe there was a time when it… Read more
When I talk to other SQL Server professionals, I’m often surprised at how many do not have any involvement in their local SQL Server user group. As best I can tell, the problem is not limited to SQL Server types – many technical pros do not even know that there… Read more
Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?
Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?
This question was sent to me via email. My reply follows.
Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?
Databases to be mirrored are currently… Read more
0 comments, 1,063 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 17 February 2009
I've always enjoyed the science fiction writings of Gordon Dickson, and recently re-read an old copy of The Human Edge, a collection of his older short stories.I'm not usually big on short stories, but most of these are pretty good. The overall theme is about humans triumphing over… Read more
Database Mirroring FAQ: If the principal fails while running in high performance mode, what options do I have for bringing the mirror online?
This question was sent to me via email. My reply follows.Quick question on DB mirroring client redirection after Principal fails ...
Consider a simple scenario with Asynchronous mirroring: Read more
4 comments, 3,252 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 16 February 2009
Now, we are going to get slightly esoteric here. I'd noticed that the performance of string concatenation tasks didn't increase in a linear fashion with increasing size of a string. For a short string, it was blindingly fast, but when you scale up, the performance gets disappointing. When you're handling… Read more
It’s rare that I’ve taken vacation in the last few years. In fact, when I took an unwired week in June 2007, that was probably the first vacation where I didn’t have a computer to check on work in 5 or 6 years. However throughout the rest of 2007 and… Read more
You can read the previous posts here. To finish up my thoughts on networking I want to brain storm some about how we might make it easier and more effective for the average Joe (which is most of us) to network.
If you've been to the PASS Summit, or similar… Read more
I diverge a little from the typical coding-based/oriented best practice to one that is focused on governance within public or government organisations with respect to the security of the data in databases used for annual reports.
Internal controls fall under the general COSO framework, and are more explicitly defined in the U.S.… Read more
I have always been of the personal opinion that all SQL Server tables have a clustered index. As part of the research I am doing on a new book on High Performance Index Maintenance, and on heaps specifically, I ran across this SQL Server Best Practices Article from Microsoft.… Read more
This past weekend we were moving database files around because we added new LUNs to an existing production cluster. We went at the old tried and true way, we detached the databases, moved the files, and re-attached the databases. That seemed to work well and we thought everything was okay.… Read more
2 comments, 1,783 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 13 February 2009
I have a personal web site I set up years ago, mainly so I could post stuff for my extended family and kind of keep a log of my life. Back then it was a "weblog" instead just a blog and there wasn’t much software around for the Windows world.… Read more
I love my Kindle, but it uses an older e-ink technology that's a little slow and doesn't support color. Not big complaints from me and I don't mind the refresh time to flip pages, but it's something I've heard quite a few people complain about.
I saw this note that… Read more
I think we've all seen and heard about Flight 1549 doing the emergency landing on the Hudson River. Truly a happy ending to the story and for that I'm glad, but it also made me glad to see for once we're using the word hero in a context that seems… Read more