2020-04-13
9 reads
Kapil Blogs
Microsoft Azure – How to enable Azure AD Multifactor Authentication using Azure Portal
In this article, we will learn how to enable the Azure AD multi-factor Authentication via Azure Portal. In previous article, we learnt how to set up Azure AD and...
2019-03-27
35 reads
Microsoft Azure – How to create the Azure Active Directory (AD) using Azure Portal
Microsoft Azure Active Directory (AD) is a cloud based service to handle the identity and access management. It has the...
2019-03-21
526 reads
Microsoft Azure – Enable Geo replication of data – Cosmos DB Part 2
In this article, we will learn how to replicate the data to any Azure region globally. Global Distribution Azure Cosmos...
2018-07-02
372 reads
Microsoft Azure – Introduction to Cosmos DB – Part 1
Hello Friends, Please find the link of new post of about Introduction to Cosmos DB and how to create the...
2018-06-04
305 reads
Microsoft Azure – Azure Mobile App is available now
Hello friends, Please check the below link for my new post on Microsoft Azure Mobile App. https://social.technet.microsoft.com/wiki/contents/articles/51525.microsoft-azure-mobile-app-is-available-now.aspx
2018-05-14
692 reads
SQL Server – TRIM() function in SQL Server 2017
Hello friends, Please check the below link of my new article on TRIM() function in SQL Server 2017 – https://social.technet.microsoft.com/wiki/contents/articles/51047.introduction-to-trim-function-in-sql-server-2017.aspx
2018-01-08
382 reads
SQL Server – TRANSLATE() function in SQL Server 2017
Hello Friends, Wish you all a very Happy New Year 2018. Please find the link of my first article of...
2018-01-01
465 reads
SQL Server – Concat_WS function in SQL Server 2017
Hello friends, Please find the link for my new article at below url – https://social.technet.microsoft.com/wiki/contents/articles/44327.sql-server-concat-ws-function-in-sql-server-2017.aspx Regards Kapil
2017-10-26
541 reads
Identity_Cache feature introduced in SQL Server 2017
Hello friends, Please find the full article at this link – https://social.technet.microsoft.com/wiki/contents/articles/40666.sql-server-identity-cache-feature-in-sql-server-2017.aspx
2017-10-11
469 reads
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers