Welcome to EMC Consulting Blogs

Browse by Tags

• BI
• Bitmask
• Community
• Data Warehousing
• Database Administration
• Database Development
• Fast Track Data Warehousing
• How It Works
• Monitoring
• New SQL Book
• Performance Tuning
• Replication
• Spatial Data
• SQL Server
• SQL Server 2005
• SQL Server 2008 R2
• SQL Server Internals
• SQLBITS
• SSIS
• Startup Parameters
• T-SQL
• UK SQL Server User Group

• Focus on Fast Track : My SQLBits VI Presentation

  For those of you interested in the principles of Fast Track I thought it’d be worth putting out my SQLBits VI presentation slide deck on my blog. It will of course be available from the SQLBits website in due course. In about 6 weeks time that will be Read More... Posted 25 April 2010 21:01 by James.Rowland-Jones | 0 Comments Filed under: SQL Server, SQL Server 2008, Fast Track Data Warehousing

• Focus on Fast Track : Understanding the –E Startup Parameter

  One of my focuses at the moment is the work that Microsoft have done with various hardware providers to deliver “Fast Track” – A reference architecture for SQL Server Data Warehousing that delivers predictable blistering performance on prescribed commodity Read More... Posted 25 April 2010 07:12 by James.Rowland-Jones | 5 Comments Filed under: SQL Server, SQL Server 2008, Data Warehousing, Fast Track Data Warehousing, Startup Parameters

• Enabling SQL Server Start-up Parameters – A Couple of Pitfalls

  In SQL Server there are a couple of ways to set startup parameters:  SQL Server Configuration Manager Command Prompt Net start Of these only one can be relied upon as a permanent option. That is the Configuration Manager.  I have been toying Read More... Posted 23 April 2010 08:55 by James.Rowland-Jones | 2 Comments Filed under: SQL Server, Database Administration, SQL Server 2008, SQL Server Internals, Fast Track Data Warehousing, Startup Parameters

• Last Call for SQLSocial London Event 16th March 2010 : Meet Itzik Ben-Gan, Greg Low, Davide Mauri & Bill Vaughn

  Simon Sabin has organised a SQLSocial event for this coming Tuesday. It’s at the Smithfield Tavern and will start at 18:30. It features some of the worlds most famous SQL Server celebrities in an informal setting. These guys are over in the UK for DevWeek Read More... Posted 14 March 2010 12:54 by James.Rowland-Jones | 0 Comments Filed under: SQL Server, Community, SQL Server 2008

• PASS Nederland Chapter Meeting 17/11/2009

  For those of you who aren’t aware I am currently working out of the Netherlands. That’s one of the joys of being  a consultant for a global organisation – you can literally end up anywhere! However, last night I had the please of speaking to the Read More... Posted 18 November 2009 07:38 by James.Rowland-Jones | 0 Comments Filed under: BI, SQLBITS, Community, SQL Server 2008, Data Warehousing

• SQLBits V : Friday Ticket Give-away!

  Andrew Fryer , Microsoft IT Pro evangelist extraordinaire, has 25 free tickets to give away for this Friday’s SQLBits SQL Server 2008 and R2 day!  Head over to his blog here to find out how you can claim a ticket and bag yourself a great geeky day Read More... Posted 16 November 2009 16:43 by James.Rowland-Jones | 2 Comments Filed under: SQL Server, Community, SQL Server 2008, SQL Server 2008 R2

• My new SQL 2008 Internals Book!!!

  I say my but really of course I mean “our” :o).  It’s been a fantastic experience and I have got to know some great people and had a lot of fun, stress heartache and now joy.  Big thanks to the team at Wrox, especially Ami and of course my fellow Read More... Posted 13 November 2009 11:15 by James.Rowland-Jones | 11 Comments Filed under: SQL Server 2008, New SQL Book

• SQLBits V is open for Business – 19th – 21st November

  It's that time of year again!  SQLBits registration is now open and this time it is going to be bigger and better than ever! For the first time SQLBits will be held during the week and at the week-end as we have grown the event to span three days. Read More... Posted 26 August 2009 16:38 by James.Rowland-Jones | 0 Comments Filed under: SQL Server, SQLBITS, Community, SQL Server 2008

• How To Tell: If connections to SQL Server are pooled (or not)

  Have you ever wondered if the applications connecting to your SQL Servers are using pooled connections or not?  If the answer is yes then read on.  However, if the answer is no then you should! Opening and closing connections is an expensive Read More... Posted 25 July 2009 21:33 by James.Rowland-Jones | 3 Comments Filed under: Database Development, SQL Server 2008, Performance Tuning, New SQL Book, How It Works, SQL Server Internals

• When Books Online Fails… Try the US Patent Office!

  As those of you who managed to get to the bottom of my recent deadlocking post may have seen I am busy writing a book with Christian Bolton , Justin Langford , Brent Ozar , Steve Wort, Cindy Gross and Jonathan Kehayias .  Right now I am working on Read More... Posted 19 July 2009 18:30 by James.Rowland-Jones | 0 Comments Filed under: SQL Server, SQL Server 2008, Performance Tuning, Monitoring