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).

Install, Configure and Use SQL Server on Linux

Little Old Story
Several years back while I started working in a capacity of Jr. DBA, faced a question in walk-in interview. “Have you installed SQL Server on Linux?” without a moment delayed my answer was “Yes, many a time”. Didn’t realize my interview concluded with this “goofy” answer as REJECTED candidate. But that remained […]

By |February 24th, 2017|Categories: SQL Server||1 Comment

Log shipping Automation With PowerShell

Hello Friends –

Back to you all with my second blog of year 2017 with Logshipping automation. This time picked up a little deviated topics like year 2016. Being a DBA background monitoring, configuring & managing high availability & disaster recovery solution were a day to day responsibility for me, like most of us have/had at […]

By |January 30th, 2017|Categories: SQL Server||0 Comments

2017’s first DPD & DPS2017 launch!

Hello Friends!

On behalf of DataPlatformGeeks taking an opportunity to share #DPS2017 (DataPlatform Summit 2017) launch on 28-Jan-2017 @ Bangalore in the presence of Shivir Chordia (Director, Microsoft Data Platform, India) & Deepak Rajendran (Community Program Manager, India).

This is the 3rd edition of Summit in consecutive years since 2015 and Asia’s largest Data Platform related […]

By |January 30th, 2017|Categories: Data Platform Day, SQL Server||0 Comments

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