The SQL-92 standard introduced the LEFT Outer Join operation which offers a powerful alternative to standard relational processing to perform full hierarchical processing naturally and inherently. This enables SQL to transparently integrate relational data with XML, IMS and other forms of legacy hierarchical data. This can also allow the so far overlooked integration of IMS and legacy data with the Internet and XML, and visa versa.

The DBA of the Future

by Andy Warren

SQLServerCentral.com

Editorial

Today we have a guest editorial from Andy Warren that talks about what DBAs might need to know in the future.

Read and Write Binary Files in SQL Server with CLR

by Additional Articles

MSSQLTips.com

SQLCLR

You are a database developer looking for a common approach for handling read and write access to binary files. You may be a DBA wanting to read various information from binary files and collect it into tables. The code sample presented in this tip will get you started with binary file content handling in SQL Server.

PAAS

by Steve Jones

SQLServerCentral.com

Editorial

Platform as a service, a new way of looking at applications. It's analogous to SAAS and IAAS, which can improve the efficiency of the software purchase or the hardware acquisition process. Steve Jones notes that this is something he'd like to see for database platforms.

SQLServerCentral Best Practices Clinic: Part 2

by Brad McGehee

SQLServerCentral.com

In part 2 of our best practices clinic, Brad McGehee looks at a couple of the items that were misconfigured on the SQLServerCentral database instances.

Manage and Monitor Identity Ranges in SQL Server Transactional Replication

by Additional Articles

SQL Server Performance

Replication

This article demonstrates how to prevent primary key violation issues in transactional replication.

Mid April Free Training from PASS VCs

by Aaron Nelson

SQLServerCentral.com

Training

Free training sessions brought to you by the AppDev and BI Virtual Chapters of PASS.

Send email in a tabular format using SQL Server database mail

by Additional Articles

MSSQLTips.com

Database Mail

Some of our SQL Servers contain tables with summarized data (summarized on a weekly / monthly / quarterly basis). Previously this data was emailed as a flat file attachment to the recipients. I was asked to convert this in such a way that the email itself contains the table data. This way the recipients would be able to look at the data in a tabular format, making it easier for readability. Hence we arrived at the question of how to send email from SQL Server with data in a tabular format.

An nHibernate Head Scratcher

by David Poole

SQLServerCentral.com

Performance Tuning

An interesting mystery on why some nHibernate performance issues might exist on your systems. Read this piece from SQL Server expert David Poole and look to see if this is a problem you can easily solve in your environment.

Smart Energy Doesn't Seem So Smart

by Steve Jones

SQLServerCentral.com

Editorial

Quite a few utility companies and energy producers have ha data breeches in the last year, yet most of them don't have good tools to detect the intrusions or the support of executive management. Steve Jones talks about this being a problem in many companies.

SQL Transparent Hierarchical Processing of Relational, XML and IMS Data

The DBA of the Future

Read and Write Binary Files in SQL Server with CLR

PAAS

SQLServerCentral Best Practices Clinic: Part 2

Manage and Monitor Identity Ranges in SQL Server Transactional Replication

Mid April Free Training from PASS VCs

Send email in a tabular format using SQL Server database mail

An nHibernate Head Scratcher

Smart Energy Doesn't Seem So Smart

Blogs

Claude AI Convinced Me Not to Build an iPad App

A New Word: Dolorblindness

Claude Code Helps Analyze Test Data Manager Log Files

Forums

Data Warehouse Toolkit meets Star Schema: The Complete Reference

GPX distance and time analysis in SQL Server

The DBA is Dead; Long Live the DBA

Question of the Day

Changing the AG Listener