What is SQLpermissions? Idera’s SQLpermissions is a freeware tool for copying or moving logins and permissions settings across SQLservers. SQLpermissions automates the time consuming job of configuring logins and permissions on one server to match another by generating a customizable TSQL script to do this for you. SQLpermissions also offers the flexibility to move one [...]
Posts from ‘December, 2008’
Certifications
I’ve been on both sides of the fence on this subject and through my years of experience I’ve come to the conclusion that experience is ALWAYS looked upon with greater value then certifications but if you’re looking for an edge then having some hot initials behind your name is a good place to start. If [...]
Cycling Error Logs
Have you ever gone into an envrionment looking for a problem and when you go to check out the error log you find that it hasn’t been rolled over for months or longer? (So annoying). Anyways… as one of my monthly scheduled jobs I rollover the Error Log using the sp_cycle_errorlog command. USE [master] GO [...]
SQL Server 2008 Upgrade Reference Guide
486 pages of upgrading goodness. http://www.microsoft.com/downloads/thankyou.aspx?familyId=66d3e6f5-6902-4fdd-af75-9975aea5bea7&displayLang=en This looks like the all encompassing upgrade document for SQL Server 2008. Major points include: Preparing to Upgrade Developing an Upgrade Plan Post Upgrade Tasks Feature Changes Pretty crazy document but I can see it being a great resource when trying to put together checklists and plans for upgrading. [...]
