The SQL Error Engine: Framework, pt. 2

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? How will it help me, and do I have to use one? 
For the questions “what is a SQL framework?” […]

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

Automating DBCC DBTABLE – Obtaining the Disk Sector Size

It’s a best practice to have the disk sector size (also known as the allocation unit size or block size) set to 64kb (see this white paper), so how can you get that info programmatically?

I was recently reading this msdn article on Ghost Records, and it mentioned that you could get the number of ghost […]

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

Capture Index Maintenance Operations

One good database maintenance practice is to keep the indexes in good working order. This is typically done via index defragmentation routines. Some people perform routine index maintenance, some people do not, and still others have done some sort of “set it and forget it” script provided by a vendor and may or may not […]

By |January 21st, 2015|SQL, SQL Group, SQL Server|3 Comments

Moving Databases to New Drives: A Real-world Case Study Involving 120 Databases

Moving databases is a common enough task for the DBA, and there are multiple ways to move physical database files from one drive to another. Depending on your preference, you can either use the DETACH/ATTACH method:

 

Or you can use the ALTER DATABASE method:

Whichever method you prefer, these work great when you are moving databases, especially […]

By |July 29th, 2014|SQL Group, SQL Server|0 Comments

Missing Indexes Script v2

Frequently we hear the analogy that <insert item here> are like opinions, everybody has one and not all of them are good (some may stink).
Well, this may just be another one of those <items>.  Whether it stinks or not may depend on your mileage. It’s a missing indexes script.
I had shared a similar script back […]

By |June 15th, 2014|SQL Group, SQL Server|0 Comments

Utah Code Camp Spring 2012

This last Saturday was the most recent iteration of Utah Code Camp  and I have to say it was a resounding success.  In addition to speaking, I was invited to participate in an “Ask a DBA” panel discussion and also had the opportunity to have SQL Solutions Group sponsor the event.  So it was a […]

By |March 12th, 2012|SQL Group, SQL Server|0 Comments