Martin Bell UK SQL Server MVP

Scottish Area SQL Server User Group Meeting, Edinburgh - Thursday 25th March

2010-03-18T20:58:00Z

User Group Meeting for the Scottish Area SQL Server User Group Meeting on 25th March 2010...(read more)

SQLBits 6 Registration Now Open

2010-03-17T12:01:00Z

SQLBits VI registations opened on 17 March 2010 at 12:00 ...(read more)

VBUG Manchester March 3rd 2010 - Slides and examples

2010-03-15T22:23:00Z

At the VBUG meeting in Manchester on 3rd March, I was scheduled to talk about Table Valued Parameters, but when I got there the guys wanted something more general so I talked about some of the new features of SQL 2008. The presentation is here and the TVP demo project is here . My blog postings on TVPs are listed at http://sqlblogcasts.com/blogs/martinbell/archive/tags/TVP/default.aspx . Information about the new date and time data types http://sqlblogcasts.com/blogs/martinbell/archive/2009/05/15...(read more)

Visual Studio Professional 2010 upgrades

2010-03-13T12:33:00Z

Discounted Visual Studio 2010 upgrade...(read more)

Learning SQL Server

2010-03-12T07:21:00Z

Everyone is different when it comes to learning, here are a few options to help you find your own preference....(read more)

Slides from the Scottish Area User Group Meeting 25th February

2010-03-04T21:33:00Z

I really enjoyed last weeks user group meeting, the interaction from everyone helped make it an excellent evening. Iain has provided these links for the two products he mentioned in the talk: The product information for Lightspeed is here and the videos for using the features are here , it can be download from here For Performance Analysis the data sheet is here and information regarding installing it can be found here with the download here . Iain’s slides are here ....(read more)

DDD Scotland Registration is now open!

2010-03-01T12:30:00Z

Registration for Developer Day Scotland is now open!...(read more)

Readonly Databases

2010-02-27T11:23:00Z

Have you ever seen a READ_ONLY database with a massive log file and thought why are they wasting all that space?...(read more)

Breaking News - Scottish Area SQL Server User Group Meeting, Edinburgh 25th February

2010-02-23T13:04:00Z

Scottish Area SQL Server User Group Meeting...(read more)

Renaming a computer and maintenance plans

2010-02-21T13:41:00Z

Renaming a server may have knock on issues with maintenance plans, although this method is not sanctioned by MSFT it could get you out of a sticky situation....(read more)

Scottish Area SQL Server User Group Meeting, Edinburgh 25th February

2010-02-20T22:46:00Z

I’m looking forward to this weeks Scottish Area SQL Server User Group meeting. Iain Kick is our guest speaker talking about Performance Troubleshooting. I’ve seen this talk a couple of times and it’s always great to hear how a vendor approaches these problems. If everyone looked at things the same way, then there would be no progress or invention in the world, and each day would be one endless Ground Hog Day! This sort links with the second presentation by Alistair Board and myself on how you can...(read more)

SQL Server 2008 R2 Update for Developers Training Kit Released

2010-02-06T21:37:00Z

I noticed that the SQL Server 2008 Developers Training Kit has been re-released last week with a R2 Update. It looks like a great resource for SQL 2008 information and the additional features in SQL 2008 R2. It includes links to 8 videos (mainly R2 features), 8 presentations (mainly RTM features) and 13 demos (mainly RTM features) and 8 Hands-on-labs (both releases). Anyone looking for learning resources on SQL 2008 and SQL 2008 R2 should check it out, it could save you some searching. It can be...(read more)

ROWCOUNT when setting variables

2010-02-03T12:02:00Z

A common error that you encounter as a DBA is someone setting variables in code to the wrong values. I thought I would look into if checking @@ROWCOUNT could help and if it should be a pattern used when setting variables....(read more)

SQLBits goes West the video(s)

2010-02-01T07:19:00Z

SQLBits videos are now available...(read more)

SQLBits sponsors DDD 8 coaches

2010-01-13T07:17:00Z

SQLBits are going to be helping out DDD by laying on coaches from Reading Station to Thames Valley Park....(read more)