If you are looking for SQL Server training they there is no better place to start than a new company Technitrain Its been setup by a fellow MVP and SQLBits Organiser Chris Webb. Why this company rather than any others? Training based on real world experience by the best in the business. The key to Technitrain...

SQL Server is configured to use a lot of memory, but my query is slow and not using all the memory available and it is spilling the sort or the hash match operation to tempdb, how can you tune the configuration and the query? Memory allocating queries request memory based on estimation (ideal memory...

This zip file contains the files to support the PASS Advanced Reporting Services Precon. It includes The presentations All the demo reports for each section A SQL Server Management Studio Project for the SQL Scripts The 24hrs Of PASS project for implementing slicers in reporting services A .Net Project...

if you are looking to work with Analysis Services then you need to learn MDX and there is no better person to learn it from than Chris Webb Chris is a Microsoft MVP and a leading expert on MDX. He is the co-author of two books, "MDX Solutions" (second edition) and "Expert Cube Development...

Here are the files from my Advanced Reporting Services 24 Hours of PASS session on how to put slicers in reporting services. Here is a screen shot of what is possible. One filters the data (Excel style) and the other greys unselected data out (Crescent style) ps the files will be posted after the session...

I was in Denmark earlier this year speaking at Miracle Open World and I heard about a guy that had done a session the year before about the internals of PDF files. This year he was doing the one on MDF files. This was a must see, so I popped along. Mark S. Rasmussen is the guy in question. What he had...

Time for a quick reflection on my 5-day's training with SQLSkills, they have 4 weeks in their immersion training program, this was week 1: Internals & Performance held @ large Heathrow Hotel http://www.sqlskills.com/T_ImmersionInternalsDesign.asp So was the Course worth the Time and Money......

As I prepare to embark on my Immersion training week with Paul & Kimberly from SQLSkills , which is another one of the courses being offered in the UK this year, it seems that these invariably get full very quickly, so don't hang around or you will miss your opportunity to attend them I do know...

We’ve moved a few things around which has freed up some places on the Performance Monitoring and the Optimising BI Training Days at SQLBits 8 . SQL Server Performance Monitoring and Troubleshooting with Klaus Aschenbrenner It's Monday, 10:30am. You are just receiving an email that informs you that...