I was really lucky to get on a waitlist for this event and relieved to actually get invited in the end. It was a good day with some really interesting presentations, some gearing up for SQL Bits III. The SQL Server UK Product Managers were both fun and lively and kept everything going really with...
Got this problem at a client site, had a look at the kb associated with it How to troubleshoot the "Cannot generate SSPI context" error message http://support.microsoft.com/kb/811889 and I screamed silently inside as I read it. As I read on, I thought hang on, what if I change the Native Client access order from TCPIP/Named...
Hurrah. I've now got 2 of the 3 exams to become a SQL Server 2005 MCITP. I enjoyed this one, it was the 70-444 PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005. They have a catchy title don't they? As an MCDBA I could have taken the single upgrade...
I was at an interview the other day and one of the interviewers said that SQL Server 2005 wasn't quite an Enterprise Database as you couldn't mirror databases yet. I looked at this chap and thought, 'What the hell is he talking about?' I didn't say anything 'cos I didn't want to cause an argument...
Sometimes we all need a little help and here's Microsoft's offering for clustered servers; Cluster Diagnostics and Verification Tool (ClusDiag.exe) Cluster Diagnostics and Verification Tool (ClusDiag) is a graphical tool that performs diagnostics tests on a pre-production server cluster and creates log files to help system administrators identify configuration issues prior to deployment in a...
I've seen a few scripts knocking around to remove unused indexes. I've had a sneaky feeling in the past about this and whether it would actually make any difference or not, but here's my experience: DO NOT REMOVE INDEXES BASED ON THESE SCRIPTS IN SQL SERVER 2005. Sorry about the shouting. I have seen at...
