This article explores Visual Studio Code integration with Git Source Control.
Read more »Enhancing Data Analytics with SSAS Dimension Hierarchies
July 22, 2020Introduction
This article will discuss how SSAS Dimension Hierarchies can be used to analyze data much efficiently. If you are a data analyst, you want to start the analysis with a higher hierarchy. Then navigate the narrow attributes when required. For example, it will be better to start with analyzing revenue by year. If you need to analyze further into the data, you can choose the needed year and expand the Quarter -> Month, respectively. Let us see how we can create SSAS Dimension Hierarchies in OLAP Cubes to suit different requirements.
Read more »Backing up AWS RDS SQL Server databases with AWS Backup
July 21, 2020This article gives you an overview of creating backups of AWS RDS SQL Server database instances using AWS Backup service.
Read more »How to catalog AWS RDS SQL Server databases
July 21, 2020This article gives you an overview of cataloging AWS RDS SQL Server database objects like tables and views, using AWS Glue service.
Read more »How to connect AWS RDS SQL Server with AWS Glue
July 17, 2020This article gives you an overview of configuring AWS RDS SQL Server with AWS Glue service that is used in AWS for cataloging and ETL operations.
Read more »An introduction to SQL tables
July 17, 2020In this article, we will learn the concept of SQL tables and then work on how we can create tables with different techniques in SQL Server.
Read more »Access AWS Redshift from a locally installed IDE
July 17, 2020This article gives you an overview of configuring the AWS Redshift cluster to use it from a locally installed IDE or tools.
Read more »Page Life Expectancy (PLE) in SQL Server
July 17, 2020Page Life Expectancy (PLE) is an age of a data page in seconds in the buffer cache or buffer memory after querying the tables with the loading data page into the buffer memory. Page Life Expectancy value indicates the memory pressure in allocated memory to the SQL Server instance. In most of the cases, a page will be dropped from buffer periodically.
Read more »Getting started with AWS Redshift
July 16, 2020This article gives you an overview of AWS Redshift and describes the method of creating a Redshift Cluster step-by-step.
Read more »SQL Server 2019 Memory-Optimized TempDB Metadata
July 16, 2020In this article, I will walk you through the new feature in SQL Server 2019, memory-optimized TempDB metadata. The most commonly faced performance problems in SQL Server world is known to be TempDB resource contention. Don’t you agree? Let us find the answer in this article.
Read more »Visual Studio Code (VS Code) for SQL Server development
July 16, 2020In the previous article, Getting started with Visual Studio Code (VS Code), we took a detailed overview of the popular code editor. It supports various programming languages t-SQL, Python, PHP, AWS CLI, PowerShell, etc. We need to use extensions in the VS code to work with these languages. For example, if we open the T-SQL script, it recommends you for the below extension.
Read more »Prediction in Azure Machine Learning
July 16, 2020Introduction
After discussing the basic features of Azure Machine Learning and how to clean the data from Azure Machine Learning, let us look at how to perform prediction in Azure Machine Learning. Prediction is one of the important aspects of Machine Learning as it will help to make strategic decisions.
Read more »How to resolve deadlocks in SQL Server
July 15, 2020In this article, we will talk about the deadlocks in SQL Server, and then we will analyze a real deadlock scenario and discover the troubleshooting steps.
Read more »Install SQL Server 2019 on Windows Server 2016 with SQL Server Always On Availability Groups
July 15, 2020In this article, we will proceed with configuring a SQL Server Always On Availability Groups and perform failover validations.
Read more »Launch a static website using AWS S3 buckets
July 15, 2020This article explores the AWS S3 bucket to configure a static website.
Read more »Understanding common Data Structures
July 15, 2020In this article, I am going to walk you through the concepts of the common Data Structures that every student, colleague working with computers should be aware of. Data Structure forms an integral part of any system or database design. It is a very interesting and intuitive concept that you can apply anywhere. Through this article, I aim to introduce the beginners to the concepts of Data Structures and brush up the same for colleagues who have already been associated with the industry for years. This will also help you understand some database concepts more easily once you have a grasp over these concepts.
Read more »Configure failover clusters, storage controllers and quorum configurations for SQL Server Always On Availability Groups
July 14, 2020This article explores the configuration of Windows failover clusters, storage controllers, and quorum configurations for SQL Server Always On Availability Groups.
Read more »Migrate Power BI reports between multiple workspaces
July 14, 2020In this article, I am going to explain how we can create a Power BI Report using the Power BI Desktop and then publish it to the Power BI service workspace. Once the report is published to a workspace, we can also consider migrating the same report across several workspaces and all this can be done programmatically by using the Power BI REST APIs. This article is specially targeted towards Power BI admins or DevOps team whose task is to migrate dashboards between various environments like Development, QA, Production, etc. without any manual intervention of the reports.
Read more »Automating Azure SQL Database index maintenance using Elastic Job Agents
July 14, 2020In this article, I am going to explain how we can automate the index and statistics maintenance of Azure SQL Database using an Elastic Job Agent.
Read more »Move SQL databases to a different server using SQL Server log shipping
July 14, 2020As a SQL Server DBA, we are responsible for moving the customer SQL databases to other servers. Recently, I was assigned the same project. One of the customers wanted to move their SQL database to a separate server. Following were the challenges:
Read more »Getting started with SSISDB
July 13, 2020In this article, I am going to explain how to start using the SSISDB database, also known as the SSIS Catalog database. In my previous article, I have provided an overview of this SSIS catalog database in detail. I would recommend you read that article, before moving on further with this if you want to understand how the SSIS catalog database works. The SSIS catalog database is one single database in which you can deploy all your SSIS packages and then organize and manage those packages centrally.
Read more »Configure Domain Controller and Active Directory for SQL Server Always On Availability Groups
July 13, 2020In this series for SQL Server Always On Availability Groups, we are covering end to end configurations for SQL Server 2019 on Windows Server 2016. In the article, A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016, we configured three virtual machines with their networking configurations.
Read more »A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016
July 13, 2020In this article, we will configure a SQL Server Always On Availability Group on the Windows Server 2016. We use SQL Server 2019 for configuration.
Read more »Deploy Python apps to Azure Functions using Visual Studio Code
July 10, 2020In this article, we are going to build a small python application and deploy it to Azure Functions. The development and the deployment will be done using the Visual Studio (VS) Code. As you might be aware, VS Code is one of the most widely used and preferred code editors for programmers. It is a cross-platform tool, which means you can install this tool on any operating system of your choice, starting from Windows, Linux, or Mac OS.
Read more »SQL UPDATE syntax explained
July 10, 2020This article will get you familiar with the SQL UPDATE syntax and demonstrate how this statement can be used for modifying data using T-SQL. Data modification side of DML language in T-SQL includes three statements used for modifying data in SQL Server and those are: INSERT, UPDATE, and DELETE. The focus here will be on the UPDATE statement explicitly.
Read more »