As part of this Transaction Log internal series, In this article We are going to revisit some basic properties of Transaction log.
Though architecture, purpose and properties of data and transaction log files are not similar, I have tried to compare some similarities
and differences of data and t-log files. Tried to cover some common myths around data and…
Hundreds of expert level books, articles, videos and blogs has talked much about Transaction Logs and How well to manage it.
Everything from basics to best practices are documented in various format except "How to read Transaction Log Entries"
Yes. this series of articles is just an attempt to try reading transaction log records *of some basic… Read more
Still 18 days to go for my session on Transaction Log Internals for Chennai SQL Server User Group (17-Nov).
While seeing below two worlds best presentations on this topics, I wonder what more I could add for my one hour session.
1. Paul Randals Transaction Log Internals Maintenance (MCM Readiness Videos)
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.
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.
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