Wednesday, 21 March 2012

24 Hours of PASS 2012

Last 24 hours where the 24 hours of PASS tightly packed with very interesting sessions about many aspects of SQL Server. A lot of information, a lot of stories and unfortunately some technical problems too. Still a time well spent. 

My favourite presentations of the day in the order they happened were

Wednesday, 14 March 2012

Database table naming conventions

Opinions are like... belly buttons and so are naming conventions, right? Some people ignore them and some are ready to go to some lengths in proving superiority of theirs. And the truth is it doesn't really matter, unless your convention happens to be something as silly as Hungarian notation, for example.

When it comes to naming database tables there are two schools of thought: you should either use singular or plural nouns. Some people argue that singular looks better in projections and selections because you tend to think about an individual item there. Some people, and I am among them, think that the noun should be plural as it is semantically closer to what it is: a set.

But I am easy, I am not going to try to convince anybody that a table called sales will perform better then one called sale. It is just that sales fits better in the way I think about databases and in turn the way I think about them have on a few occasions proven to result in better performance ;)

Wednesday, 7 March 2012

How not to move locations

It will be a bit of storytelling this time. A story about trust and guts and things you cannot control.

Not so long ago a company that hosted their own servers in-house decided to move offices. All was planned in advance. The servers were to stay in the old location longer than everybody else until a decent internet connection will be installed in the new server room. The ISP was informed, a new line was ordered with specific instructions that it is not (what it was) an office move but that a completely new line is needed in the new location. A small trick to make sure everything goes right.

The plan was, that on Friday the new line will be installed and then on Saturday night the servers will be moved. The time has come and... nothing has happened.

Obviously ISP's support very kindly apologised from a very safe distance and said they are very busy and it will be done as soon as possible. The whole move was postponed until the following weekend.