Accidental DBA Workshop – Register Now!
This workshop, by Microsoft SQL Server MVP Stephen Wynkoop will explore what you need to know about running your SQL Server systems. Built specifically for you if you’re looking to get your arms around your servers and managing them going forward, it’s all here.
[Find out More Here]
[Get The Workshop Outline]
[Register]
Featured Script
dba3_UseFullyQualifiedObjectNames_ToCallStoredProcedures_InOtherDbs_Demo
demo: Use fully qualified object names to call stored procedures (in other DBs) from within a stored procedure… (read more)
SQL Query Tuning – With Great Insight
When you tune, in so many cases, it’s like pushing on a string. You push a little, it pokes out in one location, straighten it out, push some more, pops out somewhere else. It can be very challenging to tune and tweak your systems to effectively. The solid approach is to tune base on complete workloads – across potentially millions of queries. That’s where Qure from DBSophic comes in. By paying attention to the workload and comparing it to a copy of your production database, it’s able to really offer solid guidance. Check it out here – it’s something that can really help make query tuning a much less danting task.
Free Virtual Expo: SharePoint – 4 Great Sessions
Register here today – The May SharePoint Expo from SSWUG.ORG is a free event, open to all. The expo will include sessions on SharePoint from top-name presenters. We’ve pulled together the best of the community-rated sessions and are presenting them here in the expo, just register, attend and learn. Check out the sessions here.
May 28, 2010 starting at 9a Pacific.
See the sessions, or register by clicking here.
Important Tip for Backups
As you create your backup models, put in place software, figure out your backup approach and so-on, I wanted to suggest a few other things to add to your plan.
First, the operating system. Make sure when you set up your backup process that you also note and store the version of the operating system in use at the time of the backup. If you don’t, and if you had to restore your system down the road, it’s possible that you might find yourself in the situation where you have compatibility issues with the restore because the OS is a different version than when you backed things up.
Next, for the same reasons as your OS backup, make sure you’re noting and backing up the SQL Server software itself. You may need to restore later and you want to make sure you have the right version of SQL Server to restore to as you bring up your systems.
Add to these any extra utilities, encryption keys, settings and such – you’ll be well on your way to having a great approach to backing up your environment. This doesn’t mean you necessarily have to backup these things each and every time you do a database backup, rather consider having a log of the date of your OS updates – then be sure to store the OS backups, SQL Server software backups, etc. with a date notation.
It will help you more quickly and confidently restore your environment if you need to do so.