Blog

A Look at the SQL Server Browser Service

Let's say you're starting off in a new environment (new job, department, client, whatever) and after being shown your workspace and meeting with your supervisor, you sit down to start figuring out their databases.  You send an email requesting the name of the development database, and the reply you get is as follows: DevDB1\Blah, 1436  (It's a named instance) The backslash makes the fact that it's a named instance pretty evident, and you know that named instances all get their own ports, so you think there's not much to see here.  You fire up SSMS and connect to DevDB1\Blah and…
Read More

Speaking at SQLSaturday #50: East Iowa 2010

I feel extremely honored to have the chance to speak at SQLSaturday #50, which is taking place in Iowa City on September 18th.  The organizers have put together a great schedule consisting of some amazing speakers and somehow I got on the list too! I'll be giving a talk called "Application Coding Sins."  As I've mentioned before, I was an application developer for about two years before I became a DBA, and still do development work on my own.  In my previous job, I spent a bunch of time writing application code to access and update databases, and even more…
Read More

Four Reasons Not To Learn The Dvorak Keyboard

In my previous post I looked at 4 reasons to learn the Dvorak Simplified Keyboard (DSK).  I'll now take a look at the other side and give you 4 reasons why you might not want to. 1.  You're Already A Good Typist If you're reading this, chances are pretty good you're a DBA, developer, consultant, or someone else who makes their living in front of a keyboard.  Given that, chances are also pretty good that you're a solid typist, as you'd be getting work done very slowly using the hunt-and-peck method of typing.  You're probably not the world's fastest, but…
Read More

Four Reasons To Learn The Dvorak Keyboard

For quite a while now I've been intrigued by the Dvorak Simplified Keyboard (DSK).  I was first introduced to it by my mentor at an internship during college, and after reading about how Dr. Dvorak's layout of the keys came to be, I thought it would be neat to learn given its advantages.  After giving it more thought, there some disadvantages as well, and I'm torn to the point that I can't figure out what to do.  In this and the following blog post, I'll take a look at both sides of the issue. 1.  It's Faster Believe it or…
Read More

“Password” is a Dirty Word

Take a moment to think about the really important passwords you use - maybe for your computer at work, email, financial information, or even the 'sa' account on SQL Server.  How many characters long are they?  Are they really all that difficult?  Are they: Dictionary words? Words with a few numbers or symbols substituted in place for letters? Totally random combinations of letters, numbers, and symbols? The last option is obviously the most secure choice, but it also happens to be the most difficult to remember.  I’ve previously mentioned that I’m a big fan of KeePass, an open source password…
Read More