Most RecentMost ViewedMost LikesDROP IF EXISTS - new thing in SQL Server 2016First published on MSDN on Nov 03, 2015 In SQL Server 2016 CTP3 objects can DIE (DROP IF EXISTS)Do you like to write following conditional DROP statements:IF OBJECT_ID('dbo.Under the covers: GAM, SGAM, and PFS pagesFirst published on MSDN on Jul 08, 2006 (Been a week or so since the last post but I haven't burnt out with blogging yet - I was on vacation over the July 4th weekend and totally offline in and around a small town called Pullman in south-eastern Washington.How to use DBCC PAGEFirst published on MSDN on Jun 10, 2006 Yes, finally I come clean and tell all.Calling Http endpoints in T-SQL using CURL extension First published on MSDN on Apr 17, 2018 SQL Server Database Engine don't have built-in functions that would enable you to send information to some API using http protocol. Import and analyze IIS Log files using SQL ServerFirst published on MSDN on Feb 10, 2017 IIS generates logs where are recorded many information about HTTP requests such as what Url was called, when the request happened, what is the origin, etc.Loading GeoJSON data into SQL ServerFirst published on MSDN on Jan 05, 2016 GeoJSON is popular format for spatial data representation.Returning spatial data in GeoJSON format - Part 2First published on MSDN on Jan 13, 2016 In the previous post Returning spatial data in GeoJSON format - Part 1, I have described how you can export Sql Server spatial data to GeoJSON.Returning child rows formatted as JSON in SQL Server queries First published on MSDN on Oct 09, 2015 In this post I will talk about one annoying thing – how to return a result set containing one to many relationships between tables. Building SQL REST API back-end for Angular appsFirst published on MSDN on Dec 18, 2017 JSON support in SQL Server/Azure SQL is designed to make integration between the relational database models and the modern single-page JavaScript apps easier than ever.Combining relational and NoSQL concepts in SQL ServerFirst published on MSDN on Sep 01, 2015 IntroIn this article we will see how you can combine NoSQL and relational concepts in SQL Server database.
