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 UPDATE: This post is migrated from my old blog on 05/16/2010. SQL Server has versions, editions, service packs, compatibility levels and Internal versions. Most of the people know about the first 4 and if you are wondering about what is the database internal version then you should look at Database Version vs Database Compatibility Level post . . . → Read More: Database Internal version; Create Version and Current Version 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 As a dba, its important to know that the databases being monitored under our supervision are free from corruption and the below code helps in identifying the last ran clean DBCC CHECKDB date. This technique works only for SQL Server 2005 and above. USE tempdb 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? |
|||||
|
Copyright © 2010 Sankar Reddy, SQL Server Developer/DBA - All Rights Reserved      |
|||||
Popular posts