2 Days Left to Register
Chris Shaw – SQL Server 911 – In-depth (4 hrs!) virtual workshop
You can find out all you need to know about disaster recovery planning, what to do when things go wrong on restores, your options and best practices. There’s even a certificate option on successful completion of the course quiz.
[ Register Here ] – Tuesday, July 21 at 9:00a Pacific
SSWUG.ORG Summer vConference – July 21, 22, 23
This ain’t your father’s webcast. This is 120 sessions on SQL Server, Business Intelligence, .NET Development and SharePoint. See the speakers, their demonstrations and much more. Get transcripts, download slides, re-watch sessions on-demand and a whole lot more.
[ Register Here ]
SQL Restore Controller
Are you relying upon SQL backups to protect your SharePoint content? Then how would you like a FREE tool that enables full-fidelity, item-level restores from these backups? Yes that’s right…free. Download AvePoint’s free SQL Restore Controller today, and avoid the hassle of restoring your entire database just to restore a single SharePoint item.
[ Get your copy here ]
Featured Article(s)
All you need for using XML Storage in SQL server 2005
All you need for using XML Storage in SQL server 2005
SSWUG.ORG SelectViews SQL Server Show
vConference Session Sample: Thomas LaRock SQL Server 2008 Maintenance Plans. Learn about the ins and outs of maintenance plans in SQL Server 2008 – what do you really need to know?
[Watch the Show Here]
[Register for the vConference]
Previously:
The show today features RAID and Defrag tips, backup optimization with filegroups, baseline stats and industry news. Also, find out about virtual learning opportunities, the SQL tip, the developer/AJAX thoughts and much more.
[Watch the Show Here]
SQL Azure is Getting Real
There has been a lot more information of late coming out about SQL Server in the cloud, or SQL Azure. There are clear pieces in place now show how you’ll connect and use SQL Azure – and how it will scale and support the concept of "pay as you grow" type implementations. It’s intriguing to me that they talk about query hours as a measure of usage.
I think as we go forward into this we’ll probably bounce around a bit on billing models and the like. At least I hope that’s the case. One side effect of this is that I think design is going to play a more major role as databases are deployed. I mean, really – if you can impact your bill by having a more properly designed database, one that can retrieve information more quickly because of the right relationships and indexing and such – aren’t you going to find value in doing that? So many times people talk about the low cost of computers and disk space and relate that to the lowered need for well-thought-out design of databases.
Hap-hazard databases will simply be more expensive. They’ll potentially take up more disk space (more $$) and will require more processing time to work with (more $$). Perhaps as these new environments are made available, they’ll also deliver on tools that make it possible to see suggestions, perhaps even auto-tuning at least the access methods for applications. I’ve never really understood why SQL Server can recommend and recognize the need for indexes, but not manage them for me. Perhaps this will make the case that they need to deliver on tools that will make these systems as efficient as possible and show the customers real value in having the types of best practices in place that could make a meaningful performance, query and disk space requirement difference.
I don’t expect these tools to go modifying tables and schemas in the sense of rebuilding infrastructure, but it would be nice if a "better" way were calculated, I could get notification of that so I could go test and see what the results might be. Could be quite cool.
I’m not suggesting that I know anything you may not know – just that this could have potential, either as a third-party tool or as a tool offered with the overall cloud environment. I think things like this would be more expected of a Microsoft environment "out there" than an Amazon environment – just because of history and background of the companies (I could be wrong here). Good food for thought though!
Featured White Paper(s)
WINDOWS SERVER DISASTER RECOVERY
Windows Server applications are often mission critical. The impact of natural, random and man-made disasters on these applica… (read more)