Archive › Microsoft SQL

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 [...]

 

Comments ( 0 )

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 [...]

 

Comments ( 0 )

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 [...]

Comments ( 0 )