Archive for the ‘SQL’ Category

Changes to SQL Server virtualization licensing

May 13, 2010

If you are planning on virtualizing SQL 2008 then this is a must read.

Basically this change is to the number of instances you are allowed.

http://virtualization.info/en/news/2010/05/microsoft-changes-sql-server-virtualization-licensing.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+Virtualization_info+%28virtualization.info%29

Posted in Microsoft, SQL | Leave a Comment »

Interesting issue with TCP offloading and SQL

February 24, 2010

Nothing conclusive was found but you might want to try disabling tcp offload when troubleshooting delays.

http://blogs.msdn.com/psssql/archive/2010/02/21/tcp-offloading-again.aspx

Posted in Microsoft, SQL, Windows | Leave a Comment »

Best Practices for a SQL DBA

February 3, 2010

I thought this was a really good checklist of items you should be doing on a day-to-day basis as a SQL DBA to keep your environment healthy.  It also has some great notes on steps to take before upgrades, installation, and some security bullet points.  A great list, check it out.

http://www.simple-talk.com/sql/database-administration/brads-sure-dba-checklist/

Posted in Microsoft, SQL | Leave a Comment »