Archive

Archive for the ‘Application’ Category

Gartner Magic Quadrant BI and Analytics

February 18, 2017 Leave a comment

It is very interesting to see a consistent growth of Microsoft in BI and Analytics environment. Lets see Gartner’s Magic Quadrant BI and Analytics graph so several years.

2013

2013_mq

2014

2014_mq

2015

2015_mq

2016

2016_MQ.png

2017

2017_mq

We will revisit next year to see what-else has changed. By the way, what is your favorite tool.

Advertisements
Categories: Application, SQL Server, Tools

Compare and Merge Code in two different files – File compare tool

January 8, 2013 Leave a comment

WinMerge is an open source differencing and merging tool for Windows. This tool can compare both folders and files and present differences in a visual text format. It is more readable and gives precise information.

I found this tool very useful for me while developing SQL files for my project. Me and my team has developed lot of SQL query files as part of our project. Often, we exchange our ideas and lot of codes in SQL files. Each file is a module in our project. Unknowingly, we have got lot of SQL files for each module. We do have comments in each file. But, some of the files as minor changes that is very hard to eye-ball entire file.

I know we should have TFS or some version control software to handle this. But, This is not the time to think about that. We need to find the differences between some files to get the exact logic we implemented for that module.

I did the Google search as usual and found this tool. This tool helped me a lot and suggest you to just download and use this tool.

File Comparison

filecmp

You can download this tool here.

Real-Time Database Object Monitor

October 9, 2011 Leave a comment

Real-Time Database Object Monitor (RTDBOM) is a simple SSRS report. It helps to monitor the changes in a database objects such as

  • Tables
  • Views
  • Stored Procedures
  • Functions

This report as a home page and 4 separate pages for each object with navigation option. So, you can move from the home page to other pages and vice versa.

Each object report is design with conditional coloring. It shows the latest modified object row in yellow color.

One additional feature is, reports have auto refresh option. It refreshes object information every 60 seconds.

For now, Data Source is configured with static connection string. In future release, RTDBOM will have more objects list and features to help database developers and administrators to keep track on the changes happening in the database environment.

Report download, If you use this project, please do not change or remove string “SQLServerRider.com”.

Thanks for reading.

Tweets and hashTag Stats in Excel

June 12, 2011 1 comment

Today, I am going talk about an analytics for Twitter application.

It is a PowerPivot application that connects to tweeter within Excel 2010 and gives your tweet statistics. I found it very interesting because, we can pass our own tweet account and gets the information such as no. of tweets per day, top tweeters, top mentions, top hash tags and so on.

It has a very beautiful interface with native features of PowerPivot and Excel. Components which are more attractive in the front screen are charts of different types, slicer and textual stat of the tweets.

Screen Shot of the Application

Instead of talking more about the application, I would recommend you to download the application from the Microsoft website.

Download Now

There are some prerequisite to run this application. So, please read the instruction.

 

 

 

Analysis Services and PowerPivot team blog

Thanks for reading. Also, Join my Facebook account to see the latest news about Microsoft SQL Server.

 

%d bloggers like this: