When you develop large chunks of T-SQL code with the help of the SQL Server Management Studio tool, it is essential to test the “Live” behavior of your code by making sure that each small piece of code works fine and being able to allocate any error message that may cause a failure within that code.
Read MoreTag: sql
Data Visualization in Microsoft Power BI
Contents
- Introduction.
- How to create a table.
- How to create a Power BI pie chart.
- Creating a line chart in Power BI.
- Report creation.
- Conclusion.
Introduction
The final article will take us through Power BI Visualizations and how to create them using the data sets created previously in these series. The walkthrough will cover 3 basic Visualizations: Table, Pie Chart, and Line Chart. These will then combine to create a basic report/dashboard within Power BI.
Read MoreLoading and Managing Data within Microsoft Power BI
Contents:
- Introduction
- Importing data from Excel, SQL Server, and the Web.
- Data Manipulation Basics in Power BI.
- Managing relationships within Power BI.
- Conclusions.
Introduction
This article will cover off importing data, manipulating data, and finally managing relationships within Power BI. Again, like the previous article, this one will focus on the basic principles of using Power BI, as opposed to an in-depth walkthrough.
Read MoreLearn to Perform Product Analysis with SQL Server Full-Text Search. Part 2
This article is dedicated to a slightly more complex product analysis with Full-Text Search as opposed to the first part where we looked at how to perform a basic product analysis.
Read MoreLearn to Perform Product Analysis using SQL Server Full-Text Search. Part 1
This article considers how to perform basic product analysis using Full-Text Search.
Additionally, the readers are going to learn some practical examples of product analysis regarding sales with the help of Full-Text queries.
Read MoreCompleting SQL. Part 4. Working with exceptions and the influence of data on the development process. Using ML.NET.
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.
Completing SQL. Part 3: Complementing SQL. The life of Visual Studio extensions. Working with IO. Using SQL in unconventional ways.
What is this article about?
This is the third article in the series of articles on the life of IDE developers for databases.
Its structure will be similar to the first one and the second one, even so, I am not going to tell you about the parsing of text. This article will present information on some tricks working with files and various problems of creating a big desktop application on the .NET platform.
Completing SQL. Part 2: Optimizing string processing and file opening
What is this article about?
This is the second piece from the series of articles about the life of database IDE developers. Its structure is similar to that of the previous article. Just like in the first one, I’ll talk about the issues we faced and the solutions we arrived at – both effective and not so much. To understand this article, you don’t have to read the first part in its entirety, but the first few paragraphs would be useful to help you grasp the context.
Best SQL Tools for Database Developers and Administrators
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
Completing SQL. Part 1: The difficulties with parsing or tales of polishing ANTLR
I’ve been working for a company that develops IDEs for database interaction for more than five years. Before starting to write this article, I had no idea how many fancy tales would lie ahead. Thus after making 30 pages of it, I decided to group up the tales thematically and divide the article into several parts.