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
Month: September 2017
How to Kill User Sessions (SPID) in SQL Server? – Interview Question of the Week #140 — SQL Authority with Pinal Dave
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”
How to Bring the Power of Purpose into Daily Practice — Leadership Freak
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”
Recover Deleted Data from SQL Table Using Transaction Log and LSNs — Prashanth Jayaram
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”
Rank functions in SQL Server — My coding exploration
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”
SQL Server: The danger of large data types — SQL TECH BLOG
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”
Developing Metadata-Driven ETL Framework Using SQL Server — For the Love of Code and Data
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”
My Experience in Building a Multitenant ASP.NET MVC Application with Continuous Delivery in Microsoft Azure — 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”
JSON_VALUE Function in SQL Server 2016 — dotnetvibes
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”
(Informatica)Capture One 10 – how to change default catalog folder — doraz space
By default, it places the catalog folder in the Pictures folder of OneDrive, so that OneDrive keeps synchronizing useless stuff… If you decide to change this “feature”,… Read more “(Informatica)Capture One 10 – how to change default catalog folder — doraz space”