If you are the regular reader of my blog posts, you could easily judge in which topics i spend much time these days.

I have converted some of my learning as questions and posted it here. These are not necessarily be the interview questions.

I am sure that this will help us to assess our knowledge and hope this… Read more

Conducting technical interview is an art.

Most likely I would start a discussion with simple questions like "What is your favourite topic in SQL Server?" .

here are some open ended questions that could be answered in 10 seconds or may lead to an hour long interesting discussion.

1. I have created a Non Clustered Index to improve a query… Read more

 In this article We are going to INSERT a record in a simple table and try reading Transaction log record.

Note: This article is incomplete. I could not interpret lots of Hex values (no clues) and also you can expect inaccuracy in interpreted values.

USE MASTER
GO

-- Drop this… Read more

In this article,  We are going to CREATE/ ALTER/ DROP a table and observe transaction log records created for those DDL statements.

Our focus is to observe schema level impacts in lower level.

1. CREATE TABLE

Lets create a simple table named tEmployee in a sample database EXPLORE_TLOG

USE MASTER
GO

-- Drop…

As part of this Transaction Log Internals series, In this article we are going to observe the use of fn_dblog and some of its important columns.

fn_dblog is an undocumented function introduced in SQL Server 2005. This function is used to return active (or un-truncated) part
of transaction log file.

Syntax:
fn_dblog({BeginLSN | NULL}, {EndLSN… Read more

As a new blogger, It is a little pain for me to blog on a technical topic.  

It starts from learning, exprimenting, being comfortable with topic, decide what to write and how to convey, make sure no or minimum technical inaccuracies,  preparing relavent demo scripts, formatting and so on.

But while going thru his blog post count, varity, depth and… Read more

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