Minnesota Sytem Center User Group

helping each other figure it all out

 
  • Increase font size
  • Default font size
  • Decrease font size
Home SCCM 2007 Related Posts SY35 SQL Performance Tips for SMS / SCCM Reporting Gurus

SY35 SQL Performance Tips for SMS / SCCM Reporting Gurus

E-mail Print PDF

John Nelson and I will be speaking on the first day of MMS if you're going!

Monday, April 28 4:30 PM - 5:45 PM, Veronese 2401B
Speaker(s): Brian Mason, John Nelson
Track(s): Systems Management
SessionType(s): Breakout
Products(s): Configuration Manager 2007, Microsoft SQL Server, SMS 2003


Brian Mason (MS MVP SMS) and John Nelson (www.number2blog.com) will show you how to speed SQL & web reports so that they don't melt your server, time out, or make your boss wonder if you know what you're doing. While Brian writes a few reports (with an SMS/SCCM focus), John will improve Brian's attempts (with a SQL focus). You'll get tips on how to find that data you're collecting quickly and present it in speedy web reports or pivot tables. You'll get tips on keeping SQL healthy and lean, and what to look for when building a new server. How will Wells Fargo install SQL for its 200K client infrastructure? From web reports to SQL Management studio to SMS/SCCM, let the Wells Fargo guys show you how they'd do it and answer any questions along the way.

 

Newsflash

Microsoft released SCCM 2007 SP1 yesterday. You can download it here: http://www.microsoft.com/downloads/details.aspx?FamilyID=5AAE62E8-4B7F-4AF7-BE01-AEFAA4BF059A&displaylang=en

They also released RC1 for Hyper-V: http://support.microsoft.com/kb/950049

And today I see IE 8 Beta 2 info:

Internet Explorer 8 Beta 2 Readiness Information

Ensuring your website is ready for Internet Explorer 8

Consistent with our efforts to promote further interoperability across the Web, Microsoft will be releasing Internet Explorer 8 to render content in its most standards-compliant way by default.  Giving top priority to Web standards interoperability allows us to help web developers and designers drive toward the ideal of “write once, run anywhere”, freeing up more time to innovate rather than modify content for different browsers.  This commitment also addresses several development and design pain points from previous Internet Explorer releases.

However, browsing with this default setting may cause content written for previous versions of Internet Explorer to display differently than intended.  This creates a call to action for site owners to ensure their content will continue to display seamlessly in Internet Explorer 8.  As such, we have provided a meta-tag usable on a per-page or per-site level to maintain backwards compatibility with Internet Explorer 7.  Adding this tag instructs Internet Explorer 8 to render content like it did in Internet Explorer 7, without requiring any additional changes.

We are encouraging site administrators to get their sites ready now for broad adoption of Internet Explorer 8, as there will be a beta release in the third quarter of this year targeted for all consumers.  To learn more and get started, please follow the step-by-step instructions located at the following link:  http://go.microsoft.com/fwlink/?LinkId=120024.

Additional Resources
The following links provide additional information you may find useful: