Moving From MSDN To WordPress :: New Blog URL

“For everything you have missed, you have gained something else, and for everything you gain, you lose something else.” – Ralph Waldo Emerson After witnessing 3 SQL Server releases (Katmai, KJ and Denali “which is yet to be RTMed”) and resolving hundreds of SQL Server issue, I’ve now decide to move ahead to a new…

0

SQL Server 2005 SP4 RTM Release………what it means with RTM or without RTM?

  SQL Server 2005 Service Pack 4 (latest SP in SQL 2005) was publically released on 18-Dec-2010. This time the word RTM suffixed to this patch name. This is 1st time that SQL Release team has added “RTM” to a SQL Service Pack release and to a degree this is created some confusion……..what is means…

3

Using Bulk Logged recovery model for Bulk Operations will Reduce the size of Transaction log backups – Myths & Truths

  It’s has been couple of years for me working on SQL Server and I keep coming across various SQL Server misconceptions (or say a DBA Myth). In this specific post I’ll demystify a common DBA myth around log-shipping: "In a log shipping setup, to have smaller size T-log log backups being shipped to secondary,…

0

SQL Server Denali – AlwaysON (HADR): Step-by-Setup setup guide

  You may have seen the announcement of release SQL Server Code-Named “Denali” in recent PASS summit (featured in Ted Kummert’s keynote). Even morem “Denali” Community Technology Preview 1 (CTP1) is available for download here  “Denali” release have several new and improved components listed here. Being a SQL Engine guy, I particularly got excited with…

0

Microsoft Codename Atlanta::How to get in there….

  To begin with, lets first get the basics: What is Atlanta? Microsoft Codename Atlanta (http://beta.microsoftatlanta.com) is an online service that analyzes installations of Microsoft SQL Server 2008 (and later versions) and provides proactive alerts to help you avoid system downtime and follow best practices with regard to configuration and usage. Do I (you) need…

6

Create a SQL Server Database on a network shared drive

  Hello All, Sometime back, I have written blog post on ‘Backing-up SQL Server Database on a network shared drive’. This can be found here. I have received numerous queries on an another related topic i.e. ‘How to Create a SQL Server Database on a network shared drive’. It took sometime (a brand new SQL…

3

TRANSACTION LOG BACKUP and RESTORE SEQUENCE: Myths & Truths

  Hi Guys In a recent issue with a customer, I came across a strange SQL belief (or say a DBA Myth) around SQL Server Transaction Logs Backup/Restore. Let me explain you what was the scenario and then let’s try attempting to break the myth with real testing. SCENERIO: -    Customer is taking FULL and…

2

SQL Server – Missing Performance Counters: A consolidated list of known issues

Technorati Tags: Performance Counter Missing SQL Server performance counters missing!! Past few hours been crazy one, breaking my head on a ‘Missing Performance Counters’ and now since this is resolved, I want to now off-load every bit of this issue from my brain so thought blogging it 🙂 Issue: A customer is having 24×7 PERFMON…

1