Azure Cosmos DB a NoSQL Introduction
In this article we look at how to implement Azure Cosmos DB for free to learn and explore this document store technology.
Hi! I am Rajendra Gupta, Database Specialist and Architect, helping organizations implement Microsoft SQL Server, Azure, Couchbase, AWS solutions fast and efficiently, fix related issues, and Performance Tuning with over 14 years of experience.
I am the author of the book "DP-300 Administering Relational Database on Microsoft Azure." I can be reached at: Rajendra.gupta16@gmail.com for any consulting help.
- MSSQLTips Awards:
- Author of the Year - 2022 | Author Contender - 2021/2023/2024 | Champion Award (100+ tips) - 2020
Full Text Search for Azure Cognitive Service and Azure SQL Database
In this article we look at how to build a new index for full text search using Azure SQL Database and Azure Cognitive Search.
Azure Cognitive Search Overview
In this article we take a look at the Azure Cognitive Search Service to allow you to build full text search capabilities for your data.
Move SQL Server System Databases on Linux
In this article we cover the steps on how to move SQL Server system databases to a new location when SQL Server is running on Linux.
Build a Web Scraping Tool using Azure Data Factory
Learn how to build a web scraping tool using Azure Data Factory to scrape data from tables from a web page without writing any code.
SQL RETURN and SQL OUTPUT clause in Stored Procedures
In this article we look how to use RETURN and OUTPUT in a SQL Server stored procedure to get a return value after execution.
Azure SQL Database Ledger Getting Started and Examples
In this second tip in this series we look at how to configure and implement Azure SQL Database Ledger with scripts and examples.
Azure SQL Database Ledger Introduction for Data Tampering Protection
This tip explores different components, features, and benefits of Azure SQL Database Ledger for making sure your data has not been tampered with.
Query Audit data in Azure SQL Database using Kusto Query Language
In this article we look at how you can user the Kusto Query Language (KQL) for querying Azure SQL Database audit data.
Azure AD Authentication for Azure SQL Databases
Learn how to connect to Azure SQL Database using Azure AD authentication along with multi-factor authentication.
CONCAT SQL Function in SQL Server
In this article we look at various ways to concatenate SQL Server data using the + sign as well as concat and concat_ws.
Server and Database Level Auditing for Azure SQL databases
Learn how to audit Azure SQL Database in this step by step article using either server level or database level auditing.
Windows Failover Cluster Node Quarantined
In this article we cover why Windows Failover Cluster nodes can go into a quarantined state, how to resolve this as well as how to set threshold values for this cluster node state.
Azure Blob Storage Data Upload with SSIS
In this article we look at how to upload and download files from Azure Storage using SQL Server Integration Services.
RecordSet Destination in SSIS
In this article we look at how and why you would use a RecordSet Destination in a SSIS package.
Amazon RDS SQL Server Database Mail Configuration
In this article we look at how to configure database mail for a RDS SQL Server instance on Amazon AWS.
SSRS Data Driven Subscription
Learn how to create SSRS subscriptions and data driven subscriptions with SQL Server 2019 Reporting Services.
Install SQL Server 2017 on Oracle VM VirtualBox for Red Hat – Part 2
In the first part of this tip we created a new virtual machine using Oracle VirtualBox with Red Hat Linux installed. In this tip we will install SQL Server 2017 and SQL Server Agent.
How to install SQL Server on RHEL for Oracle VirtualBox – Part 1
In this tip we look at how to setup a virtual machine using Oracle VirtualBox and install Red Hat Linux to prepare a machine for the next tip where we will install SQL Server 2017 on Linux.
SQL Server Restore Interview Questions
Prepare for your next SQL Server interview with these restore questions and answers.
Resumable Online Index Create in SQL Server 2019
In this tip we look at the enhancements of resumuable index creation with the new Resumable Online Index Create in SQL Server 2019.
SQL Server Backup Interview Questions
Prepare for your next SQL Server interview with these backup questions and answers.
Installing and Using mssql-cli on Linux for SQL Server
Learn how to install and use mssql-cli on Ubuntu Linux to assist you with managing SQL Server on Linux.
SQL Server 2017 Step By Step Installation Guide
In this tip we walk through the installation process of installing SQL Server 2017 and some of its features.