[Watch] SelectViews SQL Server Show Here
Build Dashboards More Easily
Dashboards are the heart of understanding what information needs to be investigated further, how things are going and more – all at a glance. Building those dashboards can be really challenging, but you can make it a whole lot easier with the right tools. Check out Visual Mining’s NetCharts – it helps you with tools and lots of features that can get you really moving forward – with SQL Server, DB2, XML sources, Oracle and even MySQL. Get more information here.
SharePoint Feedback
I wanted to pass along a bit of the SharePoint feedback I’ve received – can’t really share it all with so many emails (100’s!), but there are some interesting feedback points.
Scott: "I would like to send my comments of show #97. I fall into a category that I know is out the but people do not seem the talk about, "The Catch All". I am the DBA, application development manager, application developer, security officer, BI specialist, application architect, server administrator above the OS.
As for SharePoint I am responsible for the install, maintenance, backups, training, and a user. SharePoint has become a solution for us to turn out fast applications on an enterprise scale. You want a calendar system for little or no cost in a small public enterprise, no problem WSS out of the box.
Even for development you now need some knowledge of SharePoint if your using Team Foundation Server for source control. That includes source control for your database objects is your using Visual Studio for Database Professionals. It is being part of your enterprise like it or not!"
Michael: "I just catching up to last week’s emails. Been busy implementing SharePoint on our Intranet and the first of our pilot schools. Last summer we implemented SharePoint for our Internet going live on July 1, 2007. Since then we have planned out the move to include our intranet, collaboration sites, and school web sites. The first of our school sites should go live later this week. The next six in our school site pilot will go live by June. The rest of our 170+ schools will go live next school year. Our current Internet site average 7,750 unique visits a day with almost 9,500 during weekdays.
So I’m very interested in seeing more SharePoint material."
Mary: "It would be nice to get SharePoint information from SSWUG since SharePoint is SQL Server dependent.
We have SharePoint here and upgrading to 2007. I’d like to see the pro’s, con’s and costs of storing everything in the database versus linking and managing content outside of the database. It looks much easier to store within SQL but I would wonder if performance would be the trade off. Is there a SharePoint/SQL archive tool from Microsoft yet that doesn’t cost extra?
The only gotcha that we have experienced with the install/configuration is the different collation for the install of SQL for SharePoint at the instance level (may not be able to share that instance with other shrink wrap app databases): [More Information here]
I [also] like the SharePoint Capacity Planning Tool (requires system center planning tool install as a prerequisite).
The other discussion point I would like to see covered is security/support for SharePoint — what role should the DBA have on the web/app since DBAs usually don’t have access to web/app servers. It will probably depend on the size of the company (DBA’s may wear more IT hats in smaller organizations), disaster recovery, archive, migration and patches that affect SharePoint and SQL."
Featured White Paper(s)
Deploying Microsoft® SQL Server in an iSCSI SAN
This Technical Report describes how to deploy SQL Server in an iSCSI SAN with PS Series storage arrays. It provides configura… (read more)
SQL Server Fragmentation Explained
As the data in Microsoft SQL Server tables changes, their indexes change. Over time, these indexes become fragmented. This fr… (read more)