Tag Archive: sqlbits

SQLBits – What, Where, and Why

SQLBits is a unique SQL Server event in the United Kingdom, and even if you're not in the UK, there's some things you might find interesting about how it works. Thursday - Pre-Conference Sessions - for £350, you get in-depth training on one particular subject from one trainer.  Attendees like pre-con sessions when they need more ...

Read the full article

Jamie Thomson’s whistlestop tour of SSIS addins

At #SQLbits, Jamie Thomson (Blog - Twitter) demoed the following SSIS add-ins: Kimball SDC Trace File Source XMLify File Watcher Dynamic Data Flow Rank Transform Normaliser Twitter Compression XMLify Jamie find this useful when parsing error output from other SSIS steps, which often have several result sets with different columns.  XMLify dumps all of the data into a single XML file ...

Read the full article

Simon Sabin’s talk on query performance

At #SQLbits, Simon Sabin (Blog - Twitter) talked about car crash queries: queries that suddenly have bad performance out of nowhere, yet if you copy/paste them into SQL Server Management Studio, they run quickly.  The culprit is often parameter sniffing: the engine looks at the query and builds a plan, but if ...

Read the full article

Christian Bolton on SQL Server memory

At #SQLBits, I was quite excited to attend this session because of the presenter.  Christian Bolton of COEO (Blog - Twitter) was the head author on our upcoming book SQL Server 2008 Internals and Troubleshooting, and he's one of the only 8 Microsoft Certified Masters on SQL Server that work ...

Read the full article

Jasper Smith on SQL 2008 R2 DBA features

At SQLBits, MVP Jasper Smith of SQLDBATips.com held a session on what's newin SQL Server 2008 R2 for database administrators. Application and Multi-Server Management To illustrate the problem with server sprawl, Jasper gave some quick stats about a big enterprise.  Microsoft IT has around 5,000 SQL Server instances with 100,000 databases, averaging CPU utilization under ...

Read the full article

Sept 30-Oct 2 – SQLBits - York, UK - doing sessions on virtualization & storage.

Nov 8-11 - PASS Summit - Seattle, WA - doing sessions on virtualization & professional development.

More Upcoming Events