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

Configure SQL Server vNext – New utility new methods.

[mssql-conf] – A command line utility to reconfigure SQL Server vNext on Linux
Hello Friends!

In my previous post I listed down how to install & use SQL Server vNext on Linux. However, configuration is an important piece and thought to talk about in detail.

Traditionally we use SQL Server configuration manager to do a lot of […]

By |May 8th, 2017|Categories: SQL Server||Comments Off on Configure SQL Server vNext – New utility new methods.

SQL Server 2017 (CTP) Download

Hi Friends!
Quickest Way to download SQL Server 2017 (CTP)
Thought to share with you a quickest way to download SQL Server 2017 CTP version (applies to basically any version provided you’ve source URL details).

In today’s world hard to avoid working with PowerShell, that’s the easiest and vital tool  to ease out quite a bit of pain […]

By |May 3rd, 2017|Categories: SQL Server||Comments Off on SQL Server 2017 (CTP) Download

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||Comments Off on SQL Server Agent on Linux

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||Comments Off on Upgrade SQL Server vNext on Ubuntu (Linux)

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
Newsletter_Footer