Tag: sort

Power Query – Part 4

admin

There has been a big push for self service business intelligence tools by Microsoft in recent months. The center of this new universe is Microsoft Excel. I will carry on with talks about Power Query which is a self service ETL add-in for MS Excel. This tool was released in August of 2013. In addition to my blog, the online help is a good place to start learning about this tool. Last time, I demonstrated how the “reduce” section of ribbon has buttons that can refine the number of rows…

Crafting Views with SSMS

admin

Most of the articles that I presented so far for database development have been centered around the exact Microsoft T-SQL syntax to perform a certain operation. At the University of Rhode Island, I learnt how to program in Pascal before typing in my first ANSI SQL statement. In short, I will always be some type of developer in my heart. However, many people do not come from a computer science and math background. The SQL Server Management Studio (SSMS) has menus and dialog boxes to achieve many of the same…