Quest are offering a free DVD containing 8 training sessions from the following well respected presenters: Kevin Kline Blog|Twitter Brent Ozar Blog|Twitter Ari Wiel Twitter The closing date for applications is 30th September 2010, however they will only have a certain amount in stock so get in there quick. To register for your free copy […]
There was a time when it was concievable for somebody to know all about SQL Server, these days with the advent of DTS and subsequently SSIS there is a need to know about ETL processes. Of course an ETL process is pointless on it’s own, it by definition has to have a destination and seeing as this is SQL Server it will 95% of the time end up being consumed by Analysis Services. Add on to that all the new functionality in the database engine, new data types and CLR Integration and there is a whole world of things to learn.
This morning I was writing a script to identify some stored procedures that I felt may benefit from tuning as part of this script I referenced the very useful DMV sys.dm_exec_procedure_stats. (I will post the script later) If you have not used this DMV before I suggest that you take a look in BOL as it […]