Skip to content
March 3, 2021
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Training   Data Platform Virtual Summit 2020   Virtual Symposium   DPD banglore
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Events
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra
    • Virtual Symposium Recordings
    • Geek Talks
  • PodCasts
  • Conference
  • Resources
  • Social
    • Subscribe To Our Newsletter
    • Twitter
    • LinkedIN Group (Forum)
    • Facebook Group
    • Facebook Page
    • YouTube Channel
    • Telegram Group (Forum)
    • Connect With Amit Bansal
  • About Us
    • Subscribe To Our Newsletter
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
Main Menu

Author: Piyush Bajaj

SQL Server

SQL Server FILESTREAM attribute Implementing – PART II

June 11, 2014September 10, 2014 - by Piyush Bajaj - Leave a Comment

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 …

Read More
SQL Server

SQL Server FILESTREAM attribute Implementing – PART I

May 11, 2014December 8, 2014 - by Piyush Bajaj - Leave a Comment

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 …

Read More
SQL Server

What is IDENTITY_INSERT?

May 8, 2013April 25, 2018 - by Piyush Bajaj - 14 Comments.

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 …

Read More
SQL Server

How to Handle Null Values in XML

January 14, 2013September 12, 2014 - by Piyush Bajaj - 2 Comments.

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 …

Read More
SQL Server

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

September 20, 2012July 5, 2014 - by Piyush Bajaj - 1 Comment

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 …

Read More
SQL Server

SQL Server Inline Table Valued Functions better than a View

April 21, 2012November 29, 2014 - by Piyush Bajaj - 4 Comments.

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 …

Read More
SQL Server

SQL Server – What is Scalar Function?

April 11, 2012September 18, 2014 - by Piyush Bajaj - 3 Comments.

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 …

Read More
SQL Server

SQL Server Column Level Encryption

January 18, 2012September 22, 2014 - by Piyush Bajaj - 3 Comments.

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 …

Read More
SQL Server

SQL Server What is a Sparse Column?

January 15, 2012September 22, 2014 - by Piyush Bajaj - 1 Comment

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 …

Read More
SQL Server

What is FILESTREAM Data in SQL Server?

November 23, 2011October 9, 2014 - by Piyush Bajaj - 1 Comment

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 …

Read More

Posts navigation

1 2 … 9 Next

Subscribe to SQLServerGeeks

Ad

master classes

SSG_linkedin

SSG_fb

dps2017_logo_website

video courses

dps2017_logo_website

create your blog

guest_post

DataPlatformGeeks Social Media Channels

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Subscribe To Our Newsletter

loader

Copyright © 2019 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by SQLServerGeeks and DataPlatformGeeks.