Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

LivingForSqlServer

I am Ramkumar, 34 years old Consultant, trainer, blogger and speaker at SQL Server user group in India. I have more than 10 years of experience as a developer and SQL Server DBA. I love reading, teaching and blogging about SQL Server internals and performance tuning. My Facebook page: https://www.facebook.com/LivingForSqlServer

there are 1000 reasons to celebrate

As many of you know, I created a facebook group named 'Living For SQL Server' couple of months back.

SQL Server community started making use of the group since day one by asking questions and sharing their blog posts and learnings.

and in few weeks i realized that this facebook group… Read more

0 comments, 213 reads

Posted in LivingForSqlServer on 5 August 2013

Special Recognition For Top Community Leaders In India

I got a special recognition from Microsoft, India as one of the top community leaders.

My sincere thanks to SQLServerCentral (my motherland, where I started blogging), Community leaders and members in India.

I am sure there are millions of SQL Server professionals and students are not aware of very big… Read more

1 comments, 330 reads

Posted in LivingForSqlServer on 19 June 2013

Few thoughts and updates

Few of my regular readers may have noticed I am not actively blogging @ SSC at frequent interval.

There is a reason behind this.

Update 1:

As I mentioned in my previous blog post, I was quite active in my facebook page for the past few months in

sharing resources, attending queires on couple… Read more

2 comments, 257 reads

Posted in LivingForSqlServer on 14 June 2013

Mar'2013 Chennai SQL Server UG Meet Is Scheduled

Chennai SQL Server user group meet is scheduled for Mar'2013.

Venue: Microsoft Training Centre, Radhakrishnan Salai, Chennai
Landmark: Opposite to President hotel
Timing: 09:00 AM to 01:00 PM
Date: 30th Mar 2013 (Saturday)

Session Details:

SQL Server 2008 Performance Tuning – Part 3 by Ramkumar
Data warehouse design concepts by Sonar Kumar Read more

0 comments, 464 reads

Posted in LivingForSqlServer on 11 March 2013

Chennai SQL Server User Group Looking For Sponsors

Chennai SQL Server Group (CSSUG), one of the most active UG in India planning to conduct major SQL Server event (Q2 this year)  in Chennai, India.

Working on to invite India's leading technology experts for this event.

We are looking for sponsers for this event and to have long term relationship with CSSUG

Contact details:

Vidhya Sagar
kvs1983@gmail.com Read more

3 comments, 457 reads

Posted in LivingForSqlServer on 8 March 2013

Feb'2013 Chennai SQL Server UG Meet Is Scheduled

 Chennai SQL Server user group meet is scheduled for Feb'2013.

Venue: Microsoft Training Centre, Radhakrishnan Salai, Chennai
Landmark: Opposite to President hotel
Timing: 09:30 AM to 01:00 PM
Date: 23rd Feb 2012 (Saturday)

Session Details:

1. SQL Server 2008 Performance - Part 2 by Ramkumar

2. PowerPivot & SSIS by Sonar… Read more

0 comments, 366 reads

Posted in LivingForSqlServer on 5 February 2013

Few thoughts

I would like to share few thoughts/updates with our SQL Server community.

1. While checking my SSC blog posts, i realised that my 40+ blog posts has attracted 30,000+ user visits in last 2 years.
Think this is the good time to have a website for LivingForSQLServer.
I 've just registered website named… Read more

0 comments, 391 reads

Posted in LivingForSqlServer on 21 January 2013

SQLOS Basics - Chennai User Group Meet - Presentation File Download

Chennai SQL Server User Group (CSSUG) meet is happening tomorrow (15-Dec-2012) in Microsoft Training Centre, Chennai.

You can download presenation and demo scripts here
http://www.sqlservercentral.com/blogs-admin/blogs/livingforsqlserver/CSSUG_SQLOS_Basics_15Dec2012/SQLOS_CSSUG_Meet_15Dec2012.zip

Tomorrow,  I am going take 2 hour session on SQLOS Basics (Skill level 200-300).

Topics to be covered:

SQL Server Architecture
SQLOS  - Basics
SQLOS – Responsibilities
CPU
   … Read more

0 comments, 832 reads

Posted in LivingForSqlServer on 14 December 2012

46756e2057697468205061756c2052616e64616c

49206a75737420747765657465642062656c6f7720656d6f74696f6e616c206d65737361676520746f205061756c2052616e64616c20696e204865782e202020

224a4d5057465a50565142564d53424f45424d22202020

54686f7567687420686520776f756c642067657420746865206d65737361676520616e64207265706c79206d6520696e203135206d696e757465732e202020

4775657373206865207761732076657279206275737920617420746861742074696d652e2048652067617665207570206166746572203220636c75657320616e642032

20617474656d7074732e202020

4861707079207468617420492073706f696c6564206869732076616c7561626c652035206d696e75746573203a2d29202020

4465616c20686572652069732068652068617320746f2066696e642074686520616e73776572206f6620686973206f776e206f7220656c7365

2068652068617320746f202020

6368616e676520686973206f70696e696f6e20616e6420737570706f727420746865206e656564206f6620646f63756d656e74696e67

20616e61746f6d6f79206f6620742d6c6f67202020

7265636f7264732e202020

497420746f6f6b206d6f7265207468616e20313020686f757273206a75737420746f20756e6465727374616e64

206c6974746c6520626974206f662073696d706c6520494e53455354202020

6c6f67207265636f72642e20202020

687474703a2f2f7777772e73716c73657276657263656e7472616c2e636f6d2f626c6f67732f6c6976696e67666f7273716c7365727665722f3230313

22f31312f32372f74696d652d706173732d776974682d7472616e73616374696f6e2d6c6f672d706172742d352d696e736572742f202020

5468696e6b2069747320696d706f737369626c6520746f20646f63756d656e7420616e61746f6d79206f6620616c6c207479706573206f66

20742d6c6f67207265636f7264732e202020

4275742069742063616e20626520646f6e6520746f20736f6d6520657874656e642e202020

496620796f75206172652072656164696e6720746869732c20646f6e7420666f7267657420746f20636f6d6d656e7420796f7572206e616d6520696e

204865782e1f1f

706c6561736520646f6e27742074616b65207468697320736572696f75736c792e204a75737420612066756e20617474656d70742e202020

  Read more

2 comments, 718 reads

Posted in LivingForSqlServer on 7 December 2012

Next Chennai SQL Server UG Meet Is Scheduled

Chennai SQL Server user group meet is scheduled for Dec'2013.

Venue: Microsoft Training Centre, Radhakrishnan Salai, Chennai
Landmark: Opposite to President hotel
Timing: 09:30 AM to 01:00 PM
Date: 15th December 2012 (Saturday)

Register here: http://sql-articles.com/cssug/december-2012-ug-meeting-scheduled/

Chennai friends, register yourself to get your seats confirmed.

  Read more

1 comments, 540 reads

Posted in LivingForSqlServer on 5 December 2012

LivingForSQLServer celebrates 2nd year anniversary today

It's been 2 years since I wrote my first blog post on SQLServerCentral ("What happens when a query is submitted").

No need to say how nervous I was while posting my first blog on worlds largest SQL Server community.

Remembering that day I was checking user visits once in two minutes for the… Read more

0 comments, 586 reads

Posted in LivingForSqlServer on 5 December 2012

SQLOS Basics - Query and CPU

In this article We are going to understand the basics of SQLOS - CPU scheduling.

In high level:

1. When an user connects to SQL Server instance, unique connection id and session id is assigned to the user.
DMV: sys.dm_exec_connections

2. Queries being executed by the user sessions (requests in other… Read more

5 comments, 1,535 reads

Posted in LivingForSqlServer on 3 December 2012

Interview questions for SQL Server Performance Tuning Specialists

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

3 comments, 4,702 reads

Posted in LivingForSqlServer on 29 November 2012

One Interview question. Many Answers

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

1 comments, 1,928 reads

Posted in LivingForSqlServer on 27 November 2012

Time Pass With Transaction Log - Part 5 INSERT

 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

4 comments, 1,440 reads

Posted in LivingForSqlServer on 27 November 2012

Time Pass With Transaction Log - Part 4 DDL

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…

Read more

0 comments, 1,244 reads

Posted in LivingForSqlServer on 26 November 2012

Time Pass With Transaction Log - Part 3 fn_dblog

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

0 comments, 7,125 reads

Posted in LivingForSqlServer on 19 November 2012

My Favourites Of Paul Randal

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

0 comments, 1,003 reads

Posted in LivingForSqlServer on 15 November 2012

Older posts