SQL Server

Discover Cloud Intelligence & BI Automation with SQL Server and CloudOlap (Kevin Ashley)

Thursday, April 8, 2010, 6:00 PM to 8:30 PM We will cover typical SQL Server 2008 business intelligence tasks, and see how business intelligence may be automated with tools and middleware such as RapidOlap throughout the enterprise. We will look at the data warehouse structure, datamarts, automation and load optimization of business intelligence in the [...]

Read the full article →

Effective Database Administration with a Central Repository (Linchi Shea)

Thursday, March 11, 2010, 6:00 PM to 8:30 PM Many database administrative tasks, such as monitoring, capacity planning, policy enforcement, best practice checking, are essentially the same across all the databases and the servers. Many more tasks are at an aggregate level, requiring data from individual databases across your enterprise. They include various reporting tasks, [...]

Read the full article →

Business Intelligence and the 2009 Microsoft PDC (Christian Holslin)

Thursday, February 11, 2010, 6:00 PM to 8:30 PM Christian Holslin attended the Microsoft 2009 Professional Developers Conference last year in November and learned a great deal about the current business intelligence features in SQL Server 2008 and some of the up-and-coming features in R2. This session seeks to educate its audience about the breadth [...]

Read the full article →

Designing SQL Server Indexes for Query Performance (Daniel Buskirk)

Thursday, January 14, 2010, 6:00 PM to 8:30 PM Indexes are your “silver bullet” for good query performance, but there are many tricks and traps. We’ll look at the physical structure of an SQL Server index and how the optimizer decides to use, or not use, a particular index for a particular query. With that [...]

Read the full article →

Self-Service Business Intelligence with Microsoft Gemini (Andrew Brust)

Thursday, October 8, 2009, 6:00 PM to 9:00 PM Ever wonder why there’s no “light” version of SQL Server Analysis Services (SSAS)?  Find yourself wishing that SSAS offered an in-memory operation model akin to some of its competitors?  And why are OLAP cubes nearly impossible for end-users to build while comparable capabilities have existed for [...]

Read the full article →

Next Entries →