Free training is good, if it is on a special topic important for every DBA then better, if it is coming from an industry expert on the subject then much better, if it is an all day event then excellent, if it is from Mr.Denny then excellent * 2, if you can get all of the . . . → Read More: Free one day training on Storage and Virtualization with Mr.Denny
|
|||||
|
Few weeks ago, all of the MVP’s were given 3 Visual Studio 2010 Ultimate with MSDN activation cards to celebrate the launch of Visual Studio 2010 and .Net Framework 4. I wasn’t really sure how to make good use of them and wondering what’s the best way to share these cards. Arnie Rowland (Blog|Twitter) had a . . . → Read More: Free MSDN Ultimate Subscriptions for a good cause At-least 3 people [Aaron Bertand(Blog|Twitter), Michelle Ufford (Blog|Twitter), Aaron Alton (Blog|Twitter)] in the community have blogged about this topic already here, here and here and not sure if we need another post on this topic. But I thought this might help someone and brings something new hopefully! Having custom keyboard shortcuts is nothing new in Mangement Studio . . . → Read More: Another Managment Studio custom Keyboard shortcut post This post is participating in T-SQL Tuesday #005 hosted by Aaron Nelson (@sqlvariant). This is an exciting recurring blog post party invented by Adam Machanic (@adammachanic) few months ago, which gives good exposure to budding blog writers and happy to participate. Problem Although I don’t remember who asked this question in the forums but the user was surprised . . . → Read More: T-SQL Tuesday #005 : Who put my database offline? I have been very envious of my SQL friends on the other coast where there is so much activity happening with SQL Saturdays. In an impulse I almost tried to buy airline tickets to attend SQL Saturday#33 but the itinerary didn’t worked out for that weekend as the arrival time was around 10:30 am in Charlotte. . . . → Read More: SQL Saturday #44 is coming to California Upgrading SQL Server(s) from older version to newer version or even service pack upgrades are always risky. In fact changing any thing in production is always risky and each and every change should go thru a thorough change control process. Careful planning, preparation, execution and thorough validation are very important for any successful implementation. And these . . . → Read More: Stored SSIS packages disappeared after SP3 migration Short story: Corruption happens. Be prepared. Read Paul’s blog on CHECKDB-From-Every-Angle & Disaster Recovery, watch the excellent knowledge packed Corruption survival techniques video and practice the sample corrupt databases. Long story: Corruption happens and it can happen when you least expect it. There is no hiding from this, even if you are remotely responsible for maintaining and supporting a . . . → Read More: Lessons learned: Recovering from first ‘suspect’ database Update: This post is participating in the 4th installment of the T-SQL Tuesday hosted this time by Mike Walsh. One of the side affects of having Heaps in a system is the possibility of generating forwarded records. When reading data from a heap, Forwarded records (if they are present in a heap) can generate extra, random and . . . → Read More: How can I tell if a SQL Server system is affected by Forwarded records? Update: This post is participating in the 4th installment of the T-SQL Tuesday hosted this time by Mike Walsh .SQL Server 2005 came few years ago with lots of optimizations and in this post I will add some details on one of the lesser known IO enhancement that wasn’t present in previous versions. CHECKSUM was introduced as a PAGE_VERIFY option . . . → Read More: Transaction Log (block) CHECKSUM From SQL Server 2005 onwards, CHECKSUM is available as a PAGE_VERIFY option at the database level. All databases created in SQL Server 2005 & above will have CHECKSUM enabled by default. Even tempdb in SQL Server 2008 has this option enabled. It is recommended by MSFT to change the PAGE_VERIFY option of databases to CHECKSUM when migrating from . . . → Read More: Performance impact of using BACKUP CHECKSUM in SQL Server 2005/2008 |
|||||
|
Copyright © 2010 Sankar Reddy, SQL Server Developer/DBA - All Rights Reserved      |
|||||
Popular posts