Dec 14, 2010
It’s that time of the month again, no not that one, it’s T-SQL Tuesday time and this weeks topic is hosted by none other than SQLServerCentral’s own Steve Jones. If you don’t know what T-SQL Tuesday is, you’re either new to the SQL community or have had your head buried in the sand for the last year.(…)
Dec 2, 2010
London: SQLFAQ 2010 Festive Soirée (Buffet & Dance) – 17th December In case you had not heard it on the grape vine already, there’s only one Christmas event that you will actually “want” to attend this year. We all know that the office Christmas do can some times be a bit of a let down,(…)
Nov 11, 2010
Did you see the editorial post from SQLServerCentral this morning? It’s very cool and I wanted to bring it to your attention. Those clever chaps have gone and deployed the latest edition of SQLMonitor from RedGate on the SQLServerCentral website and made the dashboards available for you to interact with online, in real time. Take(…)
Nov 9, 2010
That’s right people! News just in from the PASS Summit 2010 currently going on right now in Seattle. You can now download Microsoft® SQL Server® code-named ‘Denali’ – Community Technology Preview 1 (CTP1) from here. Here’s the thoughts of SQL Server MVP’s Brent Ozar and Gail Shaw on SQL Server Denali. One of the perks of being an(…)
Nov 2, 2010
Did you catch the brilliant and thought provoking editorial post Life Without a Net by Rodney Landrum on SQL Server Central this morning? The post pondered the entertaining thought of what life would be like without the very lifeblood that we all have come to know and love, the internet. What I found particularly interesting about(…)
Sep 22, 2010
After much anticipation my brand spanking new Amazon Kindle finally arrived last weekend. I’d been chomping at the bit to get my hands on the reader and I must say I’m really impressed with it so far. As I opened my delivery parcel and lifted the device out from it’s packaging my attention was immediately(…)
Sep 13, 2010
Every so often whilst going about my DBA business I encounter a Blog post that is just too good not to share. There are stacks of excellent resources available on the interweb and those that I wish to keep for future reference I add to the SQL Server Resources area of this site. On this(…)
Sep 9, 2010
Whilst enjoying my coffee fix this morning, along with today’s SQL Server Central Email, my attention was caught by Steve Jones’s Editorial comment.The key theme looks at how much you enjoy your current job role and Steve goes on to rightly suggest that you should not settle for anything short of what makes you happy.(…)
Aug 24, 2010
What are the character traits of outstanding SQL Server Database Administrators (DBA) ? You know what I’m talking about. There are DBA’s out there that go way above and beyond merely getting the job done. Managing huge workloads with ease and delivering them with class. But how do they do it? I’m certain you have seen and(…)
Aug 10, 2010
25/03/11 – This post has now been updated to include a link to the solution. Back by popular demand, here’s another SQL Server Crossword. You can find SQL Server Crossword #1 here. Same as before, the answers are all SQL Server words that you will be familiar with from your experience of working with SQL(…)
Jul 26, 2010
It’s been ages since I originally posted this way way back when I first started this blog. It proved a popular post back then and so I wanted to share it with all of you new readers. I’m toying with the idea of making puzzles, games, and quizzes a more regular feature so if this is something(…)
Jul 22, 2010
SQLBits is Europe’s Largest SQL Server Event That’s right, just take a moment to let that point hit home. If you are only able to attend one SQL Server event in Europe this year, this is the one you are going to want to choose! Maybe the PASS Summit 2010 is not a practical option(…)
Jul 14, 2010
If you’re a SQL Server Database Administrator and you don’t know what CHECKDB is then you need to stop whatever it is your are doing right now and read this. Seriously, just go ahead and do it now. It will only take you ten minutes to get to grips with the basics and it could(…)
Jul 13, 2010
One of the great things about working with SQL Server is the opportunity to be involved in our fantastic SQL Server community. This months T-SQL Tuesday topic asks what we as data professionals do to learn our subject. (You can follow the conversation on Twitter using the #TSQL2sDay tag.) SQL Server is a big topic(…)
Jul 1, 2010
As a DBA you will encounter processes, code and design decisions within your environment that require change for the better. The most common driver for such change is performance improvement. Oftentimes the changes you wish to drive will require design and implementation by someone other than yourself. Proposing changes(improvements) to an authors existing code/process/design can(…)
Jun 30, 2010
Like most DBA’s I’m sure you often find yourself delivering information to the business concerning the performance of your SQL Server platform but have you ever stopped to consider the wider implications of your actions? As a SQL Server Database Administrator you are responsible for the overall health and well being of your SQL Server(…)
Jun 25, 2010
Whilst perusing the forums over at SQL Server Central today I stumbled across an interesting question regarding how to identify how much memory is being used by SQL Server on a per database level. As you know SQL Server stores database data and index pages in memory in an area know as the Buffer Pool.(…)
Popular Articles