Posts

Simple Url shortener script using Sql and TinyURL

Image
Simple Url shortener script using Sql and TinyURL Posted On: April 16, 2019 Published By: Rachel Jaya Prabha S A URL shortener is very useful script to shorten your large URL. In this post, I explain you how to code for URL shortener. URL sharpeners are being used more now than ever because people need to post short links on Twi!er, Facebook, SMS etc. Long links can some%mes take up the en%re 140-character limit. So, the solu%on is to shrink a long URL into a short one. Example: Declare @InputURL varchar(200),@CreateURL varchar(500),@Obj Int,@TinyURL varchar(500) Set @InputURL='https://en.wikipedia.org/wiki/Search_engine_marketing' --//Create Tiny URL set @CreateURL = 'http://tinyurl.com/api-create.php?url='+ @InputURL exec sp_OACreate 'MSXML2.ServerXMLHttp', @Obj OUT exec sp_OAMethod @Obj, 'Open', NULL, 'POST', @CreateURL, false exec sp_OAMethod @Obj, 'send' exec sp_OAGetProperty @Obj, 'responseText', @TinyURL O...
Post a Comment
Read more

Power BI Beginner

Image
Power BI service Dashboards are something that differentiates Power BI service from Power BI Desktop. The main features of your Power BI service UI are the following: 1. Navigation bar 2. Dashboard with tiles 3. Q&A question box 4. Help and feedback buttons 5.Dashboard title 6. Office 365 app launcher 7. Power BI home buttons 8.Additional dashboard actions The 3 major building blocks of Power BI are:   dashboards ,   reports , and   datasets . You can't have dashboards or reports without data (well, you can have empty dashboards and empty reports, but they're not very useful until they have data), so let's start with   datasets . 1.   Navigation bar   (navbar) Use the navbar to move between the Power BI building blocks: dashboards, reports, and datasets. Select   Get Data   to   add datasets, reports, and dashboards to Power BI Expand and collapse the navbar with this icon   Use   Search ...
7 comments
Read more