Skip to content
April 22, 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     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

Tag: KapilSingh

SQL Server

Changes in In-Memory OLTP in SQL Server 2016

July 23, 2015July 31, 2015 - by Kapil Singh Kumawat - Leave a Comment

In SQL Server 2014 a new feature In-Memory OLTP was introduced which was referred as ‘Hekaton’. This feature was introduced to work with memory-optimized tables rather than working with disk based …

Read More
SQL Server

Introduction To Query Store In SQL Server 2016 – Part 1

July 16, 2015July 31, 2015 - by Kapil Singh Kumawat - Leave a Comment

Hi friends, in next few blogs we will explore another new feature named Query Store which gets introduced in SQL Server 2016 CTP 2.0. This is a very useful feature for …

Read More
SQL Server

Live Query Statistics In SQL Server 2016 CTP 2.0

July 14, 2015July 31, 2015 - by Kapil Singh Kumawat - Leave a Comment

Hi friends, today we will learn another new feature Live Query Statistics which gets introduced in SQL Server 2016. It’s a common scenario in our day-to-day life that queries takes longer …

Read More
SQL Server

Introduction To Dynamic Data Masking In SQL Server 2016

July 9, 2015July 31, 2015 - by Kapil Singh Kumawat - Leave a Comment

In release of SQL Server 2016 CTP 2.0 another new feature that is released is Dynamic Data Masking.  Using Dynamic data masking we can provide the security to our restrictive data …

Read More
SQL Server

FOR JSON Clause Mode With ROOT Option In SQL Server 2016

July 6, 2015July 31, 2015 - by Kapil Singh Kumawat - Leave a Comment

Hi friends, we will continue with FOR JSON clause in this blog and today we will learn formatting of query using FOR JSON clause mode with ROOT option in SQL Server …

Read More
SQL Server

FOR JSON Clause With INCLUDE_NULL_VALUES Option In SQL Server 2016

July 3, 2015July 31, 2015 - by Kapil Singh Kumawat - Leave a Comment

Hi folks, Today we learn how to format query using FOR JSON clause with INCLUDE_NULL_VALUES option in SQL Server 2016. As we seen in previous blogs that when we used FOR …

Read More
SQL Server

FOR JSON Clause With PATH Mode In SQL Server 2016

July 2, 2015July 31, 2015 - by Kapil Singh Kumawat - Leave a Comment

In previous blog we learnt about changing query format using JSON clause with AUTO mode option. In this blog we will learn formatting of query output using FOR JSON clause with …

Read More
SQL Server

FOR JSON Clause With AUTO mode In SQL Server 2016

June 30, 2015July 31, 2015 - by Kapil Singh Kumawat - Leave a Comment

Hi friends, in release of SQL Server 2016 CTP2 one of the feature that introduced is JSON clause. So first question that comes in everyone’s mind is What is JSON? JSON …

Read More
SQL Server

Extended Events in SQL Server 2012

June 27, 2015July 31, 2015 - by Kapil Singh Kumawat - Leave a Comment

Hi friends, today we will discuss about new performance monitoring system Extended Events which gets introduced in version SQL Server 2012.In previous versions we were using SQL Trace for capturing events …

Read More
SQL Server

Sysmail_help_principalprofile_sp – Day 19 – SQL Server System Stored Procedure

June 15, 2015July 31, 2015 - by Kapil Singh Kumawat - Leave a Comment

Hi friends, in this blog of SQL Server system stored procedure we will continue with another database mail stored procedure sysmail_help_principalprofile_sp. Sysmail_help_principalprofile_sp stored procedure list the information about associations between database …

Read More

Posts navigation

1 2 3 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.