In 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 »
Execution Plans in SQL Server
March 10, 2020Introduction
In this article, I’m going to explain what the Execution Plans in SQL Server are and how to understand the details of an execution plan by reading the various metrics available once we hover over the components in the plan.
Read more »
Monitor Transaction Log shipping using T-SQL and SSMS
March 10, 2020Database Administrators are vigilant on the backup and restore processes and use the Monitor Transaction log for the same. SQL Server Transaction Log shipping’s prime steps are Transaction Log backup, copy and restore. The answer to solving Disaster Recovery (DR) at the database level can be achieved by SQL Server Transaction Log shipping.
Read more »
SQL Server SESSION_CONTEXT() function with examples
March 9, 2020This article explores the SQL Server session context function, SESSION_CONTEXT() and performs its comparison with the function, CONTEXT_INFO().
Read more »
How to determine free space and file size for SQL Server databases
March 9, 2020In this article, we will discuss the actual database file size and free space in the database file size with the help of monitoring script and shrink solutions. While creating a database initial size of the database files (Data File and Log File) can be defined by us, with the Autogrowth and MAXSIZE parameter. The initial size will be the same as the model database if by chance user forgot to define the initial size parameter while creating a database or do the same intentionally.
Read more »
Python scripts to format data in Microsoft Excel
March 9, 2020In this article, we will use Python scripts for data formatting in Microsoft Excel sheet with various examples.
Read more »
How to install SQL Server 2012 express edition
March 9, 2020In this article, I am going to explain how we can install SQL Server 2012 express edition using the SQL Server installation center. Additionally, I will also explain how we can use the SQL Server installation configuration file to perform an unattended (silent) installation. First, download the SQL Server express edition from this location. Once the installation file is downloaded, let us begin the installation process.
Read more »
How to configure SQL Server Log Shipping
March 5, 2020SQL Server Log shipping provides a DR (disaster recovery) solution for the SQL Server databases and it can be configured at the database level. In a specific time-gap, SQL Server Transaction Log backup will be taken and copied to the destination site and will be restored. This complete activity or solution will be done by SQL Server job and each step is configured by the user. The learner may confront the difficulties in a couple of steps or while troubleshooting but for the experienced user, it is too easy to set up and handle the SQL Server log shipping set up errors.
Read more »
Learn SQL: User-Defined Stored Procedures
March 5, 2020Stored procedures (SPs) are one more powerful database object we have at our disposal. They can help us handle many tasks and improve performance and security. Today, we’ll take a look at simple SPs and show, on examples, how to use them.
Read more »
SQL Server Auto Shrink database property
March 5, 2020In this article, we will discuss the SQL Server Auto Shrink database property, which allows SQL Server to automatically shrink the database files when the value is configured as True in the database option. Automatic shrink operation is done by the server auto shrink database feature, which is the main course of this article.
Read more »
How to filter objects in SSMS 2016
March 5, 2020This article explains different ways to filter the objects in the object explorer of the SSMS 2016. When we are working with hundreds of databases or hundreds of objects within a database, then it becomes challenging to locate a specific database or database object. To handle such challenges, we can use the filter option in the SQL Server management studio. In the SQL Server management studio, we can apply a filter on the following objects.
Read more »
CREATE VIEW SQL: Modifying views in SQL Server
March 5, 2020In my previous article, we looked at how to use the CREATE VIEW SQL statement to create views. In this one, we are moving on and focusing on how to modify views. We will continue using examples on a sample database and data created in the first write-up so in order to follow along, head over and read the Creating views in SQL Server part before starting with this one.
Read more »
Implementing Star Schemas in Power BI Desktop
March 4, 2020In this article, you will see how to implement a star schema in Power BI. Microsoft Power BI is a business analytics tool used to manipulate and analyze data from a variety of sources.
Read more »
How to use database backups to recover data after SQL Delete and SQL Truncate statements
March 4, 2020This article explores the recovery of data removed by SQL Delete and SQL Truncate statements using SQL database backups.
Read more »
The Power BI Data Model: Working with Relationships
March 4, 2020In this article, we look at how to create different types of relationships between two or more tables in the Power BI data model.
Read more »
SSIS: Execute T-SQL Statement Task vs Execute SQL Task
March 4, 2020T-SQL (Transact-SQL) is a set of SQL language programming extensions developed by Sybase and Microsoft. These extensions are adopted in Microsoft SQL Server and it provides a powerful set of functions to execute analytics and administrative commands; also it is very helpful during data wrangling.
Read more »
SQL Server Query Store options in SSMS 18.4
March 4, 2020In this article, we will run through the new options added in the Query Store with SSMS v18.4.
Read more »
Getting started with Query Editor in Power BI Desktop
March 3, 2020Power BI is a data analytics tool developed by Microsoft used to visualize data and find useful insights. In this article, you will see how to work with the Query Editor in Power BI desktop. Power BI comes in various versions, i.e., Power BI Desktop, Power BI Service, Power BI Mobile, and Power BI Developer. Power BI desktop is the free version, and the query editor is available in all three versions.
Read more »
How to export data from Excel into multiple tables in Azure SQL Database using SSIS
March 3, 2020In this article, I am going to explain how we can split the data within the excel file and upload it to the tables created on the Azure SQL database.
Read more »
Overview of the T-SQL If Exists statement in a SQL Server database
March 3, 2020This article walks through different versions of the T-SQL IF EXISTS statement for the SQL database using various examples.
Read more »
SQL Server Replication Interview Questions & Answers
March 2, 2020In this article, we will discuss a number of interview questions that cover the SQL Server Replication concept, components, types, and troubleshooting scenarios.
Read more »
SQL AVG() function introduction and examples
March 2, 2020In this article, we will learn the SQL Average function which is known as AVG() function in T-SQL. AVG() function is an aggregate function that calculates the average value of a numerical dataset that returns from the SELECT statement.
Read more »
SQL Server Always On Availability Groups Interview Questions & Answers
February 28, 2020In this article, we will discuss a number of interview questions that you could be asked about the SQL Server Always On Availability Groups feature when attending an interview for the SQL Server database administrator role.
How to migrate SQL data to Azure Cosmos DB
February 27, 2020In this article, I have explained the step by step process of migrating data from SQL Server to Azure Cosmos database. To perform database migration, we will proceed in the following manner:
Read more »
Azure Data Explorer for beginners
February 27, 2020This article discusses what exactly an Azure Data Explorer is and its important features. We will also walk through the Kusto query language and explore a sample data in the Data Explorer in Azure.
Read more »