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

SQLServerGeeks Annual Summit 2016 IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

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

SQL Server Agent on Linux

Install SQL Server Agent on Linux (Ubuntu 16.04 LTS)
Hello Friends!
SQL Server on Linux is progressing a lot, still in CTP 1.4 and gearing up for launched in May 2017. My excitement is touching new heights day by day with every CTP release. Recently I’d upgraded my SQL Server vNext to CTP 1.4, most of us […]

By |April 5th, 2017|Categories: SQL Server||0 Comments

Upgrade SQL Server vNext on Ubuntu (Linux)

Upgrading SQL Server vNext on Ubuntu 16.04 (LTS)
Upgrade/Patching are vital for enterprises & routine activity for DBA. Since SQL Server vNext lunched (for Linux Kernel based OS), DBA responsibility extends to it.

Microsoft released an update for SQL Server on Ubuntu from CTP 1.3 to CTP1.4 with decent amount of new features. Definitely there is […]

By |March 31st, 2017|Categories: SQL Server||0 Comments

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

SQL Server (RDS) Native Backup configuration with S3

AWS RDS – SQL Server Native Backup configuration with S3
Since AWS introduced much awaited feature of supporting SQL Server native backup & restoration (through S3), I’m seeing a noticeable spike in routine requests to move data from one environment to another. However, very limited set of document is available online how to configure S3 […]

By |February 15th, 2017|Categories: SQL Server||Comments Off on SQL Server (RDS) Native Backup configuration with S3

SQL Server (RDS) Native Backup/Restore

Hello Friends!
AWS RDS (SQL Server) Native Backup & Restore
Back to you with my another blog talks simple things about SQL Server Instances hosted as DBaaS (Database As A Service) in Amazon cloud. Last year Amazon launch a vital feature i.e. native backup & restore SQL Server (& other RDBMS) databases hosted as RDS (Relational […]

By |February 1st, 2017|Categories: SQL Server||Comments Off on SQL Server (RDS) Native Backup/Restore

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||Comments Off on Log shipping Automation With PowerShell

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||Comments Off on 2017’s first DPD & DPS2017 launch!

SQL Server RDS services through AWS PowerShell

Hello Friends!
Querying SQL Server RDS Instances through PowerShell
It’s been a while I’m working with AWS RDS (Relations Database Services) and playing around with SQL Server. Hopefully you enjoyed my previous blog about parameters to keep in mind while setting up SQL Server instance in AWS (Amazon Web Services) cloud environment.

While playing around AWS RDS […]

By |January 5th, 2017|Categories: SQL Server||Comments Off on SQL Server RDS services through AWS PowerShell

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||Comments Off on AWS RDS for SQL Server – Cheat Sheet

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||Comments Off on DATEDIFF_BIG – SQL Server 2016 new fn
Newsletter_Footer