Skip to content
February 7, 2023
  • 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 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
  • Magazine
  • Events
    • Browse Events
    • Suggest Topics
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes
  • Social
    • Subscribe To Our Newsletter
    • Twitter
    • LinkedIN Group (Forum)
    • Facebook Group
    • Facebook Page
    • YouTube Channel
    • Telegram Group (Forum)
  • About Us
    • Subscribe To Our Newsletter
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
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 …

SQL Server FILESTREAM attribute Implementing – PART II 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 …

SQL Server FILESTREAM attribute Implementing – PART I Read More
SQL Server

What is IDENTITY_INSERT?

May 8, 2013April 25, 2018 - by Piyush Bajaj - 15 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 …

What is IDENTITY_INSERT? 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 …

How to Handle Null Values in XML 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 …

SQL Server – How to Generate XML Output Using FOR XML? – PART 1 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 …

SQL Server Inline Table Valued Functions better than a View 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 …

SQL Server – What is Scalar Function? 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 …

SQL Server Column Level Encryption 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 …

SQL Server What is a Sparse Column? 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 …

What is FILESTREAM Data in SQL Server? Read More

Posts navigation

1 2 … 9 Next

Subscribe to SQLServerGeeks


Ad

Virtual Symposium

master classes



SSG_linkedin

SSG_fb

About Us

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

Virtual Symposium

Copyright © 2022 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.