I am speaking at SQL Saturday Pittsburgh 2016!

I will be presenting my third SQLSaturday session at the upcoming Pittsburgh #545 Saturday, Aug. 13th, 2016.

My session, Stretch Database and Managed Backups: Cloud Services for your SQL Servers, is a beginner track session going through the setup, configuration, usage and some real-world usage scenarios for both of these recently added features to the SQL Server product.

Have you registered yet?  Why not?

I am speaking at SQL Saturday Indy 2016!

That’s right, back-to-back roll.  I will be presenting my second SQLSaturday session at the upcoming Indianapolis #530, Saturday, Aug. 13th, 2016.

My session, Stretch Database and Managed Backups: Cloud Services for your SQL Servers, is a beginner track session going through the setup, configuration, usage and some real-world usage scenarios for both of these recently added features to the SQL Server product.

Have you registered yet?  Why not?

I am speaking at SQL Saturday Louisville 2016!

That’s right.  My way of giving back to the SQL Server community, I am presenting my first SQLSaturday session at the upcoming Louisville #531, Saturday, Aug. 6th, 2016.

My session, Stretch Database and Managed Backups: Cloud Services for your SQL Servers, is a beginner track session going through the setup, configuration, usage and some real-world usage scenarios for both of these recently added features to the SQL Server product.

Have you registered yet?  Why not?

Hyper-V Backup Script

The following powershell script creates snapshots or exports of VMs on the local, and performs retention/cleanup as well.  Be forewarned.  There are known bugs with the current hyper-v snapshot integration and *nix systems.

Make ServiceNow SOAP calls with PowerShell

The following PS script shows how to query ServiceNow via SOAP calls, using the WebServiceProxy object.  View their Wiki for more examples of service methods

 

Synchronize File Timestamps

To synchronize file timestamps (creation, last access and last write) of two directory trees.

Get last logon time for all users in an AD

Utilizing the ActiveDirectory module, this returns user names with last logon time stamp

Powershell Full Database and Transaction Log Backup Script (works with SQLExpress)

Loosely based off of other examples I found, this script will perform full database backups of all databases or tran log backups of all full/bulk-logged databases.  In addition, it will utilize the default backup path (if one is not given), and delete old backup files (that conform to the file naming convention) that are older than a given number of retention hours (default to 48 hours):

Examples:

Full backup to a given path, retaining only 26 hour old backups on disk

. .\backup.ps1 SQLINSTANCE\Name full 26 "C:\some\path"

Log backup (to the default instance configured backup path), retaining default 48 hours of logs on disk

. .\backup.ps1 SQLINSTANCE\Name log

Assumes that the given windows user has necessary permissions to perform backups.  Compression is not specified, so will assume instance default config

Modify SQL 2008 R2 Generated Configuration File For Unattended Installs

After walking through the installation GUI, copy the Configuration File Path on the ‘Ready To Install’ page.  Copy and modify this file in the following order to generate a repeatable unattended install process:

  1. Put a semicolon infront of UNIMODE=”Normal”
  2. Set either QUITE=”False” or QUITESIMPLE=False” to true
  3. Add the following line to accept the licensing terms:
    IACCEPTSQLSERVERLICENSETERMS="True"
  4.  Run the following as administrator from a command prompt: