Stephen Wynkoop
Demo: Capture perfmon counters to binary logs and at the same time capture SQL Profiler. Then you can load both into profiler and see both at the same time. Great for troubleshooting what might be causing a problem or what is happening at a particular point in time.
Popularity: 2% [?]
TJ Belt
http://tjaybelt.blogspot.com
http://www.twitter.com/tjaybelt
You are on-call, maybe middle of the night and you get a call and there’s a problem. What do you do?
Popularity: 2% [?]
Below are tips, links and tidbits from today’s sessions. Use at your own risk. 
Popularity: 1% [?]
So the SSWUG Fall 2009 Virtual Conference begins today. I’ve setup at home to hibernate for hours watching the live and pre-recorded sessions on a wide range of SQL Server and business intelligence topics. An extra LCD monitor brought home, the trackball mouse from the office, headphones and webcam. The kitchen is stocked for my “conference” meals and snacks thanks to my lovely bride. I am ready!
Oh yeah, the sessions. I almost forgot.
Popularity: 1% [?]
SQL Log Rescue – Undo for SQL Server.
Came across this product again today to help with a particular need. I’ve used Red Gate products before at another employer and loved them. However, I never realized the SQL LogRescue product. On top of that, it is a free tool. Read the rest of this entry »
Popularity: 4% [?]
Presenter: Erik Veerman
erik@solidq.com
In a Business Intelligence solution, the fact tables hold the core data that you are analyzing – facts (also called measures). Therefore, fact tables are a critical component to get right the first time. Poor fact table design will lead to poor performance and difficult calculations. This session dives into fact table and considers the basic column types, measure aggregation types, fact table types, and volume considerations. Read the rest of this entry »
Popularity: 4% [?]
Presenter: Erik Veerman
erik@solidq.com
Dimension Tables are one of the core components in a dimensional design and it is critical to design your dimension tables correctly in order to lay a solid foundation to a Business Intelligence system. This session dives into the dimension design techniques and considers the core components of a dimension table, surrogate keys, attributes, and hierarchies. In addition, we will consider advanced hierarchy types such as parent-child hierarchies, snowflake designs and unbalanced hierarchies. Finally, we will consider the best practices in tracking changes historically. Read the rest of this entry »
Popularity: 6% [?]
Presenter: Jeremy Lull
Jeremy@datarealized.com
DMV – Dynamic Management Views (and functions)
Popularity: 4% [?]
