New SelecTViews Show!
Database applications and tablet devices, toasters (er, appliances), and the SQL Server Tip of the Day. Also, Wendy Pastrick, insider knowledge of your systems and other key things to consider.
[Watch the Show] (it’s free!)
More, smaller databases? Manage your checklists, our featured blog of the week for business intelligence…Also, the hotmail outage and SQL Server, 3rd party tools and more.
[Watch the Show]
Special Fireside Version: SelecTViews – SQL Server 2011 upcoming features, SQL Server tip, recent news and more.
[Watch the Show]
$$SWYNK$$
Featured Article(s)
Queries – Also for the Layman (Part 3 of 3)
Okay, so you’ve gotten your data into your database. Now how do you get it out? This session will take you through some real life situations on how to get that query to not only get you your information, but also do it so that it doesn’t kill your system when it runs, uses the indexes you’ve built into the system, get the bugs out of it (trust me, there will be bugs), and run this query on your production systems.
Featured White Paper(s)
Essential Performance Tools for SQL Server DBAS
Optimizing SQL Server performance can be a daunting task. Especially so for an increasing number of reluctant DBAs faced with… (read more)
Are Your Database Assets Covered
Many of us rely on hosting services for our failover strategies.These hosting services provide us with a great deal of confidence through redundant capabilities such as the use of a SAN, SAN replication, multiple internet paths, etc. All of these paths result in highly available systems. The SQL Azure service provided by Microsoft at one point excluded failover technologies such as backup and restore because their failover strategies are so reliable.
Does this mean that your Database Assets are covered? One article I read recently reminds us that, while our databases will be available online, the data assets contained are not necessarily protected. What about data corruption?
There are any number of causes of data corruption. Simply keeping your data online does not protect you from data corruption. What if your system data is attacked or incorrectly modified? At that point your redundancy assures that your data is consistently wrong, but will stay online.
Are you using a hosting service for redundancy purposes? If so, how are you managing this potential issue of data integrity? Is this a problem we are going to address more fully as the cloud continues to grow?
Drop me a note with your thoughts at btaylor@sswug.org.
Cheers,
Ben