Get Social!
Twitter – Facebook SSWUG.ORG page
vWorkshop – Just a Couple of Days Away – Register Now!
SQL Server Performance – Presented by Stephen Wynkoop
I’ll be doing a virtual workshop THURSDAY – several hours on SQL Server performance. Find out about indexes, TSQL tips, monitoring and more. Check out the site for a more detailed outline – you can even get a certificate if you pass the quiz at the end! Just be sure to register now to save your spot. I’ll be doing the presentation, answering questions in chat and I’ll do my best to make sure you get the information you need.
[Get the outline] [Register for the workshop]
Featured Article(s)
SQL SERVER VS ORACLE: A Comparative Review-Part I
In Part I of this series we describe the general application level differences between Oracle and SQL Server. In Part II of the series we shall examine the differences that exist at deeper levels such as programming differences, clustering, security etc.
Webcast Weds:
End to End Database Development
How to manage the database Application Lifecycle. This session will discuss team-focused database development challenges, and will present tried and true methodologies for dealing with database development issues. This session is a must-attend for any database developer working in a team environment. Presented by: Ted Malone
> Register Now
> Live date: 11/18/2009 at 12:00 Pacific
On Automation and SQL Server
Last week I wrote about wondering what you thought about automation of certain things in SQL Server. The point was missed, I think, and I wanted to explain.
A BUNCH of you wrote in to say that automation was great, that you’ve already automated things in many cases, so of course it’s OK.
But that wasn’t really what I meant. 🙂 As a specific example – why do is there not an option that lets SQL Server just create the indexes it needs? Why do we have to perform maintenance on indexes? Could that be automatic? SQL Server has the ability to indicate where it has indexes missing, or indexes that are never used. Couldn’t it just take that next step and actually do something about it? If it’s able to re-org indexes and defragment them, why do I have to tell it to do so? Why is that not a normal background process for SQL Server?
Sure, I’m not a developer on the SQL Server team, I get that. I’m sure these are not simple things to do, especially given application constraints and issues that may arise from having these things making changes. But I’d sure love to have an option! It seems like there are a lot of systems out there that could benefit from automatic best practices, Perhaps this is Policies 2.0…
I could see a permissions-like grid of options – things to turn on and off for automation. Then also let me apply those settings with policies that I can roll out across my servers (and have defaults). Probably a pipe dream, but it’s MY dream and I think it could provide some great advantages to a whole host of DBAs.
Am I Crazy? What would YOU like to see, if anything? Email me, let me know…
Featured White Paper(s)
Protect your SharePoint Content: An Overview of SharePoint 2007 Disaster Recovery
SharePoint Disaster Recovery is more than just backing up your data and building extra hardware. Our new whitepaper "Protect … (read more)