![]() ![]() Note that this installer also contains the Azure Data Studio which can also be used to connect to the database server.SQL Server Management Studio (SSMS) – this software connects to the database server and allows us to manage the server and its databases.Microsoft SQL Server 2019 software – this is the relational database server that will hold all the data tables.To take advantage of these databases, we need 3 pieces: In this article, we will go through the process of installing SQL Server, the SQL Server Management Studio, and restoring a sample database, in particular, the AdventureWorks database. This is a wonderful arrangement that allows us to explore some reasonably complex databases with powerful BI tools. ![]() Microsoft provides sample databases for download, and we can restore these databases to an SQL Server instance running on our desktop computer. Microsoft’s Excel and Power BI also have the capability to connect to databases and extract data directly from them for analysis. When learning how to use business intelligence (BI) software, we can find many examples using text or Excel files.
0 Comments
Leave a Reply. |