Introduction
Soon enough, the applications and database software we build will handle date and time values. The T-SQL Toolbox database – a free download – can help solve complex calculations with those values.
Read more »
How to drop temp tables in SQL Server
March 23, 2020Temporary tables, also known as temp tables, are widely used by the database administrators and developers. However, it may be necessary to drop the temp table before creating it. It is a common practice to check whether the temporary table exists or not exists. So, we can eliminate the “There is already an object named ‘#temptablename’ in the database” error during the temporary table creation.
Read more »
An overview of the sp_WhoIsActive stored procedure
March 23, 2020This article gives a comprehensive overview of custom stored procedure sp_whoisactive.
Read more »
Learn SQL: SQL Triggers
March 20, 2020SQL Triggers are another powerful database object we have at our disposal. In previous articles, we’ve covered user-defined functions, user-defined procedures, and SQL Views. Today we’ll talk about SQL triggers and how to use them to achieve the desired behavior.
Read more »
Visualize Coronavirus impact using a Power BI Dashboard
March 20, 2020This article demonstrates Power BI visuals for visualizing Coronavirus impact worldwide using various visuals such as a filled map, Word Cloud, Slicer, Q&A.
Read more »
Setting up Power BI Data Gateway
March 19, 2020In this article, I’m going to explain what a Power BI Data Gateway is and how to set it up. I’ll also cover the underlying architecture that the gateway uses and how to manage on-premise data using the Data Gateway.
Read more »
How to install MySQL database server 8.0.19 on Windows 10
March 19, 2020In this article, I am going to explain the step by step installation process of MySQL database server 8.0.19. MySQL is open-source, cross-platform relational database management server developed by Swedish company “MySQL AB” and later acquired by Oracle corporation. MySQL is offered as an open-source MySQL community server edition and enterprise server edition. In this article, I am going to install the MySQL Community server edition.
Read more »
SQL Server MAX() aggregate function
March 19, 2020SQL Server provides us with several aggregate functions that can be used to perform different types of calculations on a set of values, and return a single value that summarized the input data set. These SQL Server aggregate functions include AVG(), COUNT(), SUM(), MIN() and MAX().
Read more »
SQL Server TOP clause overview and examples
March 19, 2020This article explores the SQL Server TOP clause using various examples, along the way, we will also run through performance optimization while using the TOP clause in SQL Server.
Read more »
A beginner’s guide to Azure Databricks
March 18, 2020This article serves as a complete guide to Azure Databricks for the beginners. Here, you will walk through the basics of Databricks in Azure, how to create it on the Azure portal and various components & internals related to it.
Read more »
An overview of the SSIS FTP Task
March 18, 2020In this article, we will explain the File Transfer Protocol (FTP), and we will give an overview of the FTP task in SQL Server Integration Services (SSIS) and FTP connection manager.
Read more »
Conditional formatting in Power BI
March 18, 2020In this article, I’m going to explain what conditional formatting in Power BI is. Conditional formatting, as the name suggests, is a way of visualizing data that applies special format rules based on some pre-defined conditions on the values of a selected metric. It is mostly used when the data is presented in a tabular format; however, it can also be used in any charts such as bar charts, line charts, etc.
Read more »
Using external C# script files within Biml
March 17, 2020In the previously published article, Extending Biml with C# scripts, we have explained how to use VB or C# scripts within the Biml code to prevent doing repetitive development work. But in this solution, the C# scripts and classes are only available within a single file while we may need to use them in many.
Read more »
How to access data from Azure Blob Storage using Power BI
March 17, 2020In this article, I am going to explain how we can access the data from the Azure Blob Storage using Power BI. To do that, we are going to use the below tools:
- Azure BLOB Storage account: We have uploaded the source CSV file to it
- Power Query editor: To choose the data that we want to load in the Power BI report
- Power BI Desktop: To view the data imported from the CSV file
Monitoring activities using sp_WhoIsActive in SQL Server
March 16, 2020In this article, we will talk about sp_WhoIsActive stored procedure and how we can use it to monitor currently running activities in SQL Server.
Read more »
How to sort months chronologically in Power BI
March 16, 2020In this article, I’m going to demonstrate how to sort months chronologically in Power BI. Visualizing sales data in a time period is one of the most influential ways of reporting. Often, at times it is essential that you design charts that show the trend or growth of a metric over time. The time period can be anything for example days, weeks, months, or years. It basically gives you the idea of how the metric has increased or decreased over the specific period.
Read more »
Extending Biml with C# scripts
March 16, 2020In our previously published articles in the Biml series, we have explained what Biml is, and how to use this language to generate SQL Server Integration Services (SSIS) packages. In this article, we will explain BimlScript, which is an extension of this markup language with VB or C# scripts.
Read more »
CREATE VIEW SQL: Inserting data through views in SQL Server
March 16, 2020This is the third article in a series of learning the CREATE VIEW SQL statement. So far, I’d say that we’re comfortable and familiar with the syntax, and we’ve learned how to create and modify views. In this part, we’ll continue to work on views using the sample database and data that we created so far.
Read more »
Python scripts for pivot tables in SQL Server
March 13, 2020This article talks about Python scripts for creating pivot tables in multiple ways.
Read more »
Using Biml scripts to generate SSIS packages
March 13, 2020In the previous article, Converting SSIS packages to Biml scripts, we explained how to convert existing SSIS packages into Biml scripts using Import Packages tool and we mentioned that this could be an efficient way to learn this markup language since it lets the user compare between the well-known SSIS objects found in the package and the correspondent elements in the generated scripts.
Read more »
Converting SSIS packages to Biml scripts
March 13, 2020In our previous article, Getting started with Biml, we have explained what Biml is, what are the related tools and resources and how to get started with this technology. In this article, we will explain how to generate scripts from existing SSIS packages by showing all related options. Then, we will analyze the generated script and identify how each object is mentioned in the script.
Read more »
Learn SQL: SQL Views
March 11, 2020SQL views are another powerful database object we have at our disposal. In the previous two articles of this series, we’ve talked about user-defined functions and user-defined procedures and showed simple examples of how to use them. Today, we’ll do the same for the SQL views.
Read more »
A comprehensive guide to the SQL Format function
March 11, 2020This article explains the usage of SQL Format function and performance comparison with SQL CONVERT.
Read more »
Database Design and Logical Asseveration for SQL Query Optimization
March 11, 2020Database design and Logical Asseveration play a vital role in database performance and SQL Query optimization. Both have different parameters to make your database and the query accurate.
Read more »
How to install MySQL on Ubuntu
March 10, 2020In this article, it will be shown how to install MySQL 5.7 and 8.0.19 versions on an Ubuntu 18.04 machine.
Read more »