Additional Articles

SQL Transparent Hierarchical Processing of Relational, XML and IMS Data

by Additional Articles

Other

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.

2011-04-15

3,437 reads

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.

2011-04-14

4,324 reads

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.

2011-04-13

2,438 reads

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.

2011-04-12

5,799 reads

Database Design Example: Curriculum Vitae

by Additional Articles

InformIT

Database Design

I’ve explained the database design process in a series of articles that you can find here. In this tutorial, I’ll put that information to good use and design a database from the start of the process to the finish. To keep this example to a single article, I’ll not repeat the information from those previous articles, so make sure you look those over before reading this one.

2011-04-11

5,179 reads

Continuous Integration for SQL Server Databases

by Additional Articles

SimpleTalk

software development

When it comes to the subject of putting databases into source control, Troy Hunt is no shrinking violet. “Database source control is no longer negotiable”. In this article, published originally in his Blog, Troy explains how to do Continuous Integration from a database that is in a Version Control System (VCS).

2011-04-08

4,700 reads

SQL Server 2008 and 2008 R2 Integration Services - Managing Remote Processes Using Script Task

by Additional Articles

Database Journal

Administration

Marcin Policht discusses ways to launch processes for remote systems using SQL Server 2008 R2 Integration Services.

2011-04-07

3,153 reads

Using PowerShell to Manage SQLServer

by Additional Articles

SQL Server Performance

Administration

This article provides a practical example of how Powershell can be used by DBAs.

2011-04-06

4,478 reads

TOP 10 SQL Server Requests That Should Be Automated

by Additional Articles

Database Journal

Administration

What DBA wouldn't want to make their job a little easier?

2011-04-05

6,926 reads

SQL Server Service Broker Poison Message Handling

by Additional Articles

SQLServerCentral.com

Service Broker (SSSB)

Have you ever figured out why your Service Broker queue gets disabled automatically? What causes your Service Broker queue to get disabled in the first place? What is a poison message with respect to Service Broker? Is there anything new in SQL Server 2008 R2 for managing poison messages in Service Broker?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2011-04-04

3,619 reads

All authors

Additional Articles

SQL Transparent Hierarchical Processing of Relational, XML and IMS Data

Read and Write Binary Files in SQL Server with CLR

Manage and Monitor Identity Ranges in SQL Server Transactional Replication

Send email in a tabular format using SQL Server database mail

Database Design Example: Curriculum Vitae

Continuous Integration for SQL Server Databases

SQL Server 2008 and 2008 R2 Integration Services - Managing Remote Processes Using Script Task

Using PowerShell to Manage SQLServer

TOP 10 SQL Server Requests That Should Be Automated

SQL Server Service Broker Poison Message Handling

Blogs

SQL Server Journey till 2025 (brief)

Building Power BI Reports: Desktop vs Fabric

Identity Columns Can’t Be Updated: #SQLNewBlogger

Forums

Can someone please explain what happens?

SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0

Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform

Question of the Day

Creating JSON III