Amol Pandey

Experiments, tutorials and ideas on developing business intelligence solutions

Skip to content
Menu
  • Home
  • About Me

Tag: UDF

Dates Overlap – Get the days count overlapping between 2 date ranges (SQL)
SQL

Dates Overlap – Get the days count overlapping between 2 date ranges (SQL)

Posted on August 28, 2018August 28, 2018 by Amol Pandey

Hi, Well today’s post is a simple one, but this one which gave me a good fight to get the trick right !!! Situation: I…

MSSQL – Lets Compress those large text with loads of spaces in it via UDF
SQL

MSSQL – Lets Compress those large text with loads of spaces in it via UDF

Posted on August 24, 2018August 24, 2018 by Amol Pandey

Hi, When the data grows large, i mean really large one has to come up with ways to bring in techniques where even the slightest…

MSQL – Send Slack Notifications via CLR UDF
SQL

MSQL – Send Slack Notifications via CLR UDF

Posted on August 24, 2018 by Amol Pandey

Hi, In this post i would like to showcase a feature in which i was able to send out on-demand SQL notification to slack channel…

Hot Topics

Backup C# Catalog CD CI Code command config CSharp Cube Data Deploy Deployment Docker Gulp Jenkins Job Key long Management Master MSSQL MVC NET pandas pem Processing Python Query Report running Script Service Setup SQL SSAS SSIS SSISDB ssl SSRS TFS ubuntu UDF VSTS Web

Categories

Archives

© Copyright 2023 – Amol Pandey
Wisteria Theme by WPFriendship ⋅ Powered by WordPress