Chris Shaw’s vWorkshop – Tuesday Aug 18
Be sure to get registered to save your spot!
SQL Server 911 – what you really need to know about SQL Server backup, recovery, disaster recovery. This is an in-depth workshop on all of the things you’ll want to pay attention to, and what to do if things go wrong on the restore process. This is an intense vWorkshop – just take a look at the outlineon the site for more information.
[Register Here] or [Get the course outline and overview]
Featured Article(s)
Oracle Change Data Capture Step By Step Asynchronous Distributed HotLog — Part 4
Oracle Change Data Capture Step By Step Asynchronous Distributed HotLog — Part 4
SSWUG Fall vConference – HUGE Savings until 8/15 (Tomorrow)
Extreme early-bird registration savings on the Fall vConference are available now. They end on Saturday, but you can get access to the entire conference – more than 75 sessions, live tracks (each day) SQL Server, Business Intelligence information and more. You get access to the entire conference for price. We’ve removed the disciplines and opened it up for areas. You can get a lot more information here, at the site.
[ Register Here ] or check out the vConference details here at the site. All-new sessions, all new content, the live track, the return of the Chris and Steve show and much more.
New SelectViews Show Available
Chris Shaw, Stephen Wynkoop explore the top 10 SQL Server scripts that you simply must know about. Learn about scripts, why these particular scripts are great and where they are found.
[Watch the Show Here]
Previously:
[Watch Here] (Part 2) Stephen Wynkoop and Chris Shaw talk about top SQL Server Performance Tips. Part 2 of 2 – things you can try, things you should know about, tips for your SQL Server.
[Watch Here] (Part 1) Stephen Wynkoop and Chris Shaw talk about top SQL Server Performance Tips
[Watch Here] 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?
Does the XML Ruling Against Microsoft Have Impact on SQL Server?
It’s not clear whether that’s the case. Whether "custom XML" is something that is simply stored by SQL Server or is processed by SQL Server, I have to wonder if support for it will extend to SQL Server and be impacted by the recent ruling. I think probably that the case is that SQL Server is just storing information, not necessarily processing it, but I have seen a few people talking about how this could impact other products outside of simply Word. Here’s more information about the XML issue Microsoft is facing. I’m betting it’s not going to impact SQL Server, but we’ll have to see how both the ruling and the appeals process are handled.
SQL Server 2008 R2
I had a great call, demonstration and discussion with Microsoft going over key features, updates and upgrades on the new SQL Server 2008 release (R2). I have to say that it’s really quite impressive what they’re doing for standardizing server farm management and application of policies to your servers. I suppose this is the feature area that I first latch onto because it seems like something that can have a huge impact on the typical SQL Server installation. It’s challenging to standardize and keep track of settings and options on multiple servers with today’s native tools. You can do it, sure. But application and monitoring of policies can be a drag.
With the new release, you’ll be able to check for policy compliance, then drill down into a problem area to see what’s up. You can do this for groups of servers and you can apply policies and controls across those groupings. You can also declare exceptions to your policies (perhaps allocating more disk space or adjusting threshholds, for example) and see trending information about your systems. Pretty slick.
The preview information is out – and you can get a lot more information on the R2 site, here. We’ll be working with it here, as well and will surely keep you posted on these and other new abilities.
Featured White Paper(s)
SQL Server Database Backup and Restore Planning
Whether a business is small, medium or large business, it must have a well-written plan for backing up the servers. Planning … (read more)