Additional Articles


Technical Article

The Role of the DBA Related to Insider Threats and Regulatory Complian

This article deals specifically with insider threats to IT describing how IT professionals are implementing the necessary products, policies, and procedures to reduce insider threats and provide the necessary reporting for regulatory compliance.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-01-24

2,933 reads

Technical Article

CHAPTER FOUR: ORGANIZATIONALLY, WHERE DOES DATA GOVERNANCE FIT?

This is the fourth part of an ongoing series. The series is titled The Data Stewardship Approach to Data Governance. For information regarding future chapters, please use my contact information below. Previous articles were titled The Data Won't Govern Itself, Data Governance Is NOT a Methodology and The Tools of Data Governance.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-01-23

1,705 reads

Technical Article

Part 1: Developing an object oriented database in less than 140 lines

One of the best benefits of the .NET Framework over lower level programming is that it enables developers to create very complex, custom solutions, without writing low-level code. Zach Smith explores how you could take advantage of the built-in .NET Framework functionality to develop a simple object oriented database in less than 140 lines of code.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-01-19

4,211 reads

External Article

Refactoring Databases: The Process

This article describes how to implement a single refactoring within your database. It contains a worked example of the Move Column structural refactoring, whereby we move the Customer.Balance column to the Account table, a seemingly straightforward change to improve the database design.

2007-01-16

3,244 reads

Blogs

DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods

By

Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...

T-SQL Tuesday #203: Risk and Reward

By

This is timely, as I’m currently on a boat in the Adriatic taking a...

dataMinds Connect 2026 – Slides & Scripts

By

You can find the slides and SQL scripts for my session “Spice up your...

Read the latest Blogs

Forums

Communication, For Incidents and Life

By Pat Wright

Comments posted to this topic are about the item Communication, For Incidents and Life

PostgreSQL psql Meta Commands: Tables

By Grant Fritchey

Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables

Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server

By john.martin

Comments posted to this topic are about the item Building a Support Ticket Triage...

Visit the forum

Question of the Day

PostgreSQL psql Meta Commands: Tables

Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?

See possible answers