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 […]
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, […]
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?” […]
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 […]
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 […]
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 […]
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 […]
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, […]