This article will show how to deploy SQL Server 2019 on the Azure container instances using the Azure portal.
Read more »
Rajendra Gupta
As an MCSA certified and Microsoft Certified Trainer in Gurgaon, India, with 13 years of experience, Rajendra works for a variety of large companies focusing on performance optimization, monitoring, high availability, and disaster recovery strategies and implementation. He is the author of hundreds of authoritative articles on SQL Server, Azure, MySQL, Linux, Power BI, Performance tuning, AWS/Amazon RDS, Git, and related technologies that have been viewed by over 10m readers to date.
He is the creator of one of the biggest free online collections of articles on a single topic, with his 50-part series on SQL Server Always On Availability Groups. Based on his contribution to the SQL Server community, he has been recognized with various awards including the prestigious “Best author of the year" continuously in 2020 and 2021 at SQLShack.
Raj is always interested in new challenges so if you need consulting help on any subject covered in his writings, he can be reached at rajendra.gupta16@gmail.com
View all posts by Rajendra Gupta
He is the creator of one of the biggest free online collections of articles on a single topic, with his 50-part series on SQL Server Always On Availability Groups. Based on his contribution to the SQL Server community, he has been recognized with various awards including the prestigious “Best author of the year" continuously in 2020 and 2021 at SQLShack.
Raj is always interested in new challenges so if you need consulting help on any subject covered in his writings, he can be reached at rajendra.gupta16@gmail.com
View all posts by Rajendra Gupta
Latest posts by Rajendra Gupta (see all)
- Deploying Azure Container Instances for SQL Server 2019 - December 3, 2021
- BCP for import and export data in Azure SQL Database - December 1, 2021
- Migrate encrypted columns data from on-premises to Azure SQL Database - November 29, 2021
BCP for import and export data in Azure SQL Database
December 1, 2021The Bulk Copy Program (BCP) utility can move bulk data between SQL Server instances. You can export SQL Server data into BCP files. You can also use them for moving data from on-premises SQL Server instances to Azure SQL Database. The BCP files do not contain schema or the format information of your data. Therefore, you cannot use it as a database migration tool. However, it is adequate to import or export many rows. However, you need to create the table or use a format file to import data into a table.
Read more »
Migrate encrypted columns data from on-premises to Azure SQL Database
November 29, 2021Azure SQL Database is a cloud database hosted on Microsoft’s Azure platform. It is an enterprise-grade database service that supports a wide range of advanced features, and it can be used to store and process data. Customers can migrate data from an on-premises SQL Server without downtime and minimal disruption.
Read more »
Hybrid Buffer Pool in SQL Server 2019
November 23, 2021This article explores the Hybrid Buffer Pool feature available in the SQL Server 2019.
Read more »
INDEXPROPERTY() function in SQL Database
November 22, 2021This article will give an insight into the INDEXPROPERTY() function in SQL Databases.
Read more »
Parameterized SQL Notebooks in Azure Data Studio
November 10, 2021This article will explore Parameterized SQL notebooks in Azure Data Studio.
Read more »
Copy Data tool to import data into Azure SQL Database from web sources
November 8, 2021This article will explore the Copy Data tool for importing data into Azure SQL Database from a web source.
Read more »
SQL Server 2022 Private Preview announcement
November 3, 2021This article talks about the next version of SQL Server which is SQL Server 2022. This will cover the latest announcement, release, and all the exciting features SQL Server 2022 offers.
Read more »
Copy Data tool to export data from Azure SQL Database into Azure Storage
October 29, 2021DBA may import, export regularly within a different environment. You might receive data in a specified format for importing it into database tables.
Read more »
Automatic Index advisor in Azure SQL database
October 26, 2021This article will explore automatic index advisor (CREATE_INDEX, DROP_INDEX) for Azure SQL Database.
Read more »
Upgrade SQL Server Management Studio (SSMS) along with Azure Data Studio
October 20, 2021This article explains upgrading SQL Server Management Studio (SSMS) and Azure Data Studio (ADS) to their latest version with a single installation.
Read more »
An overview of SQL Comments
October 19, 2021In a typical database, we have multi lines or page SQL statements in a view, SQL statement or the stored procedure. Also, multiple developers change the T-SQL, and it becomes difficult to track who altered the code and for what reason.
Read more »
SQL Server Extended Events Causality Tracking
October 14, 2021This article explores the Causality tracking option in the SQL Server Extended Events session(XEvents) and its usefulness in troubleshooting performance issues.
Read more »
How to manage SQL Server logs effectively
October 8, 2021This article covers an overview of SQL Server logs for monitoring and troubleshooting issues in SQL Server.
Read more »
Min and Max memory configurations in SQL Server Database instances
October 6, 2021This article gives an insight into the configuration of Min and Max memory for SQL Server Database instances.
Read more »
The ghost cleanup task for SQL Server Databases
October 6, 2021This article explains the internals of the Ghost cleanup task for SQL Server Databases.
Read more »
MSDB SQL Database Maintenance and Cleanup
October 4, 2021This article explores the MSDB SQL Database maintenance and cleanup process essential for every DBA.
Read more »
DTU and vCore based models for Azure SQL Databases
September 27, 2021Azure SQL Database is a popular choice for migrating your database from on-premises to cloud infrastructure. It enables you to move to a fully managed Platform as a Service (PaaS) with desired performance and cost-effectiveness.
Read more »
Custom Azure Policy definitions for Azure SQL Databases backup retention periods compliance
September 22, 2021This article uses Azure policies to check compliance of Azure SQL Databases against the backup retention period.
Read more »
Identify and remediate non-compliant Azure SQL Databases for auditing on SQL Server
September 16, 2021This article explores the Azure built-in policies and implements them to check and fix Azure SQL Database and Azure SQL Server compliance.
Read more »
Azure Alerts for creating, modifying and deleting Azure SQL Databases
September 13, 2021This article will explore the Azure alerts configuration to audit Azure SQL Database creation, modification, and deletion activities.
Read more »
Azure Automation: Automatic scaling Azure SQL databases based on CPU usage threshold
September 10, 2021This article will explore Azure automation for scaling up Azure SQL Databases based on the CPU usage threshold.
Read more »
Auto Update SQL Server Statistics Asynchronous configuration for Azure SQL Database
September 7, 2021This article explores auto-update SQL Server Statistics asynchronous configuration for Azure SQL Database and On-premises SQL instance.
Read more »
Grant, With Grant, Revoke and Deny statements in SQL Server and Azure SQL Database
September 6, 2021This article will walk you through Grant, With Grant, Revoke and Deny statements for both on-premises and Azure SQL Database.
Read more »
6 Reasons why you can’t have DevOps without Test Automation
August 31, 2021This article explores the integration and requirements of DevOps with Test Automation.
Read more »