Featured Article(s)
SharePoint file filtering beyond out-of-the-box
Whether for audit or to enforce policy, file filtering in SharePoint is an excellent feature. Out of the box, you can specify the list of files you want to be blocked; not really do any audit on already uploaded files. Also, if user renames file extension – SharePoint can`t really detect the actual file type that is used and allow for bad content to be uploaded. Here we`ll check out some other options that prevent your server from becoming a distribution point for bad content.
Featured Script
dba3_conditional_tablecheck_DesignProblems
This illustrates implementation issues not addressed in the article "An Elegant Solution to Drop a Table" see: (http://www.ss… (read more)
Webcast TOMORROW – register now
Database Recovery 101
Every DBA is required to maintain good backups of their systems. But what are your options for recovering the system once you do experience a failure? In this presentation youll learn how to restore various types of database backups, the impact the recovery process has on your system, and how to estimate downtime and time to recover. Presented by: Buck Woody
> Register Now
> Live date: 11/4/2009 at 12:00 Pacific
Question: Would you be interested?
We’re considering launching a new member service – office hours. A time to call in and ask questions, loosely based on a given SQL Server topic. Sometimes it’ll be me, sometimes other SQL Server folks with knowledge in a particular area, etc. You can call in, ask questions, show what you’re seeing and we can talk about possible solutions and what could be done to solve your particular problem or challenge. While I cannot guarantee a fix every single time, we’ll certainly do our best.
Is this something you think would be good? We’d have a different topic each week and you could come by the virtual office and lurk or ask questions or just see what’s up.
What do you think? Simple email links:
Click one, put any comments in the body of the email. Thanks!
SQL Server Migration Successes
In hearing from many of you about successes with migration to SQL Server 2008, it seems that the path to 2008 is pretty clear from 2005. The migration pain, if there is going to be some, is coming from 2000 of course, and mostly in the DTS package to SSIS arena.
Many have written in saying that applications getting certified under 2008 is a huge issue (mentioned before) but that internal testing shows that there aren’t really issues with those applications between 2005 and 2008, so if you’re not faint of heart, you could start your own testing. Of course your service agreements may prevent you from moving in a production environment, but if you can go back to your vendors and talk about what you’re seeing, good and bad, sometimes you can help the process along in getting the OK to move to the new release.
The other good thing several have mentioned is that the move has resulted in increasingly good management tools and capabilities, and that speed has improved as well. So, there are benefits in moving up. You can get some of the management tool upgrades by installing the 2008 toolset and using it to manage your servers. Speed, well, you’ll have to go the full installation route of course. There are additional management tools beyond the management studio updates, and many have mentioned that this has been a strong, but unexpected benefit of upgrading.
One thing that’s been missing – blood and guts in the streets stories of issues. I’ve not had a single report (!) of real problem updates. That’s pretty remarkable if you think about it. Yes, work is needed if you’re coming from DTS packages, but the core upgrades outside the DTS changes have been very solid.
Featured White Paper(s)
Meeting Compliance Objectives in SharePoint
In recent years, the business and political landscape has seen incredible change with regard to the rules and regulations gov… (read more)