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

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

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

Spectre and Meltdown Exploits

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”)

Overview
Vulnerabilities exist in multiple modern CPU architectures that could […]

By |January 18th, 2018|News, SQL, SQL Group|0 Comments

sp_server_diagnostics – Black Box Recorder

A few months back I began a series about the SQL Black Box Recorder, that you can read here, with a promise of at least two more posts. The first article in the series laid the groundwork about the black box recorder in SQL Server. Furthermore, there was a brief introduction into the three components […]

By |July 26th, 2016|Extended Events, SQL, SQL Group|0 Comments

SQL Black Box Recorder part II

A few months back I began a series, about the SQL Black Box Recorder that you can read here, with a promise of at least two more posts. The first article in the series laid the groundwork about the black box recorder in SQL Server. Furthermore, there was a brief introduction into the three components […]

By |April 6th, 2016|Extended Events, SQL, SQL Group|0 Comments

Indexed Views – Performance Panacea or Plight

Indexed View(s)
An indexed view is a view where the result set from the query (the view definition) becomes materialized in lieu of the virtual table result set of a standard (non-indexed) view. Many times we see that an indexed view would be created to help improve performance. Far too often, an indexed view is created without consideration for the […]

By |January 28th, 2016|SQL, SQL Group|2 Comments

Disk Space and SQL Server

Disk Space in SQL Server
One of the frequently required job functions of the database administrator is to track disk space consumption. Whether this requirement comes from management or from a learning opportunity after a production outage, the need exists.
As a hard working DBA, you want to make sure you hit all of the notes to make […]

By |January 21st, 2016|SQL, SQL Group|2 Comments

SQL Black Box Recorder

Across many professions and industries there is often a need to have some sort of device that “audits” everything that happens with a device or process. We are probably all quite familiar with the infamous black box recorders used by the passenger airline and train industries. It is also quite possibly fairly common knowledge that […]

By |January 12th, 2016|Extended Events, SQL, SQL Group|0 Comments