Webcast: SQL Server Reports and OLAP cubes in SharePoint
Quickly see how easy it is to use SSRS web part to display SSRS reports on SharePoint pages. Quickly see how to display an OLAP cube KPI on SharePoint page by using the included web part. PResented by: Lynn Langit
> Register Now – Webcast date: 7/1/2009 at 12:00pm Noon Pacific
Featured Article(s)
JQuery Accessing the Client Generated ID of ASP.NET Controls
Ok, so we all know that ASP.NET controls, or any control for that matter with the runat=server tag, will generate a funky client ID when rendered on the page. Sometimes, we need to get at those controls via some client side javascript so that we may manipulate their properties or simply get/set their values.
Watch Show: Resume Tips, Small Business Thoughts – SQL Server
I put together some tips from the resumes I’ve been reviewing and some ideas about what people are starting to really ask frequently about in terms of setting up your own business. This is a very focused show to address some fo the mass of emails we’ve been getting on this topic. Here’s the description:
"Heavy emphasis on resumes, setting up your own business and things that help out in both areas today. The show includes resume tips, business tips, training options and a lot more – all focused around SQL Server of course."
[Watch the Show Here]
Previously: SelectViews Show – Special Edition!
I posted this show previously in mistake – it’s live now!
(135) SelectViews: Special – Optimizing Backup and Restore Performance – Thomas LaRock
[Watch the Show Here]
Final Performance Tuning Approach Feedback
Derrick wrote in with some additional thoughts: "Performance Management is typically at the top of everyone’s priority and the bottom of most everyone’s understanding. In my recent experience, most software is 3rd party vendor. Systems were not performing well and at first it was our SAN, then it was our server. So after a total replacement/upgrade of our SAN(needed, but not cause) and a complete rebuild of the server(completely unneeded), processes still are not completing on time. While the correct hardware architecture is important, a poorly designed database/app is still poor. A well designed db/app will still perform on less than perfect hardware and will typically fly on state of the art hardware. In my experience, 70-80% of performance issues are due to poorly written queries/processes. For example, one of our vendors apps was running from 1am until 2:30 or 3pm providing us nothing. After reviewing their process and making some index and data adjustments the ETL piece went from 1am to 7am to 1am to 1:50 on the worst day. The rest of the processes now completes by 6:30 am on most days now. This is a function of vendor software, written for the masses not just us."
Timothy wrote: "The best way to tackle performance issues is first to measure the performance so that you know what the problem is. Only after you understand the problem can you determine whether to “tune it” or to “throw hardware at it”. Over the past few years I have found that there is almost always some room for improvement in the performance of your database. Most tuning can be done relatively quickly and at little cost. Conversely adding hardware can often be very expensive and slow to implement due to the planning that is usually involved. Hopefully, you have a diligent and professional DBA who monitors the database performance on a regular basis and is able to forecast and predict when new hardware is required."
Featured White Paper(s)
Building High-Performance Database Systems with EMC Storage Technology and Microsoft SQL Server 2005
In this white paper, you’ll read about Microsoft SQL Server 2005 Enterprise Edition, which incorporates powerful data managem… (read more)
Getting Back to Business: Speed of Recovery for Microsoft Exchange Begins with Adequate Levels of Protection
This whitepaper takes a close look at the impact of e-mail downtime on today’s businesses and highlights ways to meet strict … (read more)