Tag: database administration

Introduction to Azure Database Migration Service (ADMS)

Azure, Cloud

Microsoft Azure platform provides an Azure Database Migration Service (ADMS) – a convenient...
Read More

Deploying a Database on Azure SQL

Azure, Cloud

Introduction Azure SQL Database is a Platform as a Service (PaaS) offered by Microsoft Azure. Hence, you need the Azure subscription to use...
Read More

10 Tips & Tricks To Work With SQL Server Management Studio

SSMS, Tools & technologies

SSMS provides access for managing and solving queries in SQL. However, besides its primary and most demanded options, it includes lots of...
Read More

How to Configure Database Mail in SQL Server

Database administation, Database Optimization & Structure

INTRODUCTION Notifications are usual in most modern systems. SQL Server implemented means of...
Read More

How to Make Sense of SQL Server Geography Data Type

Database administation, Work with data • One Comment

SQL Server Geography data type is unlike other types simply because you don’t use it often. It’s not...
Read More

How To Migrate SQL Server Jobs From One SQL Server Instance To Another

Database administation, Database Optimization & Structure

Introduction In a previous article, we highlighted that the msdb database stores practically all objects related to automation. In this...
Read More

Creating Maintenance Plans in SQL Server

Database administation, Database Optimization & Structure

Maintenance plans in SQL Server give us an easy way to organize, configure, and schedule tasks that...
Read More

7 Facts About SQL Server Synonyms You Should Know

Database administation, Database Optimization & Structure

Before SQL Server Synonyms appeared, everyone wished to simplify and enhance their database experience. Imagine you have an application...
Read More

Best SQL Tools for Database Developers and Administrators

Code Management, Tools & technologies

For a SQL database developer, it is essential to have the necessary SQL tools in hand, which enable to reduce the development time of given...
Read More

Searching for Database Objects and Table Data in SQL Server

Database administation, Database development, Search, Tables • One Comment

If you are a SQL Server database administrator or developer, you need to frequently search for...
Read More
Close