Log in | Register

Piyush Bajaj, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Piyush Bajaj, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

PiyushBajaj

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

Piyush Bajaj

About Piyush Bajaj

I am very passionate about SQL Server. I also did certification on MCSA – SQL Server 2012, Querying and Administering; MCTS – SQL Server 2008, Database Development; and MCTS – SQL Server 2005, Implementation & Maintenance, which helped me to get more knowledge and interest on this field.Please feel free to drop me any question online or offline, I will try to give you the best possible answer from my side.Right now I am working as a SQL Server developer in TCS. I have an experience of just 2.6 years, well I can only say that “If you have an interest and passion, experience might become a very small thing”.

SQL Server FILESTREAM attribute Implementing – PART II

Hi Folks,

In my previous blog, you would have already seen how to enable SQL Server FileStream attributes, or if you want to take a look for that, click here.

In this post, will basically learn how do we actually store and retrieve data using FileStream in SQL Server as per the following steps:

Create a FILESTREAM-Enabled […]

SQL Server FILESTREAM attribute Implementing – PART I

Hey Folks,

In my previous blog post, I already explained what FILESTREAM is; if you would have missed then check this URL

Let me tell you some advantages of using SQL Server FILESTREAM attribute:

When using FILESTREAM, structured and unstructured data are logically connected while physically separated, and cause of this unstructured data does not impose any […]

What is IDENTITY_INSERT?

Hi Folks,

What is IDENTITY_INSERT?

I am sure that all of you would be aware about the role of Identity column in a table, i.e., it is column which keeps on incrementing without supplying the value explicitly during insertion.

So in the figure below, CustomerID is an identity column:

Now, let say I have a requirement to insert […]

How to Handle Null Values in XML

Hello Folks,

You might be wondering about how to handle NULLS if it’s a part of XML result set.

Well, I have some keynotes about it, so please see it carefully:

Till now, the default implementation is simply to remove the attribute, if the value is NULL.
Although for most of the applications, it didn’t make much difference, but […]

By |January 14th, 2013|Categories: SQL Server|Tags: , |2 Comments

SQL Server – How to Generate XML Output Using FOR XML? – PART 1

Hey Folks,

What do think when did FOR XML introduced?

It was introduced long way back with the arrival of SQL Server 2000.

Well, FOR XML is a row set aggregation function which returns a result set of one row and one column, which has a NVARCHAR (MAX) data type.

FOR XML can be used with these 4 […]

By |September 20th, 2012|Categories: SQL Server|Tags: , , |1 Comment

SQL Server Inline Table Valued Functions better than a View

Hello Folks,

You would be very much aware of the View in SQL Server. But do you really know about SQL Server Inline Table Valued Functions?

Well you don’t have to worry further more on this, because I will let explain you in a brief.

With the introduction of SQL Server 2000, Microsoft has offered two types […]

By |April 21st, 2012|Categories: SQL Server|Tags: |3 Comments

SQL Server – What is Scalar Function?

Hello Friends,

It’s been a while that I have posted any blog.  So here it is-

Well with the arrival of SQL Server 2000, Microsoft has introduced the concept of User Defined Function (UDF).

So there are basically three types of UDF’s:

Scalar Functions
Inline Table-Valued Functions
Multi-Statement Table-Valued Functions

In this blog-post, I would like to go on for Scalar […]

By |April 11th, 2012|Categories: SQL Server|Tags: |2 Comments

SQL Server Column Level Encryption

Hello Folks,

You would have heard about Cell-Level Encryption which was introduced earlier with the arrival of SQL Server 2005. It was built for the developers with a granular level of encryption for their applications that have specific data security requirements.

While on the other side, SQL Server Column Level Encryption provides much flexibility in terms […]

SQL Server What is a Sparse Column?

Hello Folks,

You would have heard about Sparse Column.It has been introduced earlier with the arrival of SQL Server 2008.

Well I have made some keynotes about SQL Server What is a Sparse Column?, so please go through it carefully:

Sparse columns allow for the optimized storage of null columns.
It reduces the space requirements for null values […]

By |January 15th, 2012|Categories: SQL Server|Tags: |1 Comment

What is FILESTREAM Data in SQL Server?

Hello Folks,

FileStream data type has been introduced with the arrival of SQL Server 2008. Before that, we had to use the BOLB data type of SQL Server which allows us to store the data up to 2GB. But one disadvantage with that is file streaming becomes slow and performance of the file stream can […]

By |November 23rd, 2011|Categories: SQL Server|Tags: |0 Comments
Newsletter_Footer