Just few days gone since our last Chennai SQL Server User Group meet. This is the right time to choose my presentation topics for coming months.
Lots of internals related topics are queueing up. I have chosen below four topics as my priority as much learning and focus is required on this. Read more

Chennai SQL Serve User Group Meet for Oct'2012 happend today at Microsoft Traning Centre located in Radhakrishnan Road, Chennai.

Its pleasure seeing enthusiastic community members and addressing questions of curious minds.

Recently, I got a chance to read ebook on SQL Server Statistics By Holger Schmeling. A must read book for both Developers… Read more

I have created facebook page named "Living For SQL Serever" couple of days back.

https://www.facebook.com/LivingForSqlServer

Inviting our community friends to like this page.

-- It's yet another facebook page that shares something about SQL server.

Personally nowadays, I am very concious in choosing topics before writing a blog post on SSC.

I am… Read more

In our day to day life with SQL Server, We refer web for many reasons.

This includes understanding new SQL Server features or Recollecting syntax of rarely used commands or to check solutions for unfamiliar errors.

While searching what we need on Web, We may have to come across… Read more

Bad weather won't stop hungry minds. Our today’s Chennai SQL Server User Group (CSSUG) meet happened with around 25 enthusiastic SQL Server devotees irrespective of bad weather in Chennai.

CSSUG meet started with my presentation on SQL Server Locking Internals Part 1.

Vidhyasagar gave session on ColumnStore Index and FileTable. Todays topic for Mathi… Read more

 Let me start with my sincere apologies first for not blogging consistently.

Primary reason is, my wife gave birth to our second child two months ago.  After becoming father of two kids my priorities are entierly changed.

secondly I had to face some issues in professional life recently,… Read more

I spent sometime to understand more about tempdb today. posting some key points for our quick reference.

some key books/links on this topic are given in reference section for further read.

Some properties of Tempdb Properties

1. Tempdb is recreated everytime SQL Server starts.
2. Simple recovery mode. No Full/Log… Read more

I have come accross interesting puzzle yesterday on numbers 96 and 36.
Everyone knows that header size is 96 and maximum allowable row size is 8060.

But I was bit confused while I saw the response as 36 bytes is for row offset array (as this is not enough to… Read more

I have come accross below link while checking options to find top painful mirroring enabled databases.

Looks like there is no single query/DMV to get this info.

back to this link.

Excellect collection of key notes for almost all key SQL topics. Great work Jose Barreto.

http://blogs.technet.com/b/josebda/archive/2009/04/12/sql-server-2008-summary-of-training-sessions.aspx

Good source for Senior… Read more

As a learner I have got chance to know lots of free and precious SQL Server resources in last few months.

Like to share this list with friends in our community. Let me share my second list later (as I wanted to keep this list short).

Unknown is an ocean.… Read more

Whoever starts their career in any domain/technology, initially they will have two faces.

First face of an employee is to take care of his/him family & family related commitments and the second
face of him/her is to fulfill the expectation of the Organization they work.

But third and forth faces… Read more

Those who are fan of Glenn Berry’s DMV queries would have come across below query at-least once.

-- Hardware information from SQL Server 2008

-- (Cannot distinguish between HT and multi-core)

SELECT cpu_count AS [Logical CPU Count], hyperthread_ratio AS [Hyperthread Ratio],

cpu_count/hyperthread_ratio AS [Physical CPU Count] Read more

“I love SQL Server. SQL Server has given me good career, salaray and life”
“Be loyal and dedicated with SQL Server. It will  take care of your career growth and salaray”

This is whatt I repeatedly share with all who attend my training sessions and with my few followers. Read more

One of Our production database is used by lots of Reporting users. Mirroring is enabled on this database. But no one is using the high performance mirroring/reporting server.

I thought of moving Reporting users to make use of Mirroring server as a Reporting platform by taking Database Snapshots and making them to… Read more

As part of my MCM preparation (Have to study aggressively at least for next 2 years) , I have downloaded almost all readiness videos on Technet last week.
Here is the link: http://technet.microsoft.com/en-us/sqlserver/ff977043

My first choice was ‘Database structure’ video by Paul Randal as this topic is bit familiar to me.
Paul Randal’s presentation… Read more

My one week long search to identify active SQL Server community in Chennai ended last Sunday.

Chennai SQL Server User Group (CSSUG) is one of the active user groups in Chennai organizing events every month.

Vidhyasagar (MVP) is one of the co-founder of CSSUG is actively leading this group and… Read more

It's near to 6 months since I started blogging in SSC and started giving sessions for my Organization on Internal and tuning topics.

While seeing lots of blog post on pre/post SQLSaturday events, I am bit curious to know is there any active SQL Server user group in Chennai so that I can be part of it. Read more

Here is another SQL Server myth which I realised while understanding anatomy of index pages.

For a long time I thought data and Index pages will be allocated once We create a table.

Its a myth. but the reality is

1. Once you create a table and if a table… Read more

It has been more than two months since I blogged. I have been blogging in my Organization internal blogging site on Management topics for last couple of months (just a side effect of my new project lead position).
In parallel, I have started giving session on Performance tuning and Storage internals for my Organization… Read more

I got a report from development team that section of BizTalk communicating with SQL Server to update status
is frequently failing as deadlock victim.

As I couldn't see any useful details in errorlog, enabled trace flags 1204,1205, 3605 and -1 and captured
few deadlock cases in errorlog.

but there was… Read more