Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: February 2009

New Years Resolutions 2009 – Feb Update

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

2 comments, 284 reads

Posted in The Voice of the DBA on 19 February 2009

Networking - Part 6

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

12 comments, 158 reads

Posted in SQLAndy on 18 February 2009

The Limited Usefulness of Encrypting File System (EFS) and Transparent Data Encryption (TDE)

This is something that hit me as I was presenting to the Charlotte SQL Server User Group last night.

Back in the Windows 2000 days I wrote an article on Encrypting File System and explaining how it could be used to protect the database files at rest. In my Fortress… Read more

3 comments, 1,495 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 18 February 2009

Database Mirroring FAQ: Why does Database Mirroring Monitor report that my mirror is disconnected?

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

Boulder SQL Server Users Group

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

0 comments, 262 reads

Posted in The Voice of the DBA on 18 February 2009

MySpace

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.

Recently someone posted a link to a presentation from their lead DBA Read more

1 comments, 285 reads

Posted in The Voice of the DBA on 18 February 2009

All In & Being Competitive

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

7 comments, 559 reads

Posted in SQLAndy on 17 February 2009

Your Local User Group

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

3 comments, 338 reads

Posted in Tim Mitchell on 17 February 2009

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

Book Review - The Human Edge

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

2 comments, 241 reads

Posted in SQLAndy on 16 February 2009

Database Mirroring FAQ: If the principal fails while running in high performance mode, what options do I have for bringing the mirror online?

Question: 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

Be Careful with String Concatenations in SQL Server with Big Strings.

 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

22 comments, 3,623 reads

Posted in Phil Factor's Phrenetic Phoughts: The SQL on 16 February 2009

Recharged

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

0 comments, 225 reads

Posted in The Voice of the DBA on 16 February 2009

Networking - Part 5

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

8 comments, 162 reads

Posted in SQLAndy on 15 February 2009

The Importance of the Segregation of Duties with Respect to Internal Controls

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

3 comments, 2,629 reads

Posted in The Database Hive for SQL Server DBAs on 15 February 2009

Which is Better: Heaps or Tables with Clustered Indexes?

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

8 comments, 2,126 reads

Posted in SQL Aloha on 13 February 2009

Another Reason to Avoid Cross-Database Ownership Chaining

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,092 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 13 February 2009

SQL Injection - It's Not Just Me!!

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

0 comments, 237 reads

Posted in The Voice of the DBA on 13 February 2009

Color E-Ink

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

0 comments, 285 reads

Posted in The Voice of the DBA on 13 February 2009

Landing on the Hudson River & Being a Hero

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

2 comments, 221 reads

Posted in SQLAndy on 12 February 2009

Newer posts

Older posts