Webcast: The Balance of Powers, Understanding SharePoint Governance:
Is it an application? Is it a website? Is it a functional tool? No, look it up on the internet, it’s SharePoint! With most technologies users are provided with a "how to" manual and understand that complaints go to the IT department. Online collaboration powered by SharePoint doesn’t follow the same form of processes and procedures. We will explore how to create a governance plan that incorporates the needs of the organization (controls) and the user (ease of use).
Presented by: Adam Levithan
> Register Now
> Live date: 5/5/2010 at 12:00 Pacific
Featured Article(s)
EASY GUIDE TO GEOGRAPHY DATA TYPE IN SQL SERVER 2008
Geospatial data types geometry and geography are new additions in SQL Server 2008. This article shows in six easy steps how you may work with the geography data type in SQL Server 2008.
Full-Time SharePoint DBA/Admin Needed – Reader Feedback
(Send in your comments here)
So, the short answer appears to be, frankly, "yes." You probably do need a dedicated admin for your SharePoint installation, unless it’s overly small or not mission critical. More…
Tracy wrote "It is highly optimistic to say "but if you’re starting small, there shouldn’t be a requirement for a full-time admin". My experience with SharePoint has been it starts off small and in an incredibly short time it is a very large mission-critical application. Growth of sites, content types and rapid growth of content databases is the immediate challenge. I consider the alerts and worflows to be relatively insignificant tasks compared with trying to get a handle on the explosive growth of the number of sites and content.
If there is a DBA involved from the start, there can be the beginnings of governance over SharePoint, in cooperation with the business users, so the growth can be done in a more controlled manner. SharePoint without that input will be a disaster waiting to happen!"
Linda writes "In theory what you [suggest] may be true….However, in practice when working with a broad client base, I find that most small SQL Server shops will hire either rookie dbas or dbas who are still very green……In this case just learning everything they need to know to really keep up is a full time job for the first year or two….."
I have to say, with this feedback and so much of the other feedback I’ve received, it’s pretty clear that if you’ll be hosting a SharePoint installation in an even a relatively busy environment, you’re going to be looking at needing the full-time SharePoint admin. This provides for the oversight, the help, the proper setup and configuration and ongoing running of your systems. SharePoint is known to grow with adoption, and often in big ways. One of the big surprise messages for me in this discussion was that if you *don’t* have the planning and controls, you can do yourself significant damage as your installation matures, even in the medium range timeframe.
Proper planning and support now will really pay off, lack of it will quickly become an issue.
Webcast: Avoid Slow SSAS Queries: MDX Query Troubleshooting
Do you have SSAS queries that you feel should be faster? Multidimensional Expressions, or MDX, is the language used to work with Analysis Services. Similar to SQL for the relational engine, MDX is a language for queries and DDL statements on multidimensional cubes in Analysis Services. Troubleshooting slow MDX queries is often challenging because the level of support provided by the tools and the Analysis Services engine is not as mature as that found in the relational engine. This session covers the methods for examining slow queries using the SQL Profiler and Performance Monitor to determine the need for aggregations, caching problems, memory constraints, and so forth. Best practices for optimizing MDX will be examined, and various server properties will be discussed as necessary to help correct query issues. Attendees will leave armed with a practical approach to locating bottlenecks and strategies for speeding up queries.