blogs.conchango.com

Browse by Tags

• Agile
• Availability
• Community
• Database Administration
• Database Development
• Database Unit Test
• Datadude
• Enterprise Edition
• Security
• sp2
• SQL Server 2000
• SQL Server 2008
• SQLBITS
• Team Edition for Database Professionals
• Upgrading SQL Server

• SQL Security Patch Build is CU6+ but not quite CU7

  So as suspected when I installed the new Security patch released by Microsoft for SQL 2005 sp2 that I mentioned this morning my build number has indeed shot up to 3233.  This places me somewhere between CU6 and CU7. Build 9.00.3228 was CU6 and 9.00.3239 Read More... Posted 10 July 2008 11:40 by James.Rowland-Jones | 4 Comments Filed under: SQL Server 2005, sp2, SQL Server, Security

• SQL Server and Windows Security patch posted

  And so the great run comes to an end... For the full details of this incident please click here . N.B. This also affects Windows. However this is released under a different KB article. For the SQL 2005 sp2 KB article look at this link http://support.microsoft.com/kb/948108 Read More... Posted 10 July 2008 09:33 by James.Rowland-Jones | 2 Comments Filed under: SQL Server 2005, sp2, SQL Server, Security

• SQLBits III Session submission is open

  Not a lot more to say about this other than... HURRY.  You only have till the 4th July to get those abstracts written and your sessions submitted. SQLBits is a really great community event and this one is going to be the biggest ever.  We are Read More... Posted 24 June 2008 09:44 by James.Rowland-Jones | 1 Comments Filed under: SQL Server 2005, SQL Server, SQLBITS, Community, SQL Server 2008

• SQL2K5 Enterprise Edition Mini Feature 2 : Ramp up

  This one is a bit surprising. Assume you have a cold SQL Server which you have just re-booted.  The buffer cache is empty and lots of I/O requests are going to be physical. Boo! Hiss!  Down with physical I/O. Well help is at hand (if you are Read More... Posted 16 March 2008 20:41 by James.Rowland-Jones | 2 Comments Filed under: SQL Server 2005, SQL Server, Database Administration, Enterprise Edition

• SQL2K5 Enterprise Edition Mini Feature 1 : -E Startup Option

  Are you using multiple files? Are you set up for proportional fill? Is it a warehouse?  Are you concerned about extent fragmentation? You should be.  Extent fragmentation upsets your lovely read-ahead and results in smaller I/O. Let me explain.  Read More... Posted 16 March 2008 20:38 by James.Rowland-Jones | 1 Comments Filed under: SQL Server 2005, SQL Server, Database Administration, Enterprise Edition

• SQL2K5 Enterprise Edition Mini Features

  I thought it might be fun to do series of posts on features that are exclusive to enterprise edition but that aren't significant enough in their own right to make it on to the big ticket list .  Sometimes people balk at shelling out for SQL Server Read More... Posted 16 March 2008 20:37 by James.Rowland-Jones | 0 Comments Filed under: SQL Server 2005, SQL Server, Database Administration, Enterprise Edition

• Using SQL 2000? Using Availability features? Then read on...

  Whilst at SQLBits I heard a rather shocking statement: Over 80% of the worlds SQL Server instances are still using SQL Server 2000. I say statement because I have had a little trawl round the web and I couldn't find anything to back this number up (or Read More... Posted 06 March 2008 06:55 by James.Rowland-Jones | 2 Comments Filed under: SQL Server 2005, Upgrading SQL Server, SQL Server, Database Administration, SQL Server 2000, Availability

• SQLBITS II Birmingham 2008 - Over and out

  Saturday March 01 2008 was the second SQLBits conference. This is not an ordinary conference - it's a community conference created by some of the UK's leading SQL Server practitioners. Tony , Simon , Allan , Darren , Martin & Chris put an amazing Read More... Posted 04 March 2008 09:41 by James.Rowland-Jones | 0 Comments Filed under: SQL Server 2005, SQL Server, Database Administration, SQLBITS Attachment(s): IO IO Its off to disk we go.zip

• DB Pro: New Database Unit Testing Article on MSDN

  I found this new article written by Sachin Rekhi on Database Unit Testing with Team Edition for Database Professionals. I think it's an excellent read. The only thing I don't think it covers is what is not included in the product. The most notable piece Read More... Posted 03 May 2007 09:12 by James.Rowland-Jones | 0 Comments Filed under: SQL Server 2005, Database Development, Team Edition for Database Professionals, Database Unit Test, SQL Server, Datadude

• NOT FOR REPLICATION Database Unit Tests

  I recently put up a post with a unit test for check constraints validating all were defined with the NOT FOR REPLICATION option. I thought it might be helpful to put up a post with tests for all the other object types that can have this option set. select Read More... Posted 02 May 2007 15:40 by James.Rowland-Jones | 0 Comments Filed under: SQL Server 2005, Database Development, Team Edition for Database Professionals, SQL Server, Datadude

• SQL Server Service Accounts - Best Practices and Deployment Considerations

  We have recently had an internal discussion on service accounts predominantly on the subject of whether it is better to have one service account for sql server that is used in all environments or whether separate accounts should be used in each environment. Read More... Posted 02 May 2007 13:57 by James.Rowland-Jones | 0 Comments Filed under: SQL Server 2005, SQL Server, Database Administration

• Using SQL Assertions for Database Unit Testing

  Recently I had a need to create some unit tests for a change to the database that was under development. I needed to change the database so that the NOT FOR REPLICATION option was set on all keys, constraints, indexes and triggers. Following an agile Read More... Posted 01 May 2007 20:22 by James.Rowland-Jones | 3 Comments Filed under: SQL Server 2005, Database Development, Agile, Team Edition for Database Professionals, Database Unit Test, SQL Server, Datadude