Dec 28, 20203 Easy and Secure Ways to Make Users Run SSIS PackagesHave you ever come across a situation where you needed to make users run SSIS packages? This happens when the user is not comfortable with a fixed schedule for whatever reason. You can’t define if it’s every weekend, at 9 pm, or the 5th of the month. …Database Administration9 min readDatabase Administration9 min read
Dec 28, 2020Configure Database Mirroring in SQL ServerDatabase mirroring is a SQL Server high availability solution provided by Microsoft, with the following components. Principal database server: a source database that you configure for the mirroring. Mirror database server: a destination database that you must restore with NORECOVERY. Ideally, a mirrored database should be on a separate server. …Sql Server7 min readSql Server7 min read
Dec 28, 2020Git Branching Naming Convention: Best PracticesGit offers flexible branching strategies, but what does it mean? In simple words, a branching strategy is a set of rules, a convention that helps teams and developers — they can follow these rules and conventions to create a new branch, its flow, etc. Not using appropriate naming conventions leads…Git4 min readGit4 min read
Nov 30, 2020Configure SQL Jobs in SQL Server using T-SQLSQL Server Agent is a component used for the database tasks automation. For instance, we need to perform Index maintenance on Production servers during the non-business hours only. So, we create a SQL Server job of running index maintenance and schedule it for “off” hours. When we install SQL Server…Database Administration8 min readDatabase Administration8 min read
Nov 26, 2020Deploying the first SQL to Azure Migration project with Azure Database Migration ServiceAzure Database Migration Service (ADMS) supports Schema and Data migration from different database technologies to the Azure platform. This article will shed some light on validations, limits, and use cases of migration tasks for SQL Server (RDS & On-Premises) to Azure cloud database with ADMS. Before creating a first migration…Azure9 min readAzure9 min read
Nov 18, 2020Using SQL Server 2016 Upgrade AdvisorSQL Server is designed to allow multiple databases on a single instance. With this model, it is possible to have databases sitting on an instance that are not the same version as the instance itself. You can think of this as running the database in the “backward compatibility mode.” To…Sql Server 20164 min readSql Server 20164 min read
Nov 6, 2020Introduction 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 migration tasks in a straight forward way. In this article, we elaborate on the AMDS essential work and integrated processes. We put in the focus issues related to the migration of…Azure4 min readAzure4 min read
Nov 4, 2020Restoring SQL Server Master DatabaseThe master database contains records of the structure/configuration for both the current instance and all other databases. When you run sp_configure, you are writing data to the master database. It also contains most of the dynamic management views that are necessary to monitor the instance. The importance of the master…How To5 min readHow To5 min read
Oct 30, 2020Deploying a Database on Azure SQLAzure SQL Database is a Platform as a Service (PaaS) offered by Microsoft Azure. Hence, you need the Azure subscription to use this SQL Database. Azure offers new subscribers a free subscription and $200 worth of resources for 30 days. …Azure7 min readAzure7 min read
Oct 28, 2020How To Migrate SQL Server Jobs From One SQL Server Instance To AnotherIn a previous article, we highlighted that the msdb database stores practically all objects related to automation. In this article, we’ll review the case of moving jobs and objects between the SQL Server instances. Let’s start with the list of objects stored in msdb on this instance of SQL Server. …Database Administration5 min readDatabase Administration5 min read
