This article will make you learn the Postgres Coalesce command with examples.Read more »
- Learn the PostgreSQL COALESCE command - January 19, 2023
- Use of the RESTORE FILELISTONLY command in SQL Server - December 21, 2022
- How to add or subtract dates in SQL Server - December 15, 2022
This article explores the RESTORE FILELISTONLY command in SQL Server with examples.
Performing a database backup is an integral part of a DBA’s job. Backups are taken to ensure that data can be recovered in an emergency. There are different restore mechanisms, and the SQL Server DBA needs to understand them to make the right decision in each situation.Read more »
This article explores SQL Server functions to add or subtract dates in SQL Server.Read more »
This article will show different SQL timestamp functions available with examples.Read more »
The database migration from on-premises to Azure cloud can be complicated in choosing the best SKU for Azure SQL Database, Managed Instance (MI), or SQL Server on Azure VM. Every database might have different resource requirements, and we need to choose the correct DB sizing based on the current workloads.Read more »
This blog will share with you a way to copy data from an AWS RDS SQL Server database to an Azure SQL database.Read more »
This article explores how to rename Azure SQL Database and on-premises SQL instance database.Read more »
This article explores different SQL Commands (functions) to return the current Date and Time (Timestamp) in SQL Server.Read more »
This article explains Azure SQL Database Geo Restore using geo-replicated backups for disaster recovery.Read more »
This article deploys a SQL Server container using Azure Kubernetes Services (AKS).Read more »
This article gives an overview and deployment steps for SQL Elastic Pool for Azure SQL database.Read more »
This article explores the process for rebuilding system databases – Master, MSDB, and Model for SQL Server on Linux and Windows.Read more »
Azure SQL Database does not support native database backups. Therefore, you cannot use it to move from the Azure cloud to on-premises SQL Server. You can use the data-tier application BACPAC file format for exporting database schema and data from the Azure database. This BACPAC file is helpful to deploy on an Azure SQL Database, Managed Instance, and on-premises SQL Server.Read more »
Interested in becoming an Azure SQL DBA but don’t know how to start? This article prepares you for the Azure SQL DBA interview by providing reference material links.Read more »
We are excited to share that Notebook Views are available for SQL Notebooks in the Azure Data Studio (Currently Insiders release). This article will cover the following topics:
- What are Notebook Views?
- Where can you find Notebook Views?
- How do you create a new view?
- How do you modify an existing view?
- Where can you see database objects in the view?
- Where can you see table data in the view?
- Where can you see query results in the view?
This article will talk about the SQL WHERE statement.Read more »
This article explores the database-level roles in the Azure SQL Database.Read more »
This article is for discussing fixed server roles in Azure SQL Database Server.Read more »
This article explains SQL Server Dedicated Administrator Connections and how you can use it for Azure SQL Database.Read more »
The article Configure IP firewall rules for Azure SQL Databases, discuss the configuring server and database IP firewall rules for Azure databases. In this article, we will explore setting applicable to Azure databases that control connectivity to the database.Read more »
The Azure SQL Database provides high performance, secure and reliable managed relational database service. Security is the prime focus area in both on-premises and cloud infrastructure while designing the database infrastructure.Read more »
As a Platform as a Service (PaaS) service, Azure SQL Database enables developers to deploy SQL Database in Azure Cloud without managing the infrastructure. We use SQL Server Agent to schedule jobs to run at a specific schedule in an on-prem SQL instance. However, Azure DB does not have agent functionality.Read more »
Azure SQL Database or Managed instance is a Microsoft cloud offering for SQL Server in the managed cloud environment. Usually, we connect databases from SQL Server Management Studio, Azure Data Studio, or applications for query data.Read more »
The database contains business, customer sensitive and confidential data. Therefore, securing the database environment is the prime responsibility of a database administrator. If you plan to host your databases in Microsoft Azure, you can choose the platform as a service solution – Azure SQL Database. The Azure SQL DB is a fully managed database service; therefore, you do not get full access to SQL Server features, databases.Read more »