SQL Server Business Intelligence (BI) – Traditional Tools and Technologies

Total: 1 Average: 5

If Business Intelligence (BI) is in your focus, you need two things to be a success. They are the knowledge and tools. If you target the SQL Server BI, you can benefit from the tools and technologies offered by Microsoft for this case particularly.

The current article highlights these tools and technologies. We are going to explore how they work to design Microsoft-based BI solutions and clarify why it is so crucial to use the using proven tools for serving the BI needs of an organization.

Read More

Basics of SQL Server Management Studio (SSMS) – Part 1

Total: 1 Average: 5

This article aims to share the basics of SQL Server Management Studio, commonly known as SSMS, and some useful tips on working with it. Also, it highlights the importance of SSMS as database development and administration tool.

About SQL Server Management Studio

It is always good to clarify the SSMS definition(s) first. Let’s review some of the definitions from the database perspective.

Read More

Best SQL Tools for Database Developers and Administrators

Total: 23 Average: 3.9

For a SQL database developer, it is essential to have the necessary SQL tools in hand, which enable to reduce the development time of given functionality. The same is true for the tester. For a database administrator, it is also important to have monitoring tools.

In this article, we are going to look at some MS SQL Server development and monitoring tools, such as:

Read More