This article will discuss one of the powerful analytics services in Azure – Azure Synapse Analytics, along with its components, features, security, and more.
Read more »
SQL Server Clustered Indexes internals with examples
October 14, 2020In this article, we will learn the SQL Server clustered index concept and some internal details. Indexes are the database objects that accelerate the performance of data accessing when are designed properly. A clustered index is one of the main index types in SQL Server and the working principle is a bit complicated but in the next sections of this article, we are going to simply learn the clustered index working principle and uncover the secrets.
Read more »
Building databases using BIML
October 14, 2020In the previously published articles in this series, we talked about the Business Intelligence Markup Language (BIML) and how to use the technology to build and manage SQL Server Integration Services (SSIS) packages. Besides managing SSIS packages, we can also manage SSAS models and build databases using BIML.
Read more »
Apply SQL Server patches or cumulative updates in SQL Server Always On Availability Groups
October 14, 2020In this 32nd article on SQL Server Always On Availability Group series, we will discuss the process to apply a service pack or Cumulative packs for AG replica instances.
Read more »
Make the most of secondary replicas in SQL Server Always On Availability Groups
October 13, 2020In this 31st article of the SQL Server Always On Availability Group series, we will explore how you can use the secondary replica SQL database for your workloads.
Read more »
An overview of the db_datareader role
October 12, 2020In this article, we are going to learn about the db_datareader role. It is a fixed, database-level role. The database-level roles are a group of security principals that are used to manage the permissions within the databases more efficiently. There are two types of database-level roles. One is a predefined database-level role, and another is custom database-level roles. The custom database-level roles can be created by the database administrator or the member of the db_owner role.
Read more »
How to clone an Azure SQL Database
October 12, 2020In this article, we will learn cloning an Azure SQL Database.
Read more »
Column-level SQL Server encryption with SQL Server Always On Availability Groups
October 12, 2020It is the 30th article in the SQL Server Always On Availability Groups series and explores column-level SQL Server encryption with AG groups.
Read more »
Data Virtualization with MongoDB using PolyBase in SQL Server 2019
October 9, 2020In this article, you’ll learn the approach to integrate MongoDB data source using data virtualization technique in SQL Server 2019. In this article, you can see how SQL Server 2019 provides a platform to create a modern enterprise data hub using data virtualization technology and the PolyBase technique.
Read more »
Install SQL Server Express on Windows Server 2016 using docker containers
October 9, 2020In this article, we will install the SQL Server Express edition on Windows Server 2016 using a SQL Server Docker container.
Read more »
Performing a Load Test on SQL Server using Apache JMeter
October 7, 2020In this article, we will learn how to use Apache JMeter to perform a load test on SQL Server. This test type enables us to measure the application behaviors under specific conditions so that it enables us to observe a variety of resource consumptions (CPU, memory, latency, response times, etc) and it also helps to detect the performance bottlenecks. Database testing can help to find out and identify the problem when the database working under high workloads with multiple users. The database people can identify and fix the performance issues before publishing the database into the production through these tests.
Read more »
SQL Server Always On Availability Groups for SQL Server Linux instances
October 6, 2020In this 29th article of the SQL Server Always On Availability Groups series, we configure the AG between SQL Server Linux instances.
Read more »
Create a Serverless Azure SQL Database
October 6, 2020In this article, we will take a look at how to create a serverless Azure SQL database.
Read more »
Prediction with Regression in Azure Machine Learning
October 6, 2020Introduction
We will be discussing one of the most common prediction technique that is Regression in Azure Machine learning in this article. After discussing the basic cleaning techniques, feature selection techniques and principal component analysis in previous articles, now we will be looking at a data regression technique in azure machine learning in this article.
Read more »
![user database [LinuxAGSQL]](https://s33046.pcdn.co/wp-content/uploads/2020/10/user-database-linuxagsql-624x475.png)
Restore a SQL database from Windows SQL Server to SQL Server Linux instance
October 5, 2020Database professionals get the standard requirement for SQL database restores from production to non-production instances. As you know, SQL Server runs on the Linux and Windows operating systems starting from SQL Server 2016. Suppose you are exploring the SQL Server Linux instance features and configurations.
Read more »
Create an Azure SQL Database with built-in sample data
September 30, 2020In this article, we will learn to create an Azure SQL Database with built-in sample data.
Read more »
Four different methods to copy your Azure SQL database
September 30, 2020In this article, we will see different methods to copy the Azure SQL database. With the advent of all the business dynamics available in today’s IT industry, there is a huge paradigm shift towards automation. You need to constantly innovate and keep moving forward.
Read more »
Learn SQL: Non-Equi Joins in SQL Server
September 29, 2020Non-Equi join in SQL Server sounds like something abstract (and fancy), but it’s not so abstract (and fancy) at all. The same stands for equi joins. After reading this article, I hope you’ll agree on that with me. Today’ I’ll try to explain what they are and when you should use them. So, let’s start.
Read more »
Explore SQL Server PolyBase External Tables in SQL Server Always On Availability Groups
September 29, 2020In this 28th article for SQL Server Always On Availability Group series, we explore the high-availability for the SQL Server PolyBase(SSB) external tables using AG groups.
Read more »
Explore failover types in SQL Server Always On Availability Groups
September 29, 2020In this 27th article of the SQL Server Always On Availability Group series, we will discuss various failover modes for AG databases.
Read more »
Improve SQL Server transaction log performance with Delayed Durability
September 29, 2020In this article, we will learn the Delayed Durability feature that helps to improve transaction log file write throughput in SQL Server.
Read more »
Suppress successful login and backups messages from the error log for SQL databases
September 28, 2020In this article, we will explore the method to suppress successful login and backups messages in the error log for SQL databases.
Read more »
Scalar UDF Inlining in SQL Server 2019
September 28, 2020In this article, we will explore a new SQL Server 2019 feature which is Scalar UDF (scalar user-defined) inlining. Scalar UDF inlining is a member of the intelligent query processing family and helps to improve the performance of the scalar-valued user-defined functions without any code changing.
Read more »
Explore branches in Git Source Control
September 28, 2020In this 5th article of the Source Control series, we will explore the concept of branches in a Git source control and GitHub repositories.
Read more »
How to prepare for the Exam AZ-104: Microsoft Azure Administrator
September 28, 2020In this article, we will discuss how to prepare yourself for the Microsoft Azure Administrator certification exam.
Read more »