Essential for developments of all shapes & sizes

  • Failing over AlwaysOn Availability Groups

    Failing over AlwaysOn Availability Groups

    Merry Christmas Eve! A few weeks ago I posted on Availability Group fail-over tests with PowerShell. That post covered the basics of how to check the Availability Group’s state and perform the commands for conducting a zero data loss fail over. As a Christmas Present to all of you, I wanted to get a little bit […]

  • My Epic Life Quest – Level 2 Achieved

    DING – LEVEL 2 !!! I am excited to announce that I have achieved level 2 in My Epic Life Quest. My epic life quest is an idea that I got from Steve Kamb via Brent Ozar. As life goals are achieved you gain experience and after 5 achievements I get to reward myself with […]

  • Start and Save Hyper-V VMs with PowerShell

    I use Windows 8 or Windows Server 2012 R2 on most of my local workstations between home and work. In order to conserve memory, I turn my Hypver-V lab environments on and off as I need them. Given that my smallest environment is a grouping of five virtual machines (VMs), I quickly got tired of […]

  • Availability Group fail-over test with PowerShell

    I have a number of SQL Server Availability Groups in my organization. Of them, most are multi-site configurations for disaster recovery. Naturally, the latency that a separate data center implies is more than my application can handle for its writes. For this reason, we use asynchronous commit with manual fail-over. We also conduct regular fail-over […]

  • Connecting to an Availability Group Listener with SQL Server Management Studio

    Connecting to an Availability Group Listener with SQL Server Management Studio

    Background When a cluster has an Availability Group installed on it, there is an optional listener which is used to manage connections through fail-over events. This listener has an IP address assigned to it and, when the Availability Group fails over within the same sub-net, the listener simply comes online on the new node. That node […]

  • How to change the schema of a table

    The other day I set out to performance tune a database deployment. The company was getting ready to implement almost a year’s worth of database schema drift where major restructuring had occurred. One of the first things that I noticed was that they were moving a number of tables into a new schema. This portion […]

  • A first timer’s lessons learned at PASS Summit 2014

    A first timer’s lessons learned at PASS Summit 2014

    Me, as a #sqlfirsttimer Just one year ago I didn’t know what the PASS Summit was. What came after has been a series of serendipitous events. I went to Charlotte, NC to Red-Gate’s SQL in the City event because it was within driving distance and it was free. After the event I met Jes Borland, the first serendipitous […]

  • Query Central Management Server with PowerShell SMO

    Query Central Management Server with PowerShell SMO

    All production or operational DBAs need to maintain a server / instance list. SQL Server’s Central Management Server (CMS) is a great means of managing that list with auxiliary benefits such as group queries, a central location for managing policies and SQL Agent jobs, and exposing the list via MSDB system views. The goal of the below function […]

  • Rebooting HRSSUG

    Rebooting HRSSUG

    This week I’m excited to announce the reboot of the Hampton Roads SQL Server User Group (HRSSUG). We will be coming back online this Novemeber, holding meetings every third Wednesday of the month. Check out our announcement below and be advised ApexSQL has provided us a free license to their ApexSQL Universal software suite to […]

  • Backup testing with PowerShell

    This week I released a two part blog series on SQLShack.com. The series covers automated testing for your backup files and reporting on the results. Many elements of PowerShell, SMO, T-SQL, and SQL Server Reporting Services are covered. Abstract Once your organization grows to a decent size it will fall under the governance of a number […]