In the previous articles, we covered sequential steps necessary to build a virtual machine, install Ubuntu 18.04 operating system, and configure SQL Server 2019 on that Ubuntu machine. This is 3rd part of this series. Our goal is to demonstrate the step-by-step process of installing SQL Server Tools and its components on the Ubuntu 18.04 Linux system.Read More
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
SQL Server 2019 was introduced in November 2019. The RTM version of SQL Server 2019 is 15.0.2000.5. To learn about the new features presented in this version, you may refer to SQL Server 2019 New Features.
The current article briefly explains the process of SQL Server 2019 installation on Windows Server 2016.Read More
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
What is this article about?
This is going to be the final article in the series of articles on the life of IDE developers for databases. So in this part, I will spread the word about how the introduction of product analytics impacted some aspects of development.
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: