DBASchool – In-Person Class for Every Day DBAs
I’ll be teaching a 3-day course here at the offices of SSWUG.ORG – and we’re already 1/3 full! If you’re interested in attending, I’d love to work with you, but please do let us know ASAP. Find out more about the course at the site and you can register to save your spot as well. It’s an EXCELLENT course for the Accidental DBA and those looking for a refresher as well. We’ll be doing hands-on labs, very interactive presentations and we’ll make sure you can apply the things we cover to your own systems immediately. The price is even excellent!
[Get More Information] or [Register Here]
Webcast Tomorrow
Securing Your SQL Servers From Attack
This presentation introduces a new mechanism in SQL Server 2008 that can report on and enforce server states, using Policy Based Management. You will learn how this feature works, where you can apply it, and how it can save you time in managing your systems. You’ll learn to run a compliance report across your SQL Server 2000, 2005 and 2008 systems and act on that report to find databases that are not backed up, naming standards that are not enforced and more.
Presented by: Sarah Barela
> Register Now
> Live date: 2/17/2010 at 12:00 Pacific
Things We Wished We’d Known
Several people wrote in with their items that they wish they had known when they started working with SQL Server. I wanted to pass along this first batch – perhaps there’s an idea or three here that will give you a couple of things to work through…
– "Performance Counters to watch – what counters should be watched on an ongoing basis and what are most helpful if things are going wrong (typically performance-wise) on the server? Having to learn what those are during a problem is not my idea of fun."
– "Maintenance Plans – they have an option to automatically backup all user databases. I wish I knew that early-on so I wouldn’t have missed several databases created by users after I set up backups."
– "I do wish I had known that indexes weren’t automatic!" (Believe it or not, I hear this from developers very often)
What do you wish you had known? Drop me a note – let me know.
Featured Script
Table Size Listing
Listing of all the user tables in the database by size desc… (read more)