SQLBits is back! This confrence will be held at the Heslington Campus of York University from 30th September to 2nd October.
As before, you will need to pay for Thursday and Friday, but Saturday 2nd October is the community day and free to all. Unfortunately for me, I will be on vacation so I cannot attend!
Well 2010 has been very interesting. My company are working away on the next generation of our software. It’s been busy in the engineering team, bringing on new contractors for the duration and I have been up to my eyeballs with a number of projects as well as support.
Read more…
It had to happen someday. It happened to me this morning. I was sat on the train and saw a whole bunch of alerts fire through about memory first of all and then thermal sensors exceeding thresholds. An email to the emergency response team from the infrastructure manager telling us that one server has over heated and has failed over. We run an active/active cluster.
Read more…
What is the difference between a seek and a scan? It can be quite a lot, actually!
By definition, a scan will touch on every row in the table or index and retrieve only those rows which match the query criteria. On the other hand, a seek will use available indexes to locate the data.
One thing to note is that I mentioned that a seek will use available indexes. While a table may have an index, SQL Server may still choose to perform a scan if the scan is considered less expensive – for example, a small table may be subject to a scan over a seek.
Read more…
SQLBits VI comes to London on the 16th April 2010.
The event is being promoted as the best event yet and best of all…it’s free! So register today!
You may have seen the term SARGable in blogs or forums and wondered what it means. To start with, SARGable is pseudo-acronym which stands for Search ARGument. A query is considered sargable if the WHERE clause can take advantage of an index to speed up the query. A non-sargable query implies that the WHERE clause (or part of it) cannot use any available indexes which could result in a table or index scan and possibly slow down query performance.
Read more…
I had my appraisal this week. It was an interesting meeting with my manager with many compliments and also constructive criticism on area’s where I need to improve.
Read more…
If you are looking for some good open source offerings for SQL Server, then take a look at the CodePlex website.
Well, 2009 was a busy year for me at work. The databases are growing quite quickly and a lot of projects have come on board. Challenging, but fun.
That said, I have not blogged as much as I would have liked, so 2010 is the year for me to really get the blog off the ground. Aside from that, I do have a couple of books that I should really get round to reading and I need to get myself active again on the SQL Server Central & MSDN forums.
The final goal for 2010 is to write an article or two!
I never really used replication before I joined my current company. We host client databases in our environment and we had a request to replicate a client’s database to them. Our infrastructure group did not want to allow us to replicate directly from production to the client site.
Read more…