Our Blog

Latest news and updates from flathost

Union and Union All in MSSQL

Posted by Cris E. on 12 07 2016. 0 Comments

The union functionality in SQL is a fairly simple concept that some people may not understand or use properly. To put it the simplest way possible,  all it does is stack two result sets on top of each other. That’s it. Below is a visual representation of the UNION ALL command. Result…

READ MORE

Finding Duplicates in Excel using the COUNTIF Formula

Posted by Cris E. on 27 04 2016. 0 Comments

A common task for a data analyst or technical analyst is finding duplicates in Excel. In this article, we are going to accomplish this by using the COUNTIF formula. The benefit of using COUNTIF rather than the “Remove Duplicates” button in the Data tab is that the latter immediately deletes the…

READ MORE

Avoid Mistakes by Easily Identifying What Server You’re Logged Into in SQL Server Management Studio (SSMS)

Posted by Cris E. on 29 02 2016. 0 Comments

This next tip is a lifesaver. If you’ve never ran a script on the wrong server, you haven’t been working in SQL long enough. It’s one of the most common “OH CRAP!” moments experienced by many SQL developers. Sometimes we have to pay for our over confidence. Let me just truncate…

READ MORE

Get Latest Row of Data When Multiple Entries are in the Same Table

Posted by Cris E. on 26 02 2016. 0 Comments

This is a common situation I find myself running into quite frequently. Let’s say we have a SQL table that holds several entries (or rows) for the same object but for different dates. A good example of this is a list of products, their prices, and the dates that a certain…

READ MORE

SQL Server Management Studio (SSMS) Keyboard Shortcuts

Posted by Cris E. on 24 02 2016. 0 Comments

Life can be made much easier by setting frequently used commands as keyboard shortcuts. SQL Server Management Studio (SSMS) gives us the ability to do this. I like to see sample data in tables that I am querying so I know what I am looking for. Therefore, I’m always typing…

READ MORE