I’ve been away from the blog far too long! I logged back in after four months and found comments waiting, updates to perform and a host of other things to take care of. Now, it’s time to get back to blogging. The reason I’ve been away for all this time is I’ve been working with…
Changing Job and Database Owners to SA
One of the services we’re trying to flesh out a bit more over at Hive Mind is our standard health check and resolution script. Every DBA has his or her own set of scripts they carry around, either in a file, or a link to where to find it online. Merging the best of all…
Getting Back to Blogging
I’m sure you’ve noticed by now my job posting blogs have taken over. They were supposed to fill in on Tuesdays and Thursdays while I was supposed to continue blogging on Monday, Wednesday, and Friday. That hasn’t worked out. Late last year I began building Hive Mind Consulting. That’s taken up a lot of time!…
Why should we migrate our ETL from DTS to SSIS?
I know I just threw a bunch of technical acronyms at you at once, but this is a topic that comes up more and more as people finally move off of SQL 2000 and onto a currently supported version. Companies making this move will have a lot of old Data Transformation Service (DTS) packages that…
HELP! My Log Drive is Full!
A few weeks back I received a call from a client who isn’t running one of our monitoring solutions. “Help! ServerX is not responding! I can’t even connect to it via RDP.” This machine happens to be a virtual machine, so I ask if he can log in to the host machine, and check for…
DATEPART(WK, DateColumn)
It’s been a busy month since my last post. Moving from contracting to consulting requires a more work that I’d thought at first. In looking over the past few months I’ve built a few new queries that I haven’t built before. This first one comes from a report built for a client. The request came…
Upgrade SQL Server
One of the most difficult projects to undertake as a DBA is upgrading your SQL Server from one version to another. The biggest reason that it’s so difficult is the lack of planning and testing before during and after the migration. With proper planning, everyone involved with the migration from the DBA, to the programmers,…
World Backup Day
This past Saturday was World Backup Day, It’s not an actual government recognized holiday, but as a DBA you should start celebrating it. Maybe celebrate isn’t the right word for what you might want to do on WBD. If you have a copy of the SQL PASS Summit 2011 DVDs, check out Grant Fritchey’s Lightning…
SQL203 — Indexes can help|hurt
Yeah, I used a pipe in my title. That’s because indexes can help some things, but hurt others. The brief of it is indexing helps reads, but comes at a cost: your inserts, updates and deletes are going to take longer. That’s because as you change your data, you’re going to have to update the…
SQL 201 – APPLY
Let’s finish up with the SQL 210 series today with the APPLY operator. After you learn how to create your own functions, you’re going to want to use them in new and interesting ways. Learning to use APPLY is like learning to use joins for functions. It let’s you run the function against multiple rows…