landonfowler.com

Redeemed by Jesus Christ. Fascinated with tech.

Author: Landon Fowler

  • Dynamics CRM Import Error “Must declare the scalar variable “@table”

    This post is the first in a new series I’m going to call “CRM 2016 Upgrade Adventure”. Summary: my organization has taken on the ambitious challenge of not only upgrading our existing Dynamics CRM 2011 environment to the 2016 version but  of moving it to the cloud service as well. Aside from getting the vanilla components […]

  • Using Powershell to Refresh a Test SQL Server Instance from Production

    A project I’ve been wanting to work on for a long time is how to automate restores of our Production databases to the Test instance. There are a number of challenges associated with this. First, the restore has to be able to find which backup it needs to use. Secondly, many of our databases do […]

  • Using PowerShell to Perform Availability Group Failovers

    In the past we’ve explored how to use PowerShell to automate failovers on SQL Failover Clusters for Windows Updates and other scheduled maintenance. But what if you’re using Availability Groups instead of the traditional cluster? Fear not, there is still a PowerShell option for that. Usually I would have our night team use SSMS to fail […]

  • Fixing Orphaned SQL Users via PowerShell

    In SQL Server, a login is an instance level object that is used for authentication. It is mapped to a database user, which controls permissions at the database level. These objects (login and user) are tied to one another via a SID. If the login is deleted and then recreated, or if you restore your […]

  • Using PowerShell to Execute SQL Maintenance

    It’s an odd truth that laziness leads to better systems administration. That is, so long as it spurs you to automate and thoroughly document a repetitive or tedious task. For instance, I was recently tasked with reducing the excessive size of some system tables in our Microsoft Dynamics CRM environment. To start with, I accomplished […]

  • The Faith of Atheism

    The extent to which Christians are criticized for their faith always surprises me. In current American culture, and especially in science-based fields like IT, one is viewed as unintelligent or at least ignorant if they believe in any kind of religion. It is automatically assumed that if you find faith to be a credible notion […]

  • Scripting Failovers for SQL Server Maintenance

    As much as we’d all like to set up our SQL instances and never again let anyone touch them, that’s just not possible in real life. We live in a world where entities, for good or for evil, are constantly exposing vulnerabilities both in the SQL software and Windows itself. For that reason it is […]

  • Giving Yourself Permission To Lose

    One of the most profound turning points in my life was the moment that I gave myself the permission to lose. Please do not confuse this with apathy or a lack of ambition. It’s more of an upfront decision to roll with the punches, coupled with a focused vision on what is worth pursuing. Let […]

  • Unlocking Liberty

    This week a US judge asked Apple Inc. to help them unlock the iPhone that belonged to one of the San Bernardino shooters. The CEO of Apple, Tim Cook, has resisted this order citing risk to his customers and implications that extend past the case itself. Since then, notable people have stood up in defense […]

  • The Price of Free

    When looking at which tech toys to use it’s easy to differentiate by the upfront cost. An iPad, for example, can be twice the price of some of its competitors. This can certainly be prohibitive, no matter the quality of the device. I very much enjoy my Macbook Pro, but I would not be using one […]