Jared Kirkpatrick

About Jared Kirkpatrick

My life in the tech world started at Dell a little before the Windows 95 release. I started my MCSE there and took the Database track toward a MCDBA and never looked back. I’ve been head down in data ever since. My first exposure to SQL Server was with SQL 6.5. In addition to schooling at Wentworth Military Academy and two years at Southwestern University in San Marcos, Texas, my certifications are MCP, MCP+I, MCSE (NT 4.0), and MCDBA (2000). During my SQL journey, I have been a Supporting Author of SQL Server 2000 Blackbook, presenter at several PASS Chapters and at SQLSaturday, when it was still in the single digits! I was the IBM Principal Consultant for Honeywell and HR Logic, and Senior Developer for Match.com. I have extensive background with medical systems for employers like Maxium, Broadlane, Medassets, and Florida Cancer Specialists to name a few. The absolute biggest highlight of my career was the opportunity to travel across Europe for Baker and McKenzie, and on that trip I met my wife in Kiev.

T-SQL Framework: The Finished Product (pt. 5)

We now have a finished T-SQL framework, and this is the last post of the series. We start with the complete Template (with the error engine, activity log and batching). In this post, we’ll examine each new segment and focus on the batching feature, explain what is going on and the necessity.
The finished Template:

The Input […]

By |September 3rd, 2019|SQL, SQL Group, SQL Server|0 Comments

T-SQL Batching: Framework, pt. 4

In this fourth installment of the framework series, we will add a T-SQL batching feature to our existing framework we have developed in earlier installments of this series. This feature set is dependent on the work we have previously, done. If you have not been following along, please go back so that everything will work […]

By |August 27th, 2019|SQL, SQL Group, SQL Server|0 Comments

The T-SQL Activity Log: Framework, pt. 3

This segment of the framework builds onto what we have already created in Part 2 of the T-SQL Framework. That post showed you how to build the Error Engine, or build in tasks to do our error handling for us. In building the T-SQL Activity Log, we will leverage some of the structures and processes […]

By |August 21st, 2019|SQL Group, SQL Server|0 Comments

Strangest Things, Pt. 3: Linked Servers in SQL

As a consultant, you experience different environments, with different architectures, different skill sets, and different processes. Usually there’s just one thing in common: They have serious issues that need immediate attention. Such as using linked servers in SQL.
Once a consultant has some experience under his or her belt, one can usually see symptoms that can […]

By |August 13th, 2019|SQL, SQL Group, SQL Server|0 Comments

Framework, part 2: The SQL Error Engine

Building the SQL Error Engine
In this second post focused on a T-SQL framework (find part one here), we will build the plumbing to leverage our first feature of the framework, the error engine. This feature  will runs like an engine and do the manual work we do not want to do. To make it dynamic, […]

By |August 5th, 2019|SQL Group, SQL Server|0 Comments

What is a SQL framework, Part 1

We can define a framework in two simple ways:

An environment with tools to work with.
A scaffold around which we can build an application.

These definitions sound simple in an abstract way, but what is a SQL framework specifically, how will it help me, and do I have to use one? 
For the questions “what is a SQL […]

By |July 24th, 2019|SQL, SQL Group, SQL Server|0 Comments

Building a T-SQL Framework, Part I

Depending on the objective, building a framework allows the architect to imbed the fundamental segments of a structure so that the existing requirements can be built on top of the foundation, leveraging the functionality of the framework. This usually includes core functionality that repeats consistently through a process like Logging, Error handling, Successes/Failure Notifications, Import/Export […]

By |March 2nd, 2016|SQL Group|0 Comments

Much ado about GUIDs

How does one enforce referential integrity across separate databases, or servers for that matter?  The answer is simple—there is nothing native in SQL Server to enforce integrity outside of Primary and Foreign Keys which are scoped within a database.

However, you can go outside the box and use a Uniqueidentifier, often referred to as GUIDs (globally […]

By |October 20th, 2015|SQL Group|0 Comments

SSMS: The SQL Server Solution Project

There is a great feature in SQL Server Management Studio that I do not see used very often, and that feature is the SQL Server Solution Project. SQL Server Solution Project has been around since SQL Server 2005 and is based on the framework from Visual Studio. A Solution is made up of one or […]

By |September 8th, 2015|SQL Group|0 Comments

Check for Errors First, Part III: The Windows Event Logs

In Part I of Check for Errors First, we discovered how to query the error logs, and filter out the noise to find meaningful errors that could contribute to performance and stability issues. In Part II of Check for Errors First, we explored how to look for errors in the system trace which runs continually whenever SQL […]

By |June 24th, 2015|SQL Group|0 Comments