Editorials

Making New Year’s Resolutions for Your SQL Servers?

PowerPivot – At the SSWUG.ORG Free Expo for January!
Come to the January SSWUG.ORG Expo for SQL Server and PowerPivot! Donald Farmer will be presenting at this free event and will be providing in-depth information on what PowerPivot is all about, how you can use it, what it could mean for your company and a lot more. Make sure you get registered for the January Expo right away – and pass the word to others that will be interested as well – it will be a great event!

Making New Year’s Resolutions for Your SQL Servers?
If so, let me know! I’d love to know what you’re looking to enhance in your work with SQL Server. Here would be a quick look at mine:

– Provide better help for accidental DBAs. This has been a great deal of fun working with people that can’t work with SQL Server all the time for whatever reason. The leverage that can be had by doing the "right" things in a thoughtful manner has been cool to watch and I want to do a lot more of this.

– Be better at automating things like index defragmentation, forecasting. It seems like these types of things that are easiest to automate are also among the last to be automated. Probably because they’re easy to automate because they’re a well-defined process, so it’s easy to run them manually. But then you forget, or at least I do, to really go after it and do it. Sure, I put the jobs in place… sometimes. But most of the time it’s more of a checklist to look at things – rather than automate them getting done. I need to be better about that.

– Learn more about related technologies. Not just the MIcrosoft suite of tools or whatever that directly touch SQL Server, but also learn more about how other applications interact with SQL Server. I would really like to better learn what things to really dig into and cut open when you’re troubleshooting a third-party application. I think we can make big strides there in performance, security and so-on, even from outside the application.

So, what’s on your short list? What would you change about your work with SQL Server the coming year?

Email your database resolutions here.

Quick Question… Virtual Workshops
Would you rather see a next virtual workshop on …

– TSQL from the ground up for mere mortals
– Troubleshooting SQL Server
– Something else (what?)

Please email me your thoughts

Featured Article(s)
Beyond the Traditional Backup
With the reliability of disks and the cost of long term tape storage, one may ask the question if tape storage is in the future. Recently, I considered some options to the traditional backup methods.

Featured Script
dba3_fx_IsLeapYear_Article
— Modeling Date Logic II: Queries, Functions, Procedures for Business Date & Time Calculations — http://bitonthewire.wpengine.com/see… (read more)