Practical use of approximate match and exact match in Vlookup function of excel. via How to use Approximate and Exact match in VLOOKUP function? — Excel Mode

Question: How to Kill User Sessions (SPID) in SQL Server? Answer: Before I answer this question, I need to ask one more question – “Why do you… Read more “How to Kill User Sessions (SPID) in SQL Server? – Interview Question of the Week #140 — SQL Authority with Pinal Dave”

Managers complain that they don’t have time to monitor and manage their team’s energy. Yet, when their car gets close to “E”, they take time to fuel… Read more “How to Bring the Power of Purpose into Daily Practice — Leadership Freak”

Introduction At times a user may perform UPDATE operation or DELETE operation in SQL server database without applying the WHERE condition. This is a very common reason… Read more “Recover Deleted Data from SQL Table Using Transaction Log and LSNs — Prashanth Jayaram”

In these article, let us discuss about the rank functions in SQL server. The ranking functions are the subset of built-in functions in SQL Server. It provides… Read more “Rank functions in SQL Server — My coding exploration”

Databases are platforms that are designed to securely store and retrieve your data. Perhaps that’s why they’re called a data “base”? So if your data is in… Read more “SQL Server: The danger of large data types — SQL TECH BLOG”

In the world where Data is the new oil, there is an overwhelming demand for organizations to provide data-driven business decisions. Numerous Business Intelligence tools are being… Read more “Developing Metadata-Driven ETL Framework Using SQL Server — For the Love of Code and Data”

I have this expense monitoring in MS Access. This is feature-rich. Reports, Analytics, you name it. But it is hard to use. It is only usable when… Read more “My Experience in Building a Multitenant ASP.NET MVC Application with Continuous Delivery in Microsoft Azure — For the Love of Code and Data”

SQL Server 2016 provides built-in support for storing, managing and parsing JSON data. Sometimes you might need to just extract one scalar value from the JSON data,… Read more “JSON_VALUE Function in SQL Server 2016 — dotnetvibes”