3 Easy and Secure Ways to Make Users Run SSIS Packages
Have you ever come across a situation where you needed to make users run SSIS packages? This...
Configure SQL Server Log Shipping
This article explains the step by step deployment process of the SQL Server Log shipping. It is the database-level disaster recovery...
Configure SQL Jobs in SQL Server using T-SQL
SQL Server Agent is a component used for the database tasks automation. For instance, we need to perform Index maintenance on Production...
Configure Database Mirroring in SQL Server
Database mirroring is a SQL Server high availability solution provided by Microsoft, with the...
Deploying the first SQL to Azure Migration project with Azure Database Migration Service
Azure Database Migration Service (ADMS) supports Schema and Data migration from different database technologies to the Azure platform. This...
Introduction to Azure Database Migration Service (ADMS)
Microsoft Azure platform provides an Azure Database Migration Service (ADMS) – a convenient solution for the Azure Cloud-based Databases...
Deploying a Database on Azure SQL
Introduction Azure SQL Database is a Platform as a Service (PaaS) offered by Microsoft Azure....
10 Tips & Tricks To Work With SQL Server Management Studio
SSMS provides access for managing and solving queries in SQL. However, besides its primary and most demanded options, it includes lots of...
How to Configure Database Mail in SQL Server
INTRODUCTION Notifications are usual in most modern systems. SQL Server implemented means of sending notifications by email early with the...
How to Make Sense of SQL Server Geography Data Type
SQL Server Geography data type is unlike other types simply because you don’t use it often....
