Log in | Register

SQL Server Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education SQL Server Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

SQL Server


Data Platform Summit 2017 #DPS2017

After successful completion of SQLServerGeeks Annual Summit 2016 last year, I was getting so many questions about the next conference in INDIA. Questions were like “Are you guys going to do this conference next year?”, “May I know the city name for the next annual conference?” and “This time I was unable to attend […]

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

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

Dynamic Data Masking in SQL Server 2016

Microsoft has introduced an impressive new feature in SQL Server 2016 called Dynamic Data Masking (DDM). Dynamic Data Masking allows a developer or administrator to decide how much of the
sensitive data to reveal with minimal impact on the application layer. This feature also helps to simplify the design and coding of security in your […]

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

Resource Governor to Control Physical IO

Hi Friends,
Microsoft introduced so many new features and improvements with SQL Server 2014. These features make the life of DBA easier. In addition to these features, One of the improvement provided in SQL Server 2014 is about Resource Governor. Resource Governor is a well-known feature of the SQL Server world to manage the system resource consumption. […]

Sub Query behaviour looks like a bug

While debugging one procedure I came across below Scenario where a sub-query was returning all records from outer query.

Initially I thought it is a bug in SQL server. As COL1 column is not part of Table2 , it should fail binding stage and throw error. But it returned all 20 records from Table1. Though […]

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

SQL Server – Join Operation

In this blog we’ll find how SQL Server works when we do join operation. SQL Server optimizer chooses one of the below physical operator to perform logical join operation.

Hash Match
Merge Join
Nested Loop Join

As far as performance is concern let me tell you, we can’t say which one will best.Each operator has its own advantages […]

Don’t use ISDATE() function to check valid Date

I got the below email from one of my teammate on ISDATE() function.

Thanks to him for asking me the question. I do not have any idea on this behaviour of  sql server. I gone through the MSDN documentation and  got to  know, why SQL Server behaves like this.

select ISDATE(’08/16/013′) returns true because here it […]

By |October 11th, 2016|Categories: SQL Server, Transact-SQL|Tags: , , , |0 Comments

SQL SERVER – Trace Flags

To know about a topic we usually ask questions. Here I used the same method to explain about trace flags of SQL Server.

Below are some basic questions and its answers on this.

What is the use of Trace Flag?

Trace Flags are used to enable or disable certain functionality of SQL server temporarily. It is used to […]

By |September 29th, 2016|Categories: SQL Server, Transact-SQL|Tags: , , |0 Comments