Install Ansilble on Windows 10

Installing Ansible generally is pretty straight forward but on windows, it is a little bit complicated. Ansible uses the pywinrm package to communicate with Windows servers over WinRM. It is not installed by default with the Ansible package but can be installed, see http://bit.ly/32CZz4L If you wish to install Ansible on Windows, follow these steps.Note: Cygwin is… Continue reading Install Ansilble on Windows 10

Export SharePoint group membership names and email addresses to Excel

Before we start, if you’re just wanting to email all members of the group you can “select all” then choose “E-Mail Users” from the action menu when viewing the group membership within SharePoint. This opens an Outlook window with all the addresses pre-populated. But, if you still need an excel sheet of membership for another… Continue reading Export SharePoint group membership names and email addresses to Excel

IIS ARR as a Reverse Proxy for SharePoint

With the questionable life span of the Microsoft Forefront brand, the Application Request Routing module for IIS7+ serves as a replacement reverse caching proxy. In conjunction with the Web Farm Framework and URL Rewrite, the ARR, in some cases, can provide an alternative to licensed products, such as Microsoft UAG, for todays needs. This guide… Continue reading IIS ARR as a Reverse Proxy for SharePoint

SQL Server Images in the Cloud Providers

When creating virtual machines (VMs) using the portals provided by the different cloud providers, you are presented with a list of SQL Server image names. However, when you start automating the creation of VMs, you are usually required to provide the IDs of the images that you want to use. I am going to walk… Continue reading SQL Server Images in the Cloud Providers

Azure Blog Storage for SQL Server Backup and Restore

This is an intro level post, specifically written for the new and accidental DBAs that have been told to direct their SQL Server backups to Azure storage…but without any additional information.  It does not include discussions around backup types, recovery models, etc.  Those are all great topics that are very well documented elsewhere.  Also useful… Continue reading Azure Blog Storage for SQL Server Backup and Restore

Example Lab Ansible to Manage Windows Servers

Introduction Ansible is quickly becoming the dominant DevOps platform for automating software provisioning, configuration management and application deployment in a heterogeneous datacenter and hybrid cloud environment. Ansible has facilities to integrate and manage various technologies including Microsoft Windows, systems with REST API support and of course Linux. This article will step through the steps of deploying the Ansible controlling… Continue reading Example Lab Ansible to Manage Windows Servers

Install a Windows Server 2012 Active Directory Read-Only Domain Controller (RODC)

This topic explains how to create a staged RODC account and then attach a server to that account during RODC installation. This topic also explains how to install an RODC without performing a staged installation. Stage RODC Workflow A staged read only domain controller (RODC) installation works in two discrete phases: Staging an unoccupied computer… Continue reading Install a Windows Server 2012 Active Directory Read-Only Domain Controller (RODC)

Windows Firewall Rule using PowerShell

  A firewall is the primary defense against attack from the outside world or from inside. Firewall is used as data center firewall and perimeter firewall to protect the data and infrastructure of any organization. We also have firewall module in the client and server operating system which we use and this also has to… Continue reading Windows Firewall Rule using PowerShell

Sql Error 10054 Could establish a Connection to SQL Server on Windows Server 2012 R2

I had couple of env in our customer site. The time has come for prod env and prod server need te be install and configured so here I am. First of all i though that isse is related with .NET Framework 4.7.2. I was wrong ! I realised that whole customer env works on TLS… Continue reading Sql Error 10054 Could establish a Connection to SQL Server on Windows Server 2012 R2