Learn how you can guarantee the ordering of all messages in a Service Broker queue, regardless of conversations.

Deploying the same database to many different RDBMSs

by Additional Articles

SimpleTalk

humor

With the idea of a generic Dacpac defined by international standard, comes the potential for a Visual Studio developer to use SSDT to create a generic database model to a SQL-92 compliant standard that can then be deployed to any one of the major RDBMSs. The same database model would be deployable to Oracle, MySQL, or SQL Server, for example. Professor Hugh Bin-Haad explains the reasoning and technology behind this.

Finally, a Universal Data Integration Utility

by Tim Mitchell

Other

Blogs

Earlier today, a revolutionary product was released: a universal data integration utility.

Time to Rebrand

by Andy Warren

Other

Blogs

I became a SQL guy back in 1998 because the company that hired me used SQL Server. It’s been a good ride and it’s paid the bills, but after 15 years or so it’s time to do something different.

Shredding Unicode Japanese characters using SSIS

by Arun Mishra

SQLServerCentral.com

SQL Server

This articles describes two ways to shred Unicode Japanese character from xls files into SQL Server table using SSIS

Source Code Security

by Steve Jones

SQLServerCentral.com

Editorial

The code you use may contain security information. Be extra careful in this case, especially when you use encryption.

Getting Started with Database Engine Tuning Advisor in SQL Server – Part 2

by Additional Articles

Database Journal

Database Engine Tuning Advisor

Arshad Ali demonstrates how you can use the command line interface to tune SQL queries and how you can use SQL Server Profiler to capture the workload for tuning with Database Engine Tuning Advisor.

SQL Monitor Custom Metric: Hash Warnings (Last Hour)

by Press Release

Redgate

SQL Monitor

This alert is raised when the number of hash warnings events in the last hour goes above a specified threshold. A hash warning event means that part of the data processed for a hash operation was written to tempdb during query execution, which can degrade SQL Server Performance.

Obedience Training For Databases: Cascading Constraints

by Phil Factor

SQLServerCentral.com

constraints

In which Phil Factor illustrates in TSQL how it is possible to use foreign key constraints to enforce data rules, and illustrates some surprising consequences of using cascading.