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 […]
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?” […]
Strangest Things Pt 2: 505 executions per second
I’ve been a SQL Server DBA for more than 20 years and have spent the last 10 of those consulting. When you’ve been doing this for as long as I have, there’s not a lot of new issues that come up that you haven’t seen before. Which is […]
You’re registered for the next SQL conference or event and are excited about expanding your SQL knowledge and skills and connecting with peers. But, even though attending is your idea (i.e., “the boss” isn’t making you go), you’re wondering how to get maximum benefit from attending—what sessions to hit, which to miss, who to network […]
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 […]
Spectre and Meltdown
In recent weeks, a significant security risk was exposed. This exploit has been named in two fashions: Spectre and Meltdown. We at SSG feel it important to help disclose the severity and impact of these exploits with this formal release.
Unauthorized Memory Disclosure through CPU Side-Channel Attacks
(“Meltdown” and “Spectre”)
Vulnerabilities exist in multiple modern CPU architectures that could […]
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 […]