SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Kyle Neier

Kyle has been working with computers professionally since 1995 in both a development and administrative capacity. For over 10 of those years, SQL Server has been the focus of both a professional and personal passion. Kyle has worked in online retail, manufacturing, EMR software, and pharmaceutical industries. Kyle joined PTI in 2011 as a Senior Microsoft Consultant where he continues to chase his passion of automating DBA processes and doing everything humanly possible to prevent the 0200 page. Kyle serves as the Vice-President of the Indianapolis chapter of PASS (www.indypass.org) and served on the committee to bring SQL Saturday to Indianapolis. He shares his passion for SQL Server with others through speaking and mentoring at local and regional events.


Two Thousand Five Hundred Sixty. Seems like such a random and unassuming number, however, I can say this was the most disturbing number on the spectrum of disturbing numbers over the past few weeks. The numbers 13 and 666 were child’s play compared to the stress that 2,560 created.


Read more

1 comments, 1,420 reads

Posted in Kyle Neier on 23 October 2012

Vacation and SQLSat149

When I was considering submitting some sessions to SQL Saturday 149 in Minnesota I thought I would have a difficult time selling it to my family. It’s been very busy around here and I didn’t know how another trip may have been received. Much to my surprise, when I mentioned…

Read more

1 comments, 786 reads

Posted in Kyle Neier on 22 September 2012

T-SQL: Performance of SQL Agent Duration Calculations

In my article published yesterday on using Powershell for SQL Durations (Working with SQL Agent Durations), I proposed using a combination of math functions to extract the durations of SQL Agent jobs in a dependable and accurate manner. While the article sought to provide a better alternative for…

Read more

0 comments, 1,549 reads

Posted in Kyle Neier on 24 August 2012

Nacho Mama’s Training Class

That is what I wanted to name the new training series that we developed at my employer, Perpetual Technologies (PTI.net). Unfortunately, I couldn’t convince anyone to change their name to Nacho Mama, but I digress…

On August 22 and August 23, PTI is offering a two day workshop… Read more

0 comments, 1,001 reads

Posted in Kyle Neier on 9 August 2012

SQL Saturday 122: T-SQL 2012 presentation

This last weekend, I had the pleasure of being invited down to Louisville, KY to speak at SQL Saturday #122. The volunteers there chose to have me speak on some of the new features of SQL Server 2012 T-SQL.

I barely fit everything in the session – finishing up just… Read more

0 comments, 970 reads

Posted in Kyle Neier on 24 July 2012

Speaking at SQL Saturday 122 - Louisville

It has been a great couple of months for both me and for Perpetual Technologies (my employer). PTI has been able to sponsor several SQL Saturday events and we have had several members of the Microsoft team speak at numerous events.

I've been granted the pleasure to speak at SQL…

Read more

0 comments, 848 reads

Posted in Kyle Neier on 9 July 2012

Powershell Add-Member: IsLogBackupAllowed ?

In my previous post, I shared some of the issues I had when attempting to get Add-Member to work with the SMO Database object. In this post, I’ll share some of the fruits of that experience as I show how to quickly determine if a database can have its…

Read more

2 comments, 1,470 reads

Posted in Kyle Neier on 5 July 2012

Powershell, SMO, and Add-Member - Not Always BFF

Over the past few weeks, I’ve been working with SMO to implement some maintenance routines across my clients. Because of the nature of most of my clients, Powershell is almost always the answer. I have been trying to simplify the coding of some of these scripts by using Add-Member.

Read more

0 comments, 3,807 reads

Posted in Kyle Neier on 28 June 2012

Enumerating Index Fragmentation with Powershell and SMO

I wish I could say that this was a simple task, but as I dove into SMO and some of its limitations, I soon discovered this would more difficult than I had imagined. I’m happy to share some background and some of the trials I had to overcome so that… Read more

1 comments, 2,216 reads

Posted in Kyle Neier on 19 June 2012

Powershell Add-Type – Where’s That Assembly!

I’ve been working a lot lately with SMO and the differences between the various versions between SQL 2005, 2008, and 2012. Through this process, I’ve come to understand why “[Reflection.Assembly]::LoadWithPartialName” is not a good option in PowerShell. Not only is it obsolete, it doesn’t allow you to choose which…

Read more

8 comments, 14,416 reads

Posted in Kyle Neier on 6 June 2012

The 2012 Powershell Scripting Game(shows) in review

Over the past few weeks, those around me know that I’ve been talking a lot about Powershell, how much it can improve your life, and about the 2012 Powershell Scripting Games. Nearly everyone I’ve shared with has asked “What are the Scripting Games?”

My answer to them was and…

Read more

0 comments, 1,164 reads

Posted in Kyle Neier on 1 May 2012

PowerShell: Using Exponents and Logs to Format Byte Sizes

In a recent Scripting Games event, I had to format some byte values into their most appropriate size according to how many bytes were present. Anyone who hangs around with me long enough will realize I love numbers and the preciseness that they provide. This is one of many reasons…

Read more

3 comments, 3,270 reads

Posted in Kyle Neier on 19 April 2012

PowerShell and T-SQL: Implementing UNION, INTERSECT, and EXCEPT

I’ve been thoroughly enjoying my experience this year with the Scripting Games. This is the first year I've competed and I decided to participate in the Advanced category just to push myself a little harder. I’ve been using Powershell for quite some time, however, I’ve never had the pleasure of…

Read more

2 comments, 5,802 reads

Posted in Kyle Neier on 12 April 2012

T-SQL Tuesday #029 – SQL 2012 and Treating TempDB like it’s really Temporary.

A while back, my young son thought it would be fun to use a CD as a virtual surfboard on our kitchen floor. While he was a very proud boy, all I could think of was how much that CD cost and how unlikely it was that we were going…

Read more

0 comments, 1,561 reads

Posted in Kyle Neier on 10 April 2012

Powershell – Validating an IP Address


A task that I have had to do several times over the years is determine if an IP Address string entered from a prompt or imported from a file is indeed valid. Even more, determining if that IP Address is in use once verifying that the IP Address is… Read more

0 comments, 4,156 reads

Posted in Kyle Neier on 3 April 2012

Error 18456 a little more friendly in 2012

While preparing a demo for a presentation, I generated a 18456 error in the SQL instance by selecting a non-existent database in my connection string.

To my surprise, the SQL Errorlog now discloses the database that I was trying to connect to:

This seems to be improved for at least… Read more

0 comments, 1,161 reads

Posted in Kyle Neier on 29 March 2012

Powershell – Adding accounts to Local Security Policy


One of the challenges I’ve had over the years is figuring out a way to add the SQL Service accounts to the “Perform Volume Maintenance Tasks” and “Lock Pages in Memory” local security policy privileges.

Kendra Little published a post a while back that utilized NTRights.exe. Unfortunately, this is… Read more

7 comments, 10,433 reads

Posted in Kyle Neier on 27 March 2012

Powershell - Working with Cluster Resources - Byte Arrays

Over the next few weeks, I plan to share some of the discoveries I've had when working with Windows 2008R2 Clusters and Powershell. I've had the pleasure of changing disk resource names, adding IP Address and Network Names (CAPs), Implementing DTC, adding File Shares, adding custom resources, and even installing…

Read more

0 comments, 2,124 reads

Posted in Kyle Neier on 19 March 2012

T-SQL Tuesday #028 – Is it really specialization?

This is the first time I've participated in T-SQL Tuesday - I hope to do so more often...

I can recall several years ago being a jack of all trades kind of guy. I was doing development, security, server support, workstation support, database support, and even working with the physical…

Read more

1 comments, 1,011 reads

Posted in Kyle Neier on 13 March 2012

Finding the Missing Perfmon Counters in SQL Express

My post this weekend about slaying beasts with magical .dll incantations was my way of relieving some stress after having to work an entire Saturday unplanned. My goal with this post is to provide a little more insight into the problem and the solution that was discussed in a very…

Read more

2 comments, 2,132 reads

Posted in Kyle Neier on 7 February 2012

Older posts