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

The Strangest Things we’ve seen in SQL Server

You think Demogorgons and Mind Flayers are hard to deal with? Compared to some strange things we’ve seen in SQL Server databases, they’re a walk in the park. 
Most of the time, SQL Server is a wonderful, robust platform that can handle mountains of data, support all sorts of apps, and generally make life easier. Until […]

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

Easy Permissions Audit

Something I have written about more than a handful of times is the need to audit. When people think about audits, the first thing that comes to mind is most likely the IRS and taxes. More than taxes are audit-able. Despite that tendency to first think taxes when somebody says “audit”, I am not writing about […]

By |February 13th, 2017|Security, SQL Group, SQL Server|0 Comments

Security Configuration for Linked Servers

A few years ago I published an article about how to use linked servers to avoid performance issues. I wanted to follow up on that with a discussion of linked server security configuration because this is another big issue I see all too often with linked servers.

The first thing to understand is that all linked […]

By |October 4th, 2016|Security, SQL Group, SQL Server|0 Comments

Automating DBCC DBTABLE – obtaining the disk Sector Size

I was recently reading this msdn article on Ghost Records, and it mentioned that you could get the number of ghost records on a page with DBCC DBTABLE… and it also mentioned that you need to be sure that you enable Trace Flag 3604 in order to see the results. So, two things immediately jumped […]

By |April 28th, 2015|SQL, SQL Group, SQL Server|2 Comments

SQL Consultant Braves Weather to Serve Client

Spring may be only weeks away, officially, but the weather is plenty chilly in North Dakota. And Fargo, North Dakota, is where Jared Kirkpatrick, our newest SQL consultant, finds himself this week.

People go to Fargo all the time. Don’t they? But for Jared, this trip has  involved some serious weather whiplash. When he departed his […]

By |March 5th, 2015|SQL Group, SQL Server|0 Comments

A Faster Way to Migrate SQL Server Instances!

I have had to migrate SQL Server instances many times over the years. Sometimes as part of an upgrade from one version to another, and other times just to move to new/bigger better hardware. In my current situation, the client wants to virtualize all of their SQL Server instances. Most of their database servers are already virtualized, […]

By |February 9th, 2015|SQL Group, SQL Server|3 Comments