This article gives you an overview of Unique Constraints in SQL and also the Unique SQL Server index. Along the way, we will look at the differences between them.
Read more »Rajendra Gupta
Rajendra has 8+ years of experience in database administration having a passion for database performance optimization, monitoring, and high availability and disaster recovery technologies, learning new things, new features.
While working as a Senior consultant DBA for big customers and having certified with MCSA SQL 2012, he likes to share knowledge on various blogs.
He can be reached at rajendra.gupta16@gmail.com
View all posts by Rajendra Gupta
While working as a Senior consultant DBA for big customers and having certified with MCSA SQL 2012, he likes to share knowledge on various blogs.
He can be reached at rajendra.gupta16@gmail.com
View all posts by Rajendra Gupta
Latest posts by Rajendra Gupta (see all)
- Explore SQL Server PolyBase External Tables in SQL Server Always On Availability Groups - September 29, 2020
- Explore failover types in SQL Server Always On Availability Groups - September 29, 2020
- Suppress successful login and backups messages from the error log for SQL databases - September 28, 2020
An overview of computed columns in SQL Server
June 9, 2020In this article, we will explore computed columns in SQL Server and their configurations.
Read more »
SQL Server Choose() function introduction and examples
June 5, 2020In the article, a CASE statement in SQL, we explored one of the important logical expressions – the Case statement in SQL Server to return the values based on the specified condition. Today, we will talk about another useful logical Choose() function in SQL Server 2012 onwards and its comparison with the Case statement.
Read more »
Using SSIS packages to add row headers and data into flat files
June 4, 2020In this article, we will configure an SSIS package to generate a composite output in the flat-file destination.
Read more »
Working with SSIS packages on AWS RDS SQL Server
June 3, 2020In the first part of the article, Explore SQL Server Integration Services (SSIS) on AWS RDS SQL Server, we understood that AWS RDS SQL Server supports SSIS functionality starting from May 19th, 2020.
Read more »
Explore SQL Server Integration Services (SSIS) on AWS RDS SQL Server
June 2, 2020In the previous article, Deploy tabular databases in SSAS on AWS RDS SQL Server, we explored that AWS RDS SQL Server now supports SQL Server Analysis Service (SSAS). It enables you to implement tabular project models for RDS instance as well. In this article, we will explore the support of SQL Server integration service in the RDS environment.
Read more »
Deploy tabular databases in SSAS on AWS RDS SQL Server
June 1, 2020In this article, we are going to explore Analysis Service for AWS RDS SQL Server in detail.
Read more »
Explore the DATABASEPROPERTYEX() function for SQL Server databases
May 28, 2020In this article, we explore a SQL function to extract SQL database metadata using the DATABASEPROPERTYEX function.
Read more »
Learn AWS CLI – Explore IAM users, roles, policies using AWS CLI
May 28, 2020AWS provides a command-line interface (AWS CLI) tool to work with its various cloud services. It is a single tool with many useful commands and allows you to automate a particular task using scripts. You might need to do specific tasks regularly. You can use the AWS Web Console for it. However, it requires you to go through all configuration options all over again.
Read more »
Impact of the Column order in SQL Server Composite Indexes
May 28, 2020In this article, we will explore the Composite Index SQL Server and the impact of key order on it. We will also view SQL Server update statistics to determine an optimized execution plan of the Compositive index.
Read more »
Import XML documents into SQL Server tables using SSIS packages
May 21, 2020This article guides you through importing XML documents into SQL tables using SSIS packages.
Read more »
The JSON_QUERY() function to extract objects from JSON Data
May 19, 2020In this article, we will explore JSON_QUERY() functions in SQL Server to extract JSON objects and array from the JSON Data.
Read more »
An Overview of the XML Task in SSIS Packages
May 18, 2020Introduction
We can use an SSIS package to perform various tasks such as data import, transform, and get output in various formats. Once we launch Visual Studio 2019 and create an integration services project, it shows you various tasks in the SSIS toolbox. In this article, we will explore the XML Task in the SSIS.
Read more »
Server and Database dashboards in Azure Data Studio
May 14, 2020Azure Data Studio (ADS) is an integrated, lightweight database development for supporting both on-premises and cloud databases. It can be installed on Windows as well as Linux operating system. I am assuming you are familiar with the SQL Server Management Studio. If you work on Linux based SQL Server instance, you can install only ADS in those systems. We can use integrated terminals to execute the PowerShell and Terminal sessions for the Linux system.
Read more »
Advanced Windows Authentication configurations in AWS RDS SQL Server
May 13, 2020This article will cover advanced configurations for Windows Authentication in AWS RDS SQL Server.
Read more »
Create charts from SQL Server data using Azure Data Studio
May 13, 2020In this article, we will explore charts in an Azure Data Studio using data stored in SQL Server tables.
Read more »
Initial Windows Authentication configurations in AWS RDS SQL Server
May 12, 2020In this article, we will be exploring the process of enabling Windows authentication in AWS RDS SQL Server.
Read more »
Integrating AWS S3 buckets with AWS RDS SQL Server
May 8, 2020This article gives you an overview of integrating AWS S3 buckets with AWS RDS SQL Server.
Read more »
Extract scalar values from JSON data using JSON_VALUE()
May 5, 2020In this article, we will explore JSON_VALUE() function in SQL Server to extract scalar values from JSON data.
Read more »
Modifying JSON data using JSON_MODIFY() in SQL Server
May 4, 2020This article explores JSON_MODIFY() function to modify JSON Data in the SQL Server.
Read more »
Learn AWS CLI – Interact with AWS S3 Buckets using AWS CLI
April 30, 2020It is the second article in the Learn AWS CLI series. It gives you an overview of working with the AWS S3 bucket using CLI commands. We also look at a brief overview of the S3 bucket and its key components.
Read more »
Script templates in SQL Server Management Studio (SSMS)
April 27, 2020SQL Server Management Studio (SSMS) is a popular client tool to connect with SQL Server and perform various development and administrative tasks. Beginner developers or DBAs might not be familiar with T-SQL or code for specific tasks. Even for an expert DBA, query templates and shortcuts help immensely to save time and improve productivity. SSMS template explorer is an often-overlooked solution, but it is a useful feature.
Read more »
View Execution Plans in Azure Data Studio
April 24, 2020This article gives an overview of viewing execution plans in the Azure Data Studio.
Read more »
Python scripts to split and concatenate strings
April 23, 2020This article gives an overview of Python Script functions to split strings and string concatenation functions.
Read more »
Learn AWS CLI: An Overview of AWS CLI (AWS Command Line Interface)
April 22, 2020This article is the first article in the series of Learn AWS CLI. Here we will talk about the overview, installation, and configuration of CLI tools in Windows.
Read more »