Case Studies

Ding - The World’s Largest Mobile Top-up Network Streamlines QA with SQL Server Containers

• by Andrew Pruski

• SQLServerCentral.com

• Containers

• Article

In this case study, see how database containers can help improve a QA process.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (2)

Log in or register to rate

You rated this post out of 5. Change rating

2017-03-16

541 reads

• Discuss

Microsoft IT: A Case Study on “Hekaton” against RPM

• by Additional Articles

• Microsoft MSDN

• Hekaton

• Article

I/O latch can cause session delays that impact application performance. This white paper describes the procedures and common I/O latch issues when migrating to Hekaton in SQL Server 2014. It also includes challenges that occurred during the migration and the performance analysis at different stages.

2016-01-25

2,632 reads

Discuss content posted by Dmitriy Ivanov

• by administrator

• Datawarehouse.com

• Forum

Discussions about content posted by Dmitriy Ivanov

2012-04-10

3 reads

Discuss content posted by Ric Vander Ark

• by administrator

• SQLServerCentral.com

• Forum

Discussions about content posted by Ric Vander Ark

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2009-09-23

12 reads

SqlCredit – Part 10: MAC Performance and Updating SqlCredit

• by Additional Articles

• Database Journal

• Case Studies

• Article

This month's installment of "Developing a Complete SQL Server OLTP Database Project" covers MAC performance results, a summary of encryption findings, and comments on updating the SqlCredit code based on those findings.

2007-11-13

1,635 reads

Case Study: Denver International Airport Keeps Operations/IT (and Pass

• by Additional Articles

• Datawarehouse.com

• Travel/Hospitality/Recreation

• Article

AlarmPoint Enterprise automates alerting process and protects airport's massive information and communications network from business-impacting outages.

2007-08-06

1,471 reads

• Discuss

Using SQL Server 2005 Integration Services in a Scalable Business Inte

• by Additional Articles

• MSDN Communities

• Case Studies

• Article

By using Microsoft® SQL Server™ 2005 Integration Services (SSIS) to perform metrics calculations on data extracted from the Siebel Call Center database, the cross-IT (XIT) group in Microsoft Information Technology (Microsoft IT) was able to replace a former reporting application with a new scalable and flexible reporting application to improve reporting throughout the organization

2006-02-14

1,956 reads

• Discuss

High Call Volume SQL Server Applications on NUMA Systems

• by Additional Articles

• SQL Server Performance

• Case Studies

• Article

One of the most difficult database operations to scale-up on high-end server systems is the network call. In fact, without special precautions, a high call volume database application can have severe negative scaling on large systems. It is suspected that this problem is more pronounced on NUMA systems than basic SMP systems. A NUMA system with 16 processors can have significantly lower throughput capability than an otherwise comparable 4-way SMP system.

2005-10-25

1,754 reads

• Discuss

RE: "Column encryption" software recommendations?

• by DAVNovak

• Redgate

• Reply

I have had some success working with a product called 'xp_Crypt'. If you would like to look into this product, check out 'www.activecrypt.com'.   I had a need to encrypt account numbers that where to be accessed from an in-store kiosk.  I found this product very easy to work with and understand.  The nicest thing about it […]

2005-05-17

RE: Creating report from one table

• by Frank Kalis

• Redgate

• Reply

Probably something like this?set dateformat dmy create table #t (  customer varchar(4)  , accountcode  int  , dt datetime  , debit float  , credit float ) insert into #t select 'AUBM', 600000, '01/12/2004', 10, 0 union all select 'AUBM', 700000, '01/12/2004', 0, 25 union all select 'AUBM', 700000, '05/12/2004', 0, 55 union all select 'AUBM', 600000, […]

2005-05-11