Webcast Today – Avoiding a SharePoint Disaster
Whether you’ve already implemented SharePoint, or are only preparing to, backup and recovery should be a priority. Discover how to use SharePoint’s out of the box backup and restore capabilities to protect your data in case of calamity. This session will take a quick trip through the built in backup options available with SharePoint; suggest some tips, tricks, and best practices; and focus on some techniques concerning how to restore that data before disaster strikes. Presented by: CA Callahan
> Register Now
> Live 2/3/2010 at 12:00noon Pacific
Litigation to Protect Data?
Is the legal system able to protect our data? Can you imagine having laws that define what you can do with the information in your systems?
I can’t.
It’s not that I am *so* protective of my data, or so loose with the data in our systems, it’s that I can’t fathom how you could create meaningful regulation that could control or suggest control for how data is used. I think so many times when you work with information that you don’t even possibly know how it will be used until you find out the results from poking around. Are you really going to stop and make sure your poking around and pulling ad-hoc reports and such are in line with data use laws?
Sorry, I just can’t see it.
What I do see is a need to teach ethics for data management and use. Yes, it can be taught, and I think it’s something that needs to be taught because it’s not altogether obvious and clear. It’s like the original work to get privacy policies and compact privacy policies for web sites. It used to be a real challenge to help people deploy them, to put the right options in place and to accurately show how information on a given site is used. Now, it’s commonplace and I can’t tell you the last time we deployed a web site for us or a customer where a privacy policy wasn’t part of the picture.
It needs to be the same way with information storage, retrieval and use. We need to help people not only see the "rules" but the "why." Why is it important? What steps are OK, what steps aren’t?
I think it’s something that we need to work together to address and something that we can afford to spend a few minutes thinking through, even if it’s just to consider how you make information available.
Don’t Forget…
Don’t forget to drop unused databases on your SQL Server. It can be a help for performance to not have those unused databases hanging around, and you can also remove that information from your SQL Server and not have it hanging around for possible abuse. Archive the database, put it on a CD/DVD or tape, and get the database out of SQL Server . It’s always best to remove unused objects and access points on your server for security, performance and maintainability reasons alone.
Fully Understand SQL Server Indexing
Kalen Delaney will be presenting our next virtual workshop, all about SQL Server Indexes. You’ll learn about key design considerations as you determine where, and what types of indexes will best support your queries. You’ll also learn the value of unique indexes and included columns. You’ll find out about composite indexes, and how to determine the best indexes for your queries involving ANDs, ORs and JOINs. Last but not least, we’ll discuss best practices that you can put to use immediately as you review and update your designs to support the queries on your system.
When: Feb 12, 2010 at 9:00a Pacific
[Get More Information] or [Register Now]
Featured Article(s)
Undocumented SQL Server 2008 XML Stored Procedures
In this article, Alexander Chigrik looks at three undocumented XML stored procedures that shipped with SQL Server 2008.