Brenner Lira

Data Scientist, Data Analyst and Business Intelligence Analyst

Dublin (DN, Ireland)

  • Has completed
    profile
  • Authored 2
    articles
  • Professional
    community member
  • Community
    thought leader
  • Community
    expert
  • Community
    expert & mentor
  • Most Valued
    Professional
  • Certified
    Professional
  • Microsoft
    Certified Trainer

Projects and Achievements

  • What did you achieve?

    Please enter a headline

    In 100 words or so, what made this achievement special?

    Please enter a description

    Skills used or developed

    Please add at least one skill

    Detailed information

    Achievement Details

    • Please ensure that the start date is before the end date (or can you time travel?!)
    Summary
  • Brenner has not told us about any achievements yet.

Key Skills

Brenner has not yet created any achievements mentioning skills.
Verified with

Training and Certifications + Add Education / Certification

  • Brenner has not told us about any training or certifications that they have completed yet.
  • Please ensure that the start date is before the end date (or can you time travel?!)
    Name of course / certification

    Please enter the name of the course / certification

    Please enter the name of the organization

    Skills developed

    Please add at least one skill

Articles by Brenner

  1. How to remove HTML tag using SQL?

    If you have your data with tags like < div>,< span> , < br> , etc. You can use the function below to remove this characters from your string. Blog.The function removes all content between the characteres < , > and also that characteres too.The HTMLString is the input for the function below, the column ClearString is the output for the function below.I hope that will help you.Cheers!
  2. MS SQL: Google Maps API

    This article will show how to calculate the distance beween two addresses using Google Maps API. Blog.I was looking to an easy way to calculate the distance between two addresses using SQL and Google Maps Distance Matrix API and I found this post from stackoverflow very useful.Here is how I use the Google Maps Distance Matrix API:CREATE PROCEDURE [dbo].[CalculateDistance] ( @ToAddress NVARCHAR(100) = '', @FromAddress NVARCHAR(100) = '', @DistanceistanceInKm FLOAT OUTPUT ) ASBEGINDECLARE @Object...
  3. Edit DRAFT Edit

    • updated