Log in | Register

Avanish Panchal, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Avanish Panchal, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

Avanish Panchal


Avanish Panchal

About Avanish Panchal

Avanish carries around 14 years of experience in IT industry. He is post graduate in Computer Science, followed by Masters in Business Administration. He has worked on multiple technologies like SQL Server, .net & Sybase with world largest bank(s)/IT consulting firm(s) like JPMorganChase, CapGemini, Datamatics etc. Currently holds position of Database Architect in BioPharma Global Leader. His area of focus are SQL Server DB Engine, Security, Storage, Virtualization & Infrastructure Consolidation. Passionate for delivering Database IT Infrastructure to satisfy and exceed the needs of the enterprise. You may find him active on various forums like SQLBangalore, SQLServerGeeks & many more. His SQL Server passion helped him to be the Core Team member of Asia's First SQL Server Conference in 2015 @ Bangalore (#SSGAS2015).

AWS RDS for SQL Server – Cheat Sheet

Hello Friends!

Back to you again with my all together new pick, Amazon Relation Database Service. Ah! interest, some of you might be wondering is this topic has nothing to do with SQL Server. Yes / NO ?

Working with RDS for few years and most of cases got to know from many of beginners or intermediate […]

By |November 5th, 2016|Categories: SQL Server||0 Comments

DATEDIFF_BIG – SQL Server 2016 new fn

Hello Friends!

In continuation to my previous blog about SQL Server 2016 newly introduced T-SQL Functions, putting down DATEDIFF_BIG another the new function. This function helps to find difference between two dates in the units specified by the DatePart parameter and the returned unit is of type bigint. This function like DATEDIFF function returns the number of […]

By |June 14th, 2016|Categories: SQL Server||0 Comments

AT TIME ZONE – SQL Server 2016 – My new favourite

Hi Friends,

Back to you with one of my favourite feature introduced with SQL Server 2016.

Working over a decade with SQL Server in heterogeneous line businesses, heterogeneous market, unlike customers from geographic and supporting various timezones. At many occasions found messy myself while playing nicely with different timezones. Specially when day light saving switch is ON/OFF. Definitely […]

By |June 1st, 2016|Categories: SQL Server||0 Comments


Hello Friends!

SQL Server Database Administration in my core expertise. During my journey from Jr. to Sr. DBA and so on experienced many situations where I preferred using the TRUNCATE TABLE statement against DELETE statement. Reason is simple speed, minimally logged and don’t unnecessarily eats my server resources. However, same statement made me (still does) nervous to get […]

By |May 21st, 2016|Categories: SQL Server|Tags: |0 Comments

SQL Server 2016 – All new fn – Compress and Decompress

Hello Friends!

I’m back to you with couple of new functions available in SQL Server 2016 version called “Compress” & “Decompress”. So far most of us are aware about PAGE LEVEL & ROW LEVEL compressions in SQL Server. However I have a had come to a situation, probably once of twice to look for something where […]

By |May 11th, 2016|Categories: Compression, SQL Server||0 Comments

STRING_SPLIT in SQL Server 2016

Hello Friends,

In continuation to my previous post, I’m going have chosen another function from SQL Server 2016 to put forward here.

New STRING_SPLIT() function in SQL Server 2016 to split a string into multiple values & rows. Function returns table from a string parameter

Type of Parameter : VARCHAR, NVARCHAR, CHAR and NCHAR

Count of parameters: 2 (Two) – […]


Hello Friends,

Getting back with you my new blog with DIE. :) Sound interesting & crazy at same time. Yes, SQL Server 2016 is getting to us with a new T-SQL clause DROP IF EXISTS, in short (DIE).

Traditionally we all, irrespective of holding developer, DBA or DEVOPS profile very much used to of IF EXISTS […]

By |April 20th, 2016|Categories: SQL Server|Tags: |0 Comments

The more you learn, the more you earn!

“The more you Learn, The more you earn” – quote by Frank Clark, always inspires me to strive for new learning and implement those learning into my routine life irrespective of personal or professional. Being a decade old SQL Server professional, experienced a wide spectrum of SQL Server versions from 2000 to 2016 (Wow! […]

By |April 12th, 2016|Categories: SQL Server||0 Comments

SQL Server 2016 – Dynamic Data Masking


So I’ve reached to my final blog about SQL 2016 Advance Security features (couple of discussed in my previous blogs 1 & 2). In this blog I’m going to put forward “Dynamic Data Masking” (DDM) feature with a great interest.

As I’ve a practice of putting technical things through live examples, here is the one where […]

By |March 18th, 2016|Categories: SQL Server||0 Comments

SQL Server 2016 – Row Level Security

Dear Friends,

In conjunction to my previous blog, picked up another most awaited feature Row Level Security in short RLS. Current database world many RDBMS are emphasizing towards security as some or the other DB holding sensitive data. So far this kind of solution is available in SQL Server through T-SQL VIEWS/FUNCTION but restricting access […]