Free SQL Server Expo Open for Registration
Our next free event – the SQL Server Expo – is open for registrations – just head to the site to reserve your spot. This Expo will feature the following presentations:
– Basics of administering databases for the layman, Tom Roush
– Best Practices, TJ Belt
– Optimizing Backup and Restore Performance, Thomas LaRock
This expo is focused on SQL Server administration-type tasks, so get your registration in for this free event.
[Get More Information Here] or [Register]
Featured Article(s)
To Enterprise or Not Enterprise (Part 2)
Do you know why you would recommend Enterprise Edition over Standard Editions of SQL Server? Do you know the selling points that you can use to justify the purchase of one edition over another? We look at database snapshots, database mirroring and new indexing features in this article.
Webcast: 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
Is There One Thing?
Is there one thing that you wish you’d known, that you would have applied to SQL Server if you had known about it? One thing that, as you’re going along with SQL Server, you find out "X", then do the head-slap and say to yourself "ack! If only I’d known that before!"
What’s that one thing for you? During the indexing workshop we did last week, we had several people talk about wishing they’d understood indexing with SQL Server better. Specifically, I’ve heard from several people that they wish they had known about the design considerations when working with SQL Server when it comes to indexes and figuring out the best candidates for indexes and so-on.
For me, it was learning about the performance impact (in a good way) of doing index maintenance.
Learning that defragmenting indexes could have such a profound impact on performance, and learning how straightforward it is to figure out if you need to take steps to defragment your indexes, was definitely a head-slap moment for me.
What was your moment? Is there more than one thing? Don’t list more than 2, but I’d sure love to hear about what surprised you that you wish you had known.