AmitBansal

Amit Bansal

About Amit Bansal

Amit R S Bansal leads the SQL & BI practice at SQLMaestros.com (unit of eDominer) with a focused team providing consulting, training, content development & SQL support services to more than 120+ SQL Server customers globally. He holds a Director position at eDominer Systems & Peopleware India. His sessions at TechED North America 2014, 2012 & TechED Europe 2013 were top-rated. Since 2002, he has worked on countless SQL Server projects, consulted, trained & mentored more than 6000 IT professionals on SQL Server. Amit is a SQL MCM, SQL MVP & MCT. He is also the founder of SQLServerGeeks.com. You can know more about him at www.amitbansal.net

SQLServerGeeks.com Core Team 2014-2015

Hi Friends,

It gives me immense pleasure to announce the new board/core team of SQLServerGeeks.com for the year 2014-2015.

President                            :               Sarabpreet Singh Anand

Vice President                   :               Manohar Punna

Chief Technical Editor     :               Ahmad Osama

Editor & Mentor               :               Kanchan Bhattacharya

Mentor                                :               Prince Rastogi

 

For all of us, it’s really SQLServerGeeks ver 2.0 :) and let me explain that!

Since 2010, […]

By |October 26th, 2014|Categories: SQL Server||6 Comments

SQL Server 2014 Upgrade was easy – Serious SQL Fun

Share it if you like it.

By |October 14th, 2014|Categories: SQLFun|Tags: |0 Comments

SQL Server 2014 Upgrade – Serious SQL Fun

Share it if you like it.

By |October 13th, 2014|Categories: SQLFun|Tags: |0 Comments

SQL Server Database Corruption – Serious SQL Fun

Share it if you like it

By |October 9th, 2014|Categories: SQLFun|Tags: |0 Comments

SQL Server Drop Table – Serious SQL Fun

Share it if you like it.

By |October 7th, 2014|Categories: SQLFun|Tags: |0 Comments

SQL Server Memory Nodes – How many do I have?

Hi Friends,

SQL Server Memory Nodes serve the foundation for SQL Server Memory and they have one-to-one mapping with physical NUMA nodes. For example, if your system has four physical NUMA nodes, your SQL instance will have four Memory Nodes. In case your system does not have NUMA, SQL instance will still have one Memory […]

SQL Server Performance Tuning – Serious SQL Fun

Share it if you like it!

By |October 3rd, 2014|Categories: SQLFun|Tags: , |0 Comments

SQL Server Query Tuning – Serious SQL Fun

Share it if you like it!

By |October 3rd, 2014|Categories: SQLFun|Tags: , |0 Comments

SQL Server Restart

Share it if you like it!

 

READ UNCOMMITTED Isolation Level honors locks

Hi Friends,

It’s a well-known fact that READ UNCOMMITTED Isolation Level in SQL Server allows dirty reads. In other words, if a transaction is running under READ UNCOMMITTED Isolation Level, it does not honor any locks held by any other transaction. Did is say ‘any’? Well there is a small exception or twist to this.

Let’s […]

Newsletter_Footer