Emergency Shelters And Relief Supply Drop Off Points

Hey all, today I'll be using this space for something pretty serious that is affecting my country.

Of late, Trinidad and Tobago has been besieged by endless rain, resulting in mass flooding and loss of property. Many lives are being severely affected.

To that end, I threw up a quick map using Power BI to show relief centers. The map can be found below. Please click the double sided arrow in the bottom right corner to expand to full-screen.

You can also help to add to the map by filling out the short form below:
Shelters and Drop Off Points

Thank you to all who contribute to the data collection, and I wish everyone the best during this time.


EDIT (28/12/2018):
As the emergency times have passed, I made some small changes to the map. I have added a 'State' slicer which defaults to 'Active' relief points. You can un-check it to see the full list of all those who helped during our rough times. In fact to make sure they don't go unforgotten, I've listed all the companies that I have recorded at the bottom of this post. Truly remarkable on everyone's part.

Mini Post: Detecting Orphaned Users; sp_change_users_logins

Good day all! We are all the way in October 2018 and we are due for another SQL Something! Man is the year flying by!

Today, we are looking at detecting orphaned users. In short, these are usually users that do not have an associated SQL login.

You can detect these 'orphans' using the sp_change_users_login stored procedure with the @Action='Report' option.

SSIS, Import and Export Wizard Issue: "Text was truncated". Using TypeGuessRows to Solve.

Hey everyone, Geon back from the dead with another SQL Something!

Today we take a peek at a very, *very* annoying and very old issue with importing data into a SQL Database. This problem occurs when using either the Import/Export Wizard or SSIS.

The issue can take a couple forms:

• "Text was truncated or one or more characters had no match in the target code page."
• "A truncation error occurred on the specified object of the specified component."
• Etc.

The keywords here are 'truncated' or 'truncation'.

Now you may think "Well, obviously it's probably your column lengths in the destination, so just increase that.".

Well, what if your destination columns are maxed out? What if it wasn't the destination?

I'd believe you to be honest...

Mini Post: Power BI Bookmarks Video! (Synoptic Panels Too!)

Heyyy everyone!

I'm still around! Welcome back to SQL Something!

Today I'm sharing a video I made for an in-house presentation to show the power of Power BI Bookmarks!

Now, the video doesn't actually show how it was created (I think I'll make a post on that as well as share the files), but it can give you an idea of things that are possible.

Anyway, without further ado, please see the video below:

Data with Data: Power BI Bookmarks and Synoptic Panels