Using Extended Events to Visualize Availability Group Replication Internals

SQL 2014 Service Pack 2 was recently released by Microsoft and there is a ton of great new features and enhancements in this release.This isn’t just a collection of bug fixes…there’s some serious value in this Service Pack. Check out the full list here. One of the key things added in this Service Pack is an enhancement of the Extended Events for AlwaysOn Availability Group replication. Why are the new Availability Group Extended Event interesting?

Setting PowerShell as your default Linux shell

In this post we’re going set PowerShell as your default Linux shell. What is a shell? In Linux systems you’re given options, tons of options, you can set, reconfigure, add/remove almost anything that you want. And one of those options is your shell. The shell is the thing that you interact with when you’re typing commands at the command line. Different shells have different behaviors and characteristics. It’s a very personal choice.

Getting Started With PowerShell on Linux

Getting PowerShell on Linux Well it’s not just an announcement, you can actually get PowerShell on Linux and MacOS right now from GitHub – here! Installing PowerShell Once you’ve downloaded an installation file you can use RPM or apt to install the package. If you’re on a Mac…well just double click on the package! yum install powershell-6.0.0_alpha.9-1.el7.centos.x86_64.rpm If you’re on Ubuntu, you’ll need a little more stuff read this. Running PowerShell We’ll there’s really not much to that, just type powershell at the command prompt an you’re off and running!

SQL Server, Persistent Memory on NVDIMMs and DAX

Paradigm Shift! What do I mean by that? Every once in a while a technology comes along and changes the way things are done, moves the bar…well last week Microsoft released a Channel 9 video on persistent memory using NVDIMMs and DAX on Windows 2016…then combining it with SQL Server! This is one of those technologies that moves the bar! Check it out here. Why is this important? Relational databases like SQL Server use a transaction log to ensure the durability of the transactional operations to the database.

New Pluralsight Course – LFCE: Advanced Linux Networking

My new course “LFCE: Advanced Linux Networking” in now available on Pluralsight here! This course targets IT professionals that design and maintain RHEL based enterprises. It aligns with the Linux Foundation Certified System Administrator (LFCS) and Linux Foundation Certified Engineer (LFCE) and also Redhat’s RHCSA and RHCE certifications The course can be used by both the IT pro learning new skills and the senior system administrator preparing for the certification exam

Speaking at IT/Dev Connections!

I’m proud to announce that I will be speaking at IT/Dev Connections on October 11th 2016 in Las Vegas! I can’t begin to tell you how excited I am to be able to speak at this conference! I look forward to seeing you there! Here’s the information on the talk! Designing High Availability Database Systems using AlwaysOn Availability Groups **Track: **Development Platform Tools and Devops Abstract: Are you looking for a high availability solution for your business critical application?

Speaking at SQLSaturday Baton Rouge!

I’m proud to announce that I will be speaking at SQL Saturday Baton Rouge on August 6th 2016! This will be my forth SQLSaturday event this year and I’m really excited that I get to do it as a speaker. I look forward to seeing you there! If you don’t know what SQL Saturday is, it’s a whole day of free SQL Server training available to you at no cost!

Speaking at SQLSaturday Sacramento!

I’m proud to announce that I will be speaking at SQL Saturday Sacramento on July 23th 2016! This will be my third SQLSaturday event this year and I’m really excited that I get to do it as a speaker. I look forward to seeing you there! If you don’t know what SQL Saturday is, it’s a whole day of free SQL Server training available to you at no cost! If you haven’t been to a SQL Saturday, what are you waiting for!

Hello World on .NET Core

The developments over the last few months in the data community had brought us to an interesting place. We’re going to have SQL on Linux and now we also have .NET on Linux too! While the implications of this are unclear, and worthy of significant prognostication…I’m going to take this time to show you how to get started with .NET Core on a Redhat Enterprise Linux Based System. First up you’re going to need Redhat Enterprise Linux.

Upcoming Course – LFCE: Advanced Linux Networking

I’m pleased to announce that I’m working on a new course for Pluralsight. The course is titled LFCE: Advanced Linux Networking. This course targets IT professionals that design and maintain Linux based enterprises. It aligns with the Linux Foundation Certified Engineer (LFCE) objectives and can be used by both the IT pro learning new skills and the senior system administrator preparing for the certification exam. This course will dive deeper into the internals of networking, giving the viewer insight into how things work under the hood in Linux based networks.