An Overview of User-defined SQL Server Types
November 3, 2020In this article, we will explore User-defined SQL Server Types and their usage.
Search Results for: azure
Install SQL Server Linux (2017 version) on SUSE Linux in Amazon EC2 instance
October 26, 2020In this article, we will install and configure SQL Server Linux (2017 version) on SUSE Linux in the Amazon EC2 Instance.
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 […]
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.
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.
![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.
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.
Backup SQL databases on the AWS S3 bucket using Windows PowerShell
September 16, 2020In this article, we will explore taking backups of native SQL databases into the AWS S3 bucket.
How to parse JSON in SQL Server
September 15, 2020In this article, we will learn how to parse and query JSON in SQL Server with the help of the OPENJSON function. Firstly, we will briefly look at the data structure of the JSON and then we will learn details of the parsing and querying JSON data using the OPENJSON function.
How to create an AWS SageMaker Instance
September 7, 2020This article provides a step by step explanation of how to get started with AWS Sagemaker by creating an AWS SageMaker instance for using machine learning related features on AWS Cloud.
Saving AWS Redshift costs with scheduled pause and resume actions
August 31, 2020This article helps you learn the AWS Redshift cluster pricing model, as well as options to pause and resume cluster on-demand and on-schedule.
Deep dive into IT Cloud Automation using PowerShell
August 28, 2020The future of PowerShell is bright—the scale in which Cloud automation adoption with major tech giants such as Microsoft, Google, Amazon, and VMWare is seemingly much higher.
Test-driven database hotfix development (TDHD) with SQL unit test based framework (tSQLt)
August 24, 2020This article talks about test-driven database hotfix development using a very productive database testing framework called tSQLt applying the same SQL unit test based approach.
Exploring databases in Python using Pandas
August 24, 2020In this article, I am going to cover in detail working with databases in Python using Pandas and SQLAlchemy. This is a part of the series Learn Pandas in Python where I talk about the various techniques to work with the Pandas module in Python.
Getting started with AWS RDS Aurora DB Clusters
August 24, 2020This article provides a step by step explanation of how to create an Aurora DB cluster that is compliant with MySQL or PostgreSQL.
Restore tables in AWS Redshift clusters
August 19, 2020This article provides a step by step explanation of how to restore selective datasets from AWS Redshift snapshots to a working Redshift cluster, instead of restoring the entire backup.
Working with Pandas Dataframes in Python
August 19, 2020In this article, I am going to explain in detail the Pandas Dataframe objects in python. In the previous article in this series Learn Pandas in Python, I have explained what pandas are and how can we install the same in our development machines. I have also explained the use of pandas along with other […]
IT Cloud Automation using PowerShell
August 17, 2020Using PowerShell automation, one could easily automate the most common tasks. The future for PowerShell as the automation framework is bright. Shipping PowerShell core on the hybrid platform has opened up new markets, new customers, and new opportunities for Microsoft. At the same time, we still strongly believe in Powershell on Windows Server, Linux and […]
Export data from AWS Redshift to AWS S3
August 14, 2020This article provides a step by step explanation of how to export data from the AWS Redshift database to AWS S3 using different export-related options.
SQL database hotfix testing with tSQLt
August 10, 2020This article talks about getting your database hotfixes tested with tSQLt provided they do not have any inherited complexities or dependencies on things other than SQL database.
SQL Certifications
August 7, 2020Introduction Many people ask me how to get the Microsoft SQL Certification. SQL Server has a lot of certifications and specializations. In this article, we will provide an introduction to each of them and provide some tips related. At the time of this publication, we are under the Coronavirus era. Many people are at home […]
Getting started with Pandas in Python
August 5, 2020In this article, I am going to explain how to use Pandas in Python. Pandas is one of the most popular modules in python that can be used for data manipulation and analysis using python. Basically, it provides an easy interface to interact with flowing data and apply transformations to them on the go. This […]
Implementing an SSAS Tabular Model for Data Analytics
August 4, 2020Introduction Having discussed different aspects of MDM SSAS cubes, we will look at the Microsoft recommended OLAP tool, SSAS Tabular Models for data analytics. There are a few advantages of using Tabular Models over MDM that are listed below.
Share AWS Redshift data across accounts
August 3, 2020This article provides a step by step explanation of how to share AWS Redshift database snapshots with other AWS accounts to enable porting of data from one AWS account to another.
Managing snapshots in AWS Redshift clusters
July 31, 2020This article gives an overview of configuring AWS Redshift snapshots for scheduled data backup, data archival, as well as disaster recovery.