Log in | Register

Sandip Pani, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Sandip Pani, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

SandipPani

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

About Sandip Pani

Sandip Pani is a Database/BI developer and speaker and is located in Bangalore, India. He has been working with SQL Server over 11 years. He is MCITP for SQL Server 2008 and specializes in SQL Server for application developers and performance and query tuning. His specialization is into Query Tuning and performance troubleshooting. He is working as Senior Technical Specilist for NextGen Healthcare. He is active in SQL community world. He share and enhance his knowledge of SQL Server by spending time at newsgroups and forums, reading and writing blogs, and attending and speaking at conferences.

Compare Query plan using SSMS

Recently Microsoft released SSMS 17.0. This release of SSMS supports SQL Server 2017 for both running on Windows and Linux. In this release Microsoft has added new features as well as improved some existing features. One of them is to Compare Query plan.

You can download latest SSMS 17.0 here

This is helpful where you have […]

By |May 6th, 2017|Categories: Programming, SQL Server, Transact-SQL|Tags: , |Comments Off on Compare Query plan using SSMS

Resumable Online Index Rebuild- SQL Server 2017

Resumable online index rebuild is one of the very useful feature of SQL Server 2017 for DBA’s. Now it is possible to pause an Index Rebuild. It allows to resume an online index rebuild operation from where it is stopped or paused. Below are some scenarios where you may need to pause your index […]

Database Scoped Configurations and Trace flag 4199

Those who are working on query performance whether you are a DBA or Developer I am sure you guys must have used trace flag 4199.  TF 4199 enables all query optimizer related fixes.Microsoft used to have separate TF for each hotfix applied to query optimizer prior to SQL Server 2005 Service Pack 3 (SP3) Cumulative […]

By |April 16th, 2017|Categories: Database Administration, Database Development, Performance, SQL Server, Transact-SQL|Tags: , , , |Comments Off on Database Scoped Configurations and Trace flag 4199

CAST function doesn’t change execution plan for Datetime type column

I have been reviewing code from last couple of years. I found some myths are followed very strictly by developers. Yesterday while reviewing, I found developers are hesitating to use TRY_CAST or CAST function on column in where clause to convert date to datetime or datetime to date. When I asked the reason they […]

Sp_Recompile – does it work the way you expect?

Last week I was working on an assignment where I need to recompile all stored procedure where ever it is refereeing to a certain table. There are many options to recompile stored procedure. I opted to go with SP_Recompile where I will pass table name as parameter and this is meeting my requirement.

MSDN documentation […]

By |March 22nd, 2017|Categories: SQL Server|Tags: , , |Comments Off on Sp_Recompile – does it work the way you expect?

DBCC CloneDatabase

This blog was due from a long time.  With the release of SQL Server 2014 Service pack 2, a new DBCC command included that is DBCC CloneDatabase. My primary job role is to do query tuning and I was looking for this kind of functionality. Using this command, it is quite easy   to copy […]

By |March 15th, 2017|Categories: Database Administration, Performance, Transact-SQL|Tags: , , |Comments Off on DBCC CloneDatabase

New Function String_Split in SQL Server 2016

SQL Server 2016 has many features which makes developer life bit easy to do various task. Earlier to split a string developer use to write a user defined function using temp tables and complex logic. In almost every database I see a user defined function exists which does string split work. The project for […]

By |March 8th, 2017|Categories: Database Development, Programming, SQL Server, Transact-SQL|Tags: , |Comments Off on New Function String_Split in SQL Server 2016

Step by Step Guide to Install, configure and Run R script in SQL Server 2016

Microsoft acquired Revolution Analytics in 2015 and integrated R in SQL Server 2016.Today I will show you how to install, configure and run R script in SSMS. Like all other Microsoft software installation of R is pretty easy. You just need to run the set up and with few click on Next button will […]

By |February 28th, 2017|Categories: Database Administration, SQL Server, Transact-SQL|Tags: , , |Comments Off on Step by Step Guide to Install, configure and Run R script in SQL Server 2016

New Security Features In SQL SERVER 2016 – PART 1

Data Security in any application is vital. Different business or application  has their own security policy.  SQL Server 2016 provides three new security features which helps to protect data.

Below there are new security features added in SQL Server 2016.

Row-Level Security (RLS)
Dynamic Data Masking (DDM)
Always Encrypted

In this part of blog, we will see use case […]

By |February 1st, 2017|Categories: Database Administration, Security and Encryption, Transact-SQL|Tags: , , , |Comments Off on New Security Features In SQL SERVER 2016 – PART 1

Entire world is talking about Data Platform Summit 2017

Great start by DataPlatformGeeks team. On 26th January 2017, #DPS2017 is globally launched here and just after that on 28th January 2017 DPG team had a  successful full day  Data Platform Day event. I am lucky to be part of this event. Opening note was delivered by Shivir Chordiya (Director, Microsoft Data Platform, India) and officially […]

By |January 30th, 2017|Categories: Data Platform Day|Tags: , , |Comments Off on Entire world is talking about Data Platform Summit 2017
Newsletter_Footer