Format Date in SQL Server

It’s very common to show the current date (i.e., month, day, and year) in different formats. Although you can obtain the current date with Microsoft SQL Server’s GETDATE function, getting the returned date in the format you need can take a lot of effort and code. The FormatDate UDF (user-defined function) provides dates in various formats by using the following options: Continue reading »

A simple custom Tablet stand!

So we where on a plane directed to Egypt with all the gadgets we could get to make a pleasant trip and view movies! The list included:

• a Tablet,
• one USB drives full of movies
• another USB drive full of TV Shows
• a micro SD Card with music tracks
• my Nokia Lumia with movies and TV shows for backup (just in case the tablet dies out)
• two headphones
• a jack splitter to use for both of us.

But there was one thing we didn’t get: a tablet Stand!! Continue reading »

How to know it’s a Spoof Email?

I’ve had many clients asking if they are safe to open a particular email. Some emails would be really valid, but most emails would be fake. So next are some points to help identify fake emails:

• An authentic email really coming from a particular company will address you by your first and last names or your business name.
• It will not ask you for sensitive information like your password, bank account or credit card details.
• Most fake emails threaten that your account will be in jeopardy if you do not take action immediately.
• An email that urgently requests you to supply sensitive personal information is usually an attempt at fraud.
• Fake emails often contain misspellings and grammatical errors or are written in a language which you did not set as preferred for your PayPal account.

Remember not to click any links in suspicious looking emails. Stay safe

Quickie – Concatenate Rows as a String

Today I needed to concatenate a field from multiple rows in SQL Server to get a list of people names. Instead of doing it in code, you can use the following syntax:

DECLARE @Names VARCHAR(8000)
SELECT @name = ”
SELECT @Names = @Names + ‘,’ + Names FROM People
SELECT SUBSTRING(2, @Names, 7998)

Happy Concatenating!!

Reference