Import Database schema in Azure SQL DB from .SQL files programmatically with SQLCMD

Introduction – This blog post illustrates the method through which you can import your database schema and tables into empty Azure SQL DB ( PaaS ) programmatically. Currently azure SQL DB support import from BACPAC file in PowerShell and GUI but not from .SQL files. Assumptions  – Here we assume that you already have .SQL…

0

Adding SQL Server Availability Group (AG) to an Exiting Failover Cluster Instance (FCI) – Part2 of 2

  4. Validate Windows Failover Cluster Owners Click on "Roles in "Failover Cluster Manager" then Right Click on “SQL Server” and Select “Properties” Make sure Preferred Owners are set to the 2 FCI Nodes and clear the check from the DR Node then click “OK” Scroll down and select “SQL Server” from “Other Resources” Right…

1

Adding SQL Server Availability Group (AG) to an Exiting Failover Cluster Instance (FCI) – Part1 of 2

Introduction Microsoft SQL Server 2012/2014 AlwaysOn provides flexible design choices for selecting an appropriate high availability (HA) and disaster recovery (DR) solution for your application. Building on that fact I will be providing a posts that provides a step-by-step configuration for extending a 2 Node SQL Server Failover Cluster Instance with a 3rd Node that…

1

Configuring SQL Server 2014 AlwaysOn Availability Group using PowerShell

Introduction Earlier on I was trying to search for some scenarios to implement AlwaysOn Availability Groups using PowerShell, although I was able to find some interesting post however non of them represented a complete scenario starting from a fresh windows server installation (using PowerShell), so I decided to write this blog as quick walkthrough the…

1

Moving SharePoint Databases to Another Server (Without Reconfiguring SharePoint)

Introduction Moving / Migrating Microsoft SharePoint Server Databases from one server to another might be difficult as you need to reconfigure all the related DB(s) to point at the new server. This might be acceptable if we are talking about the SharePoint Content Databases, but how about the below scenarios:   Scenario # 1: Moving…

5

Walkthrough Microsoft SQL Server 2012 Upgrade Advisor

Introduction Migrating Microsoft SQL Server from an older version can be considered as an issue if you didn’t consider the variances between both versions (especially if your Database uses some deprecated features), so how can we detect all these changes between SQL Server versions? One way is to understand the different compatibility levels of each…

1

What to Consider When Creating SQL Server Database Migration Plan?

Introduction SQL Server Migration is the process of stirring a previous implementation of SQL Server to a newer version, different location (or both) due to  a strategic decision (such as SQL Server Consolidation). In this post I’m trying to highlight some of the important aspects that we need to consider Before, During & After having…

3

SQL 2012 Unattended installation & Configuration file creation

Introduction In many cases you might be faced with a requirement to perform an unattended SQL Server 2012 installation. To perform SQL Server 2012 installation you need to perform many choices and steps to configure your installation so the question is how to provide all these details during an unattended installation? Solution There are many…

1

Useful References – SSRS Logging, Monitoring and Troubleshooting

As I was recently working on SQL Server Reporting Services (SSRS) I complied a list of references that can be used as a quick guidance for SSRS Logging, Monitoring & Troubleshooting. This list includes links and quick description on each link to act as an Index. Hope you will find it useful:   · Monitoring…

1