SQL Server Execution Plan formats
Execution plan helps in knowing how a query gets executed and troubleshooting a query which is performing poor. In SQL...
2016-09-14
842 reads
Kapil Singh
Importance of Database Backup In SQL Server
Overview To save any organisation from any big future loss, one needs make a proper strategy or disaster plan that...
2016-09-01
482 reads
Limitation of In-Memory OLTP in SQL Server 2016 – Sp_rename not allowed
Hi friends, one more limitation of In-Memory OLTP is SQL Server 2016 is that sp_rename is not allowed to change...
2016-07-21
495 reads
Getting started with In Memory OLTP in SQL Server 2016 – Part 1
In Memory OLTP (Hekaton) introduced in SQL Server 2014 is a new database engine component which is optimized for OLTP...
2016-07-18
695 reads
Limitation of In-Memory OLTP in SQL 2016 – Create Index is not supported
Hi friends, in this blog I will discuss another limitation of In Memory OLTP in SQL Server 2016. Once you...
2016-07-17
462 reads
SQL Server – How to retrieve SQL plans from Cache
Hi friends, in this blog post I will tell you how we can retrieve the SQL plan from the cache....
2016-07-13
647 reads
SQL Server – String_Escape function in SQL Server 2016
Hi friends, in SQL server 2016 another string function that introduced is String_Escape. This function can escape special characters within...
2016-07-10
1,510 reads
Microsoft SQL Server 2016 Certifications Announced
Hi friends, Microsoft has announced the release of three new SQL 2016 certifications, based on the different working database professional’s...
2016-07-08
797 reads
SQL Server – STRING_SPLIT function in SQL Server 2016
Hi friends, in SQL server 2016 another new function STRING_SPLIT gets introduced which helps in splitting the character expression using...
2016-07-06
703 reads
SQL Server – Conditions when value of @@error changes
Hi friends, when we do error handling in our SQL code we use different methods like TRY/CATCH, RAISERROR etc. to...
2016-06-02 (first published: 2016-05-24)
1,354 reads
Blogs
Microsoft Purview GA menu’s
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Connect to Power BI as a Guest User in another Tenant
Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added...
Parsing EXE Output in PowerShell
By Steve Jones
I saw a post internally that asked this question: Anyone have a handy powershell...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Azure SQL Managed Instance: RESTORE HEADERONLY is terminating abnormally. (Micro
I'm trying to restore my database into Azure SQL Managed instance from blob storage...
I'm asking for guidance on how to best discover PK-FK relationships
Last night I spent 45 minutes composing a complicated question here. When I finished...
Question of the Day
Concat Addition
What is the result of this code?
SELECT CONCAT(1, 2, 3) + 4See possible answers