Skip to content

Software Development News: .NET, Java, PHP, Ruby, Agile, Databases, SOA, JavaScript, Open Source

Methods & Tools

Subscribe to Methods & Tools
if you are not afraid to read more than one page to be a smarter software developer, software tester or project manager!

Database

User Login Permission Detail

Database Journal News - Fri, 04/24/2015 - 21:48

Use this stored procedure to quickly capture all login information when needed, especially for security audit situations.

Categories: Database

Azure Premium Storage provides highest performance for SQL Server in Azure VM

Last week we announced the General Availability of Azure Premium Storage for Azure Virtual Machines.

Premium Storage provides steady high throughput (up to 64,000 IOPs; 8x more than Standard Storage) at low latency (single-digit milliseconds; 8x less than Standard Storage). This enables enterprise SQL Server workloads (OLTP or Data warehousing) needing consistent high performance to run on Azure VM.

During the Preview of Azure Storage we worked with many SQL Server customers of different workload sizes to ensure that Premium Storage satisfied their requirements on Azure VM.  Here are some examples of customer results:

  • Transaction latency for thousands of concurrent users consistently within 10ms
  • Query times over large data sets reduced from minutes in standard storage to seconds
  • Batch loads for millions of records reduced from hours in standard storage to minutes
  • Backup/restore times on large databases reduced from many hours in standard storage to less than one hour
Azure Premium Storage and SQL Server

Premium Storage is based on Solid State Disks (SSD) in the storage backend, dedicated fast connections between the storage backend and new compute clusters, and VMs local read-only caches that are also SSD-based. Writes are sent to the backend to guarantee their persistence via 3 copies. Writes trigger an update on the VM read-only cache. Reads that can be served from the cache return immediately; others are served quickly from the backend, also updating the cache as a result. More details here.

VMs using Premium Storage get a guaranteed higher storage bandwidth to serve writes and reads. Reads served from the cache are not counted towards this bandwidth. The high bandwidth allows writing and reading more data per second to the storage. This increases transaction throughput and reduces the time for query scans and other operations such as backup/restore, batch loads, and index rebuilds.

The following PerfMon picture shows a SQL Server backup consistently reading and writing ~500MB/s:

The main benefit of the fast storage writes is lowering SQL Server transaction latency. This is achieved by shortening the time to synchronously write commit records to the log file. This benefits both standalone and AlwaysOn configurations, where the secondary must ACK writing commit records. Besides this, the fast storage writes reduce the time for other SQL Server write operations (e.g. checkpoints (asynchronously writing dirty pages to disk), AlwaysOn secondary’s log redo, etc).

The main benefit of fast reads is lowering SQL Server query time. This is achieved by shortening the time to retrieve data pages, especially if served from the read-only cache. In addition, the higher storage bandwidth aids retrieving more data pages. The benefit of the read-only cache is for data files, as data pages are read very frequently. There is no benefit for log files, as log records are only read during distant operations (e.g. backups).

The following PerfMon picture shows a SQL Server workload executing an average of 9K Batch Requests per second. This accounts for 20K reads and 17K writes per second (37K IOPs). The average read latency is just 1ms with a max of 6ms, and the average write latency is just 3ms with a max of 10ms.

Azure Premium Storage Options

There are 3 types of Premium Storage disks to choose from: P10, P20, and P30. The type of disk is determined by its size. Each disk type is assigned a different number of IOPs and bandwidth:

Disk Type

Disk Size

Storage IOPS

Storage Bandwidth (MB/s)

P10

128 GB

500

100

P20

512 GB

2300

150

P30

1024 GB

5000

200

 

To support Premium Storage, there is a new series of VMs called DS-Series. The capabilities of these VMs are below:

 VM Size

CPU Cores

Max

Storage Disks

Max Storage Space

Max Storage IOPS*

Max Storage Bandwidth (MB/s)

Cache size (GB)

DS1

1

2

2 TB

3,200

32

43

DS2

2

4

4 TB

6,400

64

86

DS3

4

8

8 TB

12,800

128

172

DS4

8

16

16 TB

25,600

256

344

DS11

2

4

4 TB

6,400

64

72

DS12

4

8

8 TB

12,800

128

144

DS13

8

16

16 TB

25,600

256

288

DS14

16

32

32 TB

50,000

512

576

  * Doesn’t include IOPs directly from the VM read-only cache

Notice that the total number of IOPs and bandwidth will depend on the combination of VM size, number of disks, and the sizes of these disks.

Consider the size of your database, workload requirements, and pricing when choosing the above. Notice that a VM can have disks with different sizes and, it’s even possible to mix disks from Premium and Standard storage. More details here.

Creating a new SQL Server Virtual Machine using Premium Storage
  1. Go to the new Azure Portal
  2. Create a storage account of type Premium Locally Redundant

    Notice that there is a limit of 32TB per storage account. If you need more storage, then create more storage accounts.
  3. Create a new VM using a SQL Server Image from the Gallery, specifying a DS-Series VM, and the Premium Storage account that you previously created (type PREMIUM-LRS). Notice that this VM can’t be added to resource groups that have other VM Series (DS-Series are hosted by new compute clusters).

  4. Attach disks to the VM
    Select the VM that you previously created, go to Disks, and select Attach New. Choose the Premium Storage account that you previously created, a container for the disk (by default vhds), the disk file name, size, and caching. A common basic configuration is using 3 disks, one for data, another for log, and another for TempDB.
Migrating an existing SQL Server to Premium Storage

Notice that it’s not possible to upgrade an existing Standard Storage account to Premium Storage and that DS-Series VMs can’t be added to a Resource Group that have other VM Series. 

To migrate an existing SQL Server to Premium Storage please create a new DS-Series VM that uses a Premium Storage account. Then backup and restore your databases and copy your SQL configuration (equivalent to a side-by-side migration).

To reduce downtime during the migration to few minutes:

  1. Take a full backup of the databases and restore them to the new SQL VM
  2. Disconnect the clients from the databases in the old SQL VM
    ALTER DATABASE SET SINGLE_USER WITH ROLLBACK AFTER 20 SECONDS
  3. Take a log backup of the databases (for any final transactions) and restore them to the new SQL VM
  4. Change the clients connection string to point to the new SQL VM

If you are using SQL AlwaysOn Availability Groups you can minimize downtime during the migration to seconds. Availability Groups allow you to failover a group of databases from a primary SQL Server replica to a secondary SQL Server replica in seconds without data loss. In addition, applications connect to the primary replica using a listener (virtual network name), so their connection string doesn’t need to change.

You can add a synchronous secondary SQL Server replica in a DS-Series VM that uses Premium Storage and failover to it. Notice that you will need to add the secondary replica VM to the same Windows Domain and the same Windows Cluster as the primary replica. In addition, you will need to create an endpoint for the secondary replica VM and add it to the load balancer supporting the Availability Group listener.

More details here.

Performance Best Practices

Most existing performance best practices apply to Premium Storage. Premium Storage disks have much higher bandwidth and IOPs limits than Standard Storage disks, thus a smaller number of Premium Storage disks will satisfy the performance requirements (especially for P30 disks). Consider the bandwidth and IOPs limits of the DS-Series VM sizes when determining the number and types of disks.

To get the highest performance:

  1. Use a Premium storage account and VM in the same region
  2. Use separate disks for data files, log files, and TempDB files
  3. Enable the read-only cache for data disks and TempDB disks, but not for log disks
  4. If you need higher bandwidth or IOPs: use Storage Spaces over multiple disks to aggregate their IOPs, bandwidth, and storage space. Use separate Storage Spaces for data and log. Depending on your TempDB requirements you could put TempDB in the Storage Pool for data files or in a different pool.
Summary

Premium Storage provides steady high throughput at low latency. This enables enterprise SQL Server workloads (OLTP or Data warehousing) needing consistent high performance to run on Azure VM.

Many SQL Server customers of different workload sizes have satisfied their requirements on Azure VM using Premium Storage. We hope that you will too!

Premium Storage is available in the following regions: West US, East US 2, West Europe, East China, Southeast Asia, West Japan. It’ll become available in other regions soon.

 

Learn more about SQL Server on Azure VM and try Premium Storage today!

Categories: Database

Improve ETL performance in BLU Acceleration

IBM - DB2 and Informix Articles - Thu, 04/23/2015 - 05:00
IBM DB2 with BLU Acceleration is a leap forward in database technology to improve query performance, particularly in the data warehouse (DWH) and decision support system (DSS) environments. It leverages dynamic in-memory, actionable compression, parallel vector processing, and data-skipping innovations from IBM Research to deliver a unique combination of performance, ease of use, and cost efficiency. In real-time reporting systems where the ETL process needs to update/delete data frequently from column-organized tables, it usually takes more time, resulting in performance issues for reports and dashboards. Learn how to improve these functions.
Categories: Database

Oracle Utilities Network Management System Effectively Manages and Utilizes Data to Help Reduce Cost and Improve Grid Reliability

Oracle Database News - Wed, 04/22/2015 - 13:01
Oracle Utilities Network Management System Effectively Manages and Utilizes Data to Help Reduce Cost and Improve Grid Reliability

REDWOOD SHORES, Calif.—April 22, 2015—Electric utilities traditionally rely on delivering power generated from central plants connected to transmission grids that lead through the distribution network and ultimately to the customer. However, electric distribution is changing rapidly as consumers continue to adopt beyond-the-meter technology that can shape grid reliability and performance—pointing toward increased risks for utilities resistant to change. To help utilities embrace this growth opportunity, Oracle recently made significant updates to Oracle Utilities Network Management System to help enterprises more easily and effectively integrate distributed energy resources—including rooftop solar, wind turbines, and batteries—based on location and condition of use.

“Oracle Utilities Network Management System 1.12.0.2 is an advanced distribution management system [ADMS] that empowers utilities to flexibly manage distribution grid data to improve reliability and reduce cost,” said Rodger Smith, senior vice president and general manager, Oracle Utilities. “It supports vital distribution automation to the substation and distributed generation management thanks to a scalable, real-time data model and optimization engine. These capabilities are built on one of the world’s best outage management systems, as demonstrated during Superstorm Sandy, making Oracle Utilities Network Management System the best solution for utilities that need a storm-proven, scalable ADMS platform that also manages distributed energy resources.”

Existing grid technology, typically referred to as operation technology (OT), cannot manage the variable output associated with distributed energy resources or the overloads and voltage violations from back feeds and intermittency. Legacy OT, which uses a supervisory control and data acquisition (SCADA) system as its real-time data engine, cannot scale to support devices being added to the distribution grid, such as consumer energy methods (rooftop solar, electricity storage, and electric vehicles) and rapidly growing data volume. Utilities lack the ability to model and plan for distributed energy resources and their potential for grid disruption.

With Oracle Utilities Network Management System 1.12.0.2, utilities can easily integrate distributed energy resources to better manage load and improve grid reliability while reducing costs and the need to bring additional generation resources online. This updated Oracle Utilities solution supports increased customer choice to participate in demand response, load shifting, and the sales of excess and stored distributed energy resources into other markets.

In Gartner’s 2015 Magic Quadrant for Advanced Distribution Management Systems1, which evaluates technology vendor capabilities as they relate to modernizing distribution grid operations and satisfying customer expectations, Gartner named Oracle a leader in advanced distribution management based on the company’s ability to execute and completeness of vision.

Additional Information

To learn more about Oracle Utilities, follow @OracleUtilities on Twitter and join the Oracle Utilities community on Facebook.

About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Contact Info

Samantha Thai
Oracle
+1.510.917.5564
samantha.thai@oracle.com

Mary Tobin
O’Keeffe & Company
+1.503.658.7396
mtobin@okco.com

1Gartner, “Magic Quadrant for Advanced Distribution Management Systems,” Randy Rhodes, Zarko Sumic, March 17, 2015.

Gartner does not endorse any vendor, product, or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner’s research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.

Categories: Database, Vendor

SQL Server 2005 support ends April 2016. Are you ready?

Don’t get caught off-guard.

Upgrading to Microsoft SQL Server 2014 helps you maintain security and compliance, gain faster data insights, and optimize your data infrastructure—all using familiar tools you already know and trust.

Be prepared when extended support for SQL Server 2005 ends. Protect your data with a thoughtful upgrade plan and mitigate cost and risk. Read this complimentary report today to learn more about the robust backward compatibility features and tools that enable a range of migration options. 

Read Directions on Microsoft’s report: Migrating from SQL Server 2005

Categories: Database

APL Logistics Delivers Industry Leading Logistics Services with Oracle Technology

Oracle Database News - Tue, 04/21/2015 - 13:00
Press Release APL Logistics Delivers Industry Leading Logistics Services with Oracle Technology APL Logistics wins Oracle’s 2014 Travel and Transportation Industry Excellence Award

Redwood Shores, Calif.——Apr 21, 2015

APL Logistics is a global logistics specialist in the auto, consumer, industrials and retail verticals. It provides a comprehensive toolkit of services and customized technology solutions to help customers outperform their markets. Its range of services includes freight and transportation management, customs brokerage, warehousing, distribution and supply chain consulting. APL Logistics offers customized technology solutions and applications that help customers analyze and optimize their supply chains. Its Logistics SuperSuite initiative—a global, enterprise-wide upgrade of its technology platforms—uses Oracle Value Chain Execution applications. As a result of its excellence and innovation, Oracle has named APL Logistics a winner of the 2014 Travel and Transportation Industry Excellence Award for transformation and industry leadership.

"To support growth in our four verticals, we are strengthening our suite of technology solutions to support our customers' supply chain needs," said May Chew, Head, Technology Services for APL Logistics. "By collaborating with Oracle in developing innovative transport solutions, we enable our customers to outperform their markets through industry-leading transportation planning and execution capabilities."

APL Logistics launched ShipmentOptimizer™ in 2010 which is powered by Oracle Transportation Management. The solution optimizes shipment plans by maximizing load utilization and minimizing transportation costs while meeting lead time and capacity constraints. The APL Logistics ShipmentOptimizer™ serves leading shippers in North America, Europe and Asia and is currently dynamically regulating the product flows for a global fashion manufacturer, helping them to transform their supply chain. It has automated shipment planning and forecasting while dramatically reducing the optimization assessment time.

"Powered by Oracle Transportation Management, APL Logistics' ShipmentOptimizer™ delivers industry leading transportation planning capabilities to shippers," said Vijay Anand, senior director and global lead, Travel, Transportation, and Logistics, Oracle. "APL Logistics, a winner of Oracle's Travel and Transportation Industry Excellence Award, embodies the unique ability to fuse ingenuity with the right technology solutions to drive new opportunities for growth."

In 2013, APL Logistics deployed Oracle Transportation Management in North America, Europe, and Asia to optimize domestic land transportation. One of the world's largest chemical companies is using APL Logistics' services to reduce its transportation costs and improve supply chain visibility for its operations in China. The operations involve managing transportation across 30 trucking companies for thousands of orders annually.

As a result of APL Logistics' leading industry innovation and business leadership, Oracle has honored the company with its 2014 Travel and Transportation Industry Excellence Award. The annual awards recognize successful transformation and leadership in the travel and transportation industry.

"APL Logistics is a prime example of a customer with strong leadership and a vision that technology innovation can support. Oracle has worked closely with APL Logistics to deliver the key capabilities APL Logistics needed for its logistics transformation initiative," said Shaun Han, vice president, ASEAN, Oracle. "Oracle values its relationship with APL Logistics and is delighted to recognize it with the Industry Excellence Award for 2014."

Contact Info Valerie Beaudett
Oracle
+1.650.400.7833
valerie.beaudett@oracle.com Mary Tobin
O'Keeffe & Company
+1.503.658.7396
mtobin@okco.com About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit http://www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Learn More Oracle Value Chain ExecutionOracle Transportation Management Talk to a Press Contact

Valerie Beaudett

  • +1.650.400.7833

Mary Tobin

  • +1.503.658.7396

Follow Oracle Corporate

Categories: Database, Vendor

CONCAT and STUFF Functions in SQL Server 2012

Database Journal News - Mon, 04/20/2015 - 08:01

The difference between the CONCAT function and the STUFF function lies in the fact that CONCAT allows you to append a string value at the end of another string value whereas STUFF allows you insert or replace a string value into or in between another string value. Read on to learn more about these functions and their real life usage.

Categories: Database

Call for Papers, PostgreSQL Session #7, September, 24th

PostgreSQL News - Mon, 04/20/2015 - 01:00

After six successful sessions dedicated to the new features of PostgreSQL 9.0 (February 2011), to PostGIS (June 2011 & September 2014), to replication systems (February 2012), to migration from Oracle to PostgreSQL (October 2012), and to PostgreSQL performance (March 2013), we'd like to announce that the 7th PostgreSQL Session will be held on September 24th, 2015, in Paris, France.

This year, another place, but always the same format! This day of lectures will be dedicated especially to the next version of PostgreSQL, but not exclusively!

For more information, see http://www.postgresql-sessions.org/7/about

We're launching a call for papers for this event. You may now submit your talks, in English or in French. Each talk should last 30 minutes (questions included). We are interested in any talks on the following subjects:

  • What's New in PostgreSQL
  • Use cases
  • Migration to PostgreSQL
  • Performance Tuning
  • Backup and Restore
  • High-Availibity
  • Data Warehouse / Big Data
  • PostGIS

Talks can be either: a case study, a Proof of Concept, a tutorial, a benchmark, a presentation of a new feature, etc. Of course, we're open to propositions on any other migration related topics (monitoring, hardware, replication, etc.) !

The submission deadline is June 15, 2015.

You can now send your proposals to call-for-paper@postgresql-sessions.org

Please give us a little information about yourself and your talk, such as:

  • First Name and Last Name
  • Twitter Account (if any)
  • Company
  • Short Biography (contributions to the PostgreSQL community)
  • Talk title
  • Talk abstract
  • Any specific needs

Slides should have a free licence (Creative Commons BY-ND 3.0 or compatible), and sent to Dalibo.

This day will be filmed, and all the lectures will be recorded and published after the Session. By sending a proposal, you agree to be recorded and waive any compensation for it.

The selected speakers not living in France will be reimbursed for travel and one night accomodation.

See you in Paris in September!

About the PostgreSQL Sessions:

The PostgreSQL sessions are designed to be a time to discover and meet the PostgreSQL community. Each session is a single day consisting of lectures, organized around a specific theme and a guest. The proposed talks aimed at all levels and all profiles: Developer, Administrator, Project Managers, IT Managers, ...

Entry is free and open to all, within the limits of available seats.

About Dalibo:

Since 2005, Dalibo is the leading French PostgreSQL company and provides its experience and expertise to its clients in Europe. The company delivers a full range of PostgreSQL services: Training, Development, Performance Tuning, High Availibilty setup, Oracle to PostgreSQL migration, Troubleshooting, and PostgreSQL support.

Categories: Database, Open Source

4 experimental Bluemix services you'll want to try

IBM - DB2 and Informix Articles - Sun, 04/19/2015 - 05:00
Check out the latest almost-ready-for-prime-time boilerplates and services on IBM Bluemix, including selections from integration testing, data management, content management, application quality, and application infrastructure.
Categories: Database

SQL Server 2014 Service Pack 1 Update

On Wednesday, April 15, Microsoft launched SQL Server 2014 Service Pack 1 (SP1).  Shortly after release we discovered an installation issue.  As a result, we have put the Service Pack downloads on hold.

SQL Server 2014 (SP1) will be re-released in the next few weeks. In the meantime, we recommend that you continue using SQL Server 2014 and its Cumulative Updates.

If you have encountered an issue during installation of the Service Pack, this article on the Release Services Blog will provide workaround steps.

Categories: Database

Community Spotlight: Luan Moreno Medeiros Maciel, The Pythian Group

In honor of the upcoming PASS Business Analytics conference, we wanted to take some time to spotlight the great work happening in the SQL and BI communities across the world. The conference is focused on business analytics, but PASS offers many great community activities for SQL Server and beyond. Learn about the various local and digital opportunities to connect with the PASS community here.

Name: Luan Moreno Medeiros Maciel

Role: SQL Server Database Consultant at The Pythian Group

Location: Brazil

 

What is an exciting project that you’re working on right now?

I have a few interesting projects going on right now…

Hybrid Cloud on SQL Server: This projects consists in a cloud between Amazon and the local DataCenter of the client. I’m designing this solution utilizing Database Mirroring on SQL Server 2012. After the implementation the client will be able to have a High Available solution between two sites.

In-Memory OLTP a.k.a “Hekaton” Feature Implementation: Implementing tables In-Memory for a medium company. The idea is to provide a big table In-Memory that will absorb all the requests and then, at a specific time of the day, flush the data to disk-based tables.

Partitioning in SQL Server 2012: Partitioning a big table to provide better maintenance and velocity in the data request. The data will be split by month.

Creating DW (Data Warehouse) – Educational Company: Creating the complete Data Warehouse process for a client who needs to analyze data to be used with end visualization tools in Excel (PowerView, PowerMap and PowerPivot).

 

What are your current analytics and/or database challenges, and how are you solving them?

I have a few challenges I am currently navigating. The first is determining the proper tables to be used in an In-Memory implementation. To help choose the correct tables to put In-Memory, I am using the Data Collector to analyze the client workload and generate insights. The second is creating the right Table Partitioning to improve one of my clients’ weekly maintenance. To do this I am analyzing the client server/database/maintenance to check what options are available and to determine the specific timeframe to apply the changes. I am also consulting some DMV’s and the MSDB database to check the jobs in this instance.

 

How does data help you do your job better?

Data is the center of my globe; I need to analyze, maintain, sustain, and provide insights and solutions to my clients. All of this can happen because of data.

 

What types of data-related challenges do you frequently see with customers, and how are you solving them?

Working with customers requires you to understand the customer environment, check what you have available to accomplish the work required, and then provide the best solution possible.

 

What’s your favorite example of how data has provided an insight, a decision, or a shift in how business gets done?

One of my clients had several problems related to data analysis. Because their data was not organized in the correct manner in their database, the client couldn’t provide solutions to front-end users. To solve the problem my team created a Data Quality Services structure with the client, organizing the data so that the data insights of the OLTP system could be recognized. As a result of these improvements, the client started to provide his own insights with the new, reinvented data.

 

What or who do you read, watch, or follow to help grow your data skills? (book, blog, Twitter handle, podcast, online course…anything!)

 

What’s your favorite SQL command and/or Excel function and why?

ALTER DATABASE imoltp
ADD FILEGROUP imoltp_mod CONTAINS MEMORY_OPTIMIZED_DATA

 

This command gives me the certainty that I will work with the In-Memory OLTP (a.k.a “Hekaton”).

 

Thanks for joining us, Luan!

Know someone doing cool work with data? Nominate them for a spotlight in the comments.

Categories: Database

Disaster Recovery and Big Data

Database Journal News - Thu, 04/16/2015 - 08:01

Big data applications are not usually considered mission-critical: while they support sales and marketing decisions, they do not significantly affect core operations such as customer accounts, orders, inventory, and shipping. Why, then, are major IT organizations moving quickly to incorporating big data in their disaster recovery plans?

Categories: Database

Implement a data growth solution using InfoSphere Optim 11.3

IBM - DB2 and Informix Articles - Thu, 04/16/2015 - 05:00
Readers for the first time can explore the new data growth architecture and self-service features of InfoSphere Optim 11.3 for all their enterprise-wide data growth and application retirement needs. We will showcase a step-by-step approach of how to use InfoSphere Optim 11.3 to archive, browse, delete, and restore data from enterprise applications. In addition, we will provide a detailed look at how to use InfoSphere Optim's new On-Demand archiving capabilities using Optim Designer and Manager.
Categories: Database

SQL Server 2014 Service Pack 1 is now available

The SQL Server 2014 SP1 package download is temporarily unavailable.  Please read this post for more information.

 

One year ago, Satya Nadella spoke in San Francisco to launch SQL Server 2014.  Today, we are pleased to announce the release of SQL Server 2014 Service Pack 1 (SP1). The Service Pack is available for download on the Microsoft Download Center. As part of our continued commitment to software excellence for our customers, this upgrade is available to all customers with existing SQL Server 2014 deployments.

SQL Server 2014 SP1 contains fixes to issues that have been reported through our customer feedback platforms and Hotfix solutions provided in SQL Server 2014 CU 1 up to and including CU 5, as well as a rollup of fixes previously shipped in SQL Server 2012 SP2. 

A few of the customer-requested updates in Microsoft SQL Server 2014 SP1 are:

  • Column store performance is improved when batch mode operators spill over to disk. A new XEvent provides insights into column store inserts.
  • Several issues in buffer pool extension SSD configuration are addressed, including the ability to do instant initialization of the buffer pool extension file.
  • Certain queries compile faster when using new cardinality estimator, and other cardinality estimation query plans are more efficient when using TF-4199. 
  • The scalability benefits of two trace flags (TF-1236, TF-9024) are applied automatically.
  • Backup header information retrieval works better with encrypted backups.

Customers like Samsung Electro-Mechanics are already seeing the benefits of upgrading to SQL Server 2014. Samsung improved OLTP performance up to 24 times and DW up to 22 times when they upgraded to SQL Server 2014.  SBI Liquidity Market sped up their transaction performance by tenfold when they adopted SQL Server 2014 in-memory OLTP.

For information about upgrading to SQL Server 2014, see the tools and resources available at www.microsoft.com/sqlserverupgrade.  To trial SQL Server 2014, visit the SQL Server 2014 Evaluation Center.

For more highlights of the release, please read the Knowledge Base Article for Microsoft SQL Server 2014 SP1.  To obtain SQL Server 2014 SP1 with its improved supportability, please visit the links below. SQL Server 2014 with SP1 will be available in additional venues including the Volume Licensing center and via Microsoft Update starting May 1, 2015.

Categories: Database

IHI Streamlines Aircraft Engine Maintenance with Oracle Maintenance, Repair, and Overhaul Solution

Oracle Database News - Tue, 04/14/2015 - 16:00
Press Release IHI Streamlines Aircraft Engine Maintenance with Oracle Maintenance, Repair, and Overhaul Solution Leading machinery manufacturer and maintenance service provider and TIS win the 2014 Travel and Transportation Industry Excellence Award for innovative MRO business transformation

Redwood Shores, Calif.——Apr 14, 2015

One of the world’s leading heavy-industry conglomerates, IHI Corporation, undertakes infrastructure projects around the globe leveraging cutting-edge technology. One of their primary enterprises is Aero-Engine and Space Operations which provides engine maintenance services for both defense and civil aircraft. The company is headquartered in Tokyo, Japan and has revenues of US$12.67 billion (fiscal 2013).

To help streamline its planning and execution of maintenance processes, IHI has been working with Oracle and leading IT solutions provider and platinum level member of the Oracle Partner Network (OPN), TIS, to implement the Oracle Complex Maintenance, Repair, and Overhaul solution. IHI expects an improvement in its operations including a reduction in turnaround times for jet engine maintenance as well as improvements in its ability to meet growth targets for this line of business.

“IHI has strived to be a leader in jet engine maintenance through its comprehensive service portfolio and operational excellence,” said Masa Yamashita, Director, Maintenance Division, Aero-Engine and Space Operations, IHI. “We are confident that close collaboration with Oracle and the deployment of Oracle Complex Maintenance, Repair, and Overhaul will enable us to bring enhanced, industry-leading engine maintenance planning and execution capabilities to serve our customers.”

The company participates in collaborative international projects for aero-engines such as the V2500, CF34, GE90, GEnx, PW1100G-JM, and GE9X. With cutting-edge technology and knowledge acquired through its development process, IHI also provides maintenance services for V2500 and CF34 engines, delivering comprehensive support to its worldwide customers.

The deployment of Oracle Complex Maintenance, Repair, and Overhaul provided IHI with the state-of-the-art MRO platform the group wanted for jet engine maintenance, as well as support for configuration management, maintenance process planning, and execution.

“IHI has strengthened its leadership in the jet engine maintenance industry by leveraging Oracle Complex Maintenance, Repair, and Overhaul to dramatically improve planning and execution for its key customers,” said Hiroshige Sugihara, Representative Executive Officer, President and Chief Executive Officer, Oracle Japan. “We are committed to continuing our close collaboration and look forward to supporting their future projects.”

To recognize the company’s industry-leading capabilities in engine manufacturing and MRO services, Oracle presented IHI with the 2014 Travel and Transportation Industry Excellence Award for successful transformation and leadership in the travel and transportation industry.

Oracle also recognized leading IT provider TIS with the 2014 Travel and Transportation Industry Excellence Award for its successful design, configuration, and deployment of Oracle Complex Maintenance, Repair, and Overhaul at IHI. TIS worked closely with Oracle Development, Oracle Global Industry Solutions Group, and Oracle Consulting to implement the solution.

“With Oracle Complex, Maintenance, Repair, and Overhaul, IHI will have the scalable, configurable enterprise MRO platform it needs to grow its aero-engine maintenance business,” said Hiroyuki Kodake, Executive Officer, TIS. “We value our partnership with Oracle and are honored to receive the Travel and Transportation Industry Excellence Award for 2014.”

“Oracle worked closely with IHI and TIS to deliver the key capabilities needed for its maintenance transformation. Oracle greatly values its partnerships with IHI and TIS and is delighted to recognize them with the Travel and Transportation Industry Excellence Award for 2014,” said Vijay Anand, Senior Director & Global Lead, Oracle Travel, Transportation, and Logistics.

    Contact Info Valerie Beaudett
Oracle
+1.650.400.7833
valerie.beaudett@oracle.com Mary Tobin
O’Keeffe & Company
+1.503.658.7396
mtobin@okco.com About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit http://www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Get Started Oracle Complex Maintenance, Repair, and Overhaul Talk to a Press Contact

Valerie Beaudett

  • +1.650.400.7833

Mary Tobin

  • +1.503.658.7396

Follow Oracle Corporate

Categories: Database, Vendor

Ministry of Health Brazil Deploys Oracle Healthcare Master Person Index to Improve Health Data Interoperability

Oracle Database News - Tue, 04/14/2015 - 13:00
Ministry of Health Brazil Deploys Oracle Healthcare Master Person Index to Improve Health Data InteroperabilityOracle solution running on Oracle engineered systems helps to improve quality care for more than 200 million residents in Brazil

REDWOOD SHORES, CA—April 14, 2015—The Ministry of Health Brazil deployed Oracle Healthcare Master Person Index running on Oracle engineered systems to advance nationwide e-health initiatives designed to improve care quality while reducing costs. This is the largest enterprise master person index (EMPI) implementation in the world, covering Brazil’s entire population of more than 200 million.

In order to create a national electronic health record system and health information exchanges that serve every resident, the Ministry of Health Brazil must first ensure health data interoperability. As a foundation, it has created a highly scalable, reliable, and standards-based EMPI using Oracle Healthcare Master Person Index running on Oracle Exadata Database Machine and Oracle Exalogic Elastic Cloud.

Oracle Healthcare Master Person Index enables the Ministry of Health to accurately and rapidly match, deduplicate, link, and search personal records to support accurate decision-making at the point of care. Brazilian names present significant challenges when managing this process as they often comprise more than three components and there isn’t a uniform method for using a last name. To streamline this effort, the Ministry of Health’s EMPI relies on Oracle Healthcare Master Person Index to provide sophisticated filtering and matching functionality and the ability to interoperate using industry standards.

The standards-based Oracle solution also helps reduce the cost of ownership and speeds time to value by supporting Integrating the Healthcare Enterprise (IHE) profiles and accommodating disparate IT systems within and outside of the Ministry of Health’s data infrastructure—without complicated and costly custom integrations.

“Oracle Healthcare Master Person Index has enabled us to create the robust and scalable foundation needed to gather accurate data and effectively deduplicate national healthcare card numbers,” said Moacyr Esteves Perche, director of DataSUS, Ministry of Health Brazil. “The solution is especially well suited to our massive scale and unique and complex master person index requirements. Oracle Healthcare Master Person Index has shown tangible results by identifying existing records and preventing issuance of more than half a million duplicate Cartão Nacional de Saúde healthcare cards in the first month of operation.”

Oracle Engineered Systems deliver the performance and scalability required to support Brazil’s nationwide EMPI. The persistence layer in Oracle Exadata Database Machine enables extensive performance benefits to effectively support a high volume of data and transactions, including data from 3.7 billion ambulatory procedures and 11 million medical admissions annually. Oracle Exalogic Elastic Cloud delivers strength and responsiveness in real-time processing and enables the environment to scale to support millions of patients and new features and functionality as e-health initiatives advance.

“Oracle is pleased to help the Ministry of Health Brazil advance its mission to provide quality and cost-effective universal healthcare to the entire population by achieving standards-based health data interoperability,” said Steve Rosenberg, senior vice president and general manager, Oracle Health Sciences. “Oracle Healthcare Master Person Index is an essential building block for building Brazil’s national electronic health record system that will help improve care quality and health outcomes, as well as reduce operational costs.”

For this implementation, Oracle joined forces with CDS (CDS/NTC), a Platinum level member of Oracle PartnerNetwork (OPN), with knowledge of Oracle Healthcare Master Person Index, Oracle engineered systems, and other Oracle solutions. CDS conducted an initial bulk match-and-load process at the start of the implementation, deduplicating more than 320 million records and demonstrating the solution’s power and scalability.

Additional Information

Join the Oracle Health Sciences community on Facebook and follow @OracleHealthSci on Twitter.

About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Contact Info

Samantha Thai
Oracle
+1.510.917.5564
samantha.thai@oracle.com

Mary Tobin
O’Keeffe & Company
+1.503.658.7396
mtobin@okco.com

Categories: Database, Vendor

Lids Sports Group Opens up Inventory across Channels with Oracle Retail Solutions

Oracle Database News - Tue, 04/14/2015 - 13:00
Press Release Lids Sports Group Opens up Inventory across Channels with Oracle Retail Solutions Specialty retailer uses Oracle to help increase available inventory while helping customers and associates easily find items online and at over 1,300 locations nationwide

Redwood Shores, Calif.—Apr 14, 2015

With more than 1,300 North American stores and a thriving e-commerce business, specialty retailer Lids Sports Group has a growing customer base that values both its in-store and online shopping experience. With the help of Oracle solutions, Lids expects to boost sales and increase consumer loyalty by making its entire inventory of team-specific sports apparel and memorabilia available in-store, online, or via a mobile device.     As part of a technology upgrade that includes a migration to Oracle’s MICROS Xstore (now Oracle Retail Xstore), Lids rolled out Oracle’s MICROS Retail Locate (now Oracle Retail Order Broker Cloud Service), enabling the retailer to nearly double the number of product SKUs available for sale online by exposing inventory in all Lids stores as well as throughout its supply chain.   The deployment provides associates and customers with real-time, chainwide inventory information whether products are sitting in a warehouse, an e-commerce distribution center, or on a store shelf hundreds of miles away. Employees can easily find available items and then ship them to customers’ homes or businesses, or to any store in the chain.   In addition to dramatically expanding available SKUs, the new solution replaces end-of-day inventory tracking with real-time insight Now, whether a customer buys an item in the store or online, the solution updates Lids’ store, e-commerce, ERP, and warehouse management systems, so that inventory levels are never in doubt.   Lids executives expect that this greater inventory availability and insight will increase sales and improve both sell-through and margins. The retailer projects that its new “endless aisle” functionality will also boost its liquidation metrics by showcasing discontinued or hard-to-find items that have been shipped to stores but not yet sold.   “Oracle Retail solutions have made a dramatic difference in how we do business, both with regard to our internal systems and in relating to customers,” said Larry Havlik, vice president, IT and Systems, Lids Sports Group. “This is a significant step toward driving growth, by expanding the items we offer and giving customers the full benefit of our locations, in-store service, and e-commerce site.”   In addition, the upgrade to the new point-of-service (POS) solution will simplify administration and the user experience for the more than 50 different POS screen and receipt configurations for Lids Sports Group’s partner brands. These include major college and pro teams as well as the nearly 200 Locker Room-branded stores in Macy’s locations.   “Lids is vastly expanding what it offers shoppers while also ensuring ease of access and better sell-through,” said Jill Puleri, senior vice president and general manager, Oracle Retail. “By using Oracle Retail solutions, Lids is taking advantage of integrated channel and inventory management systems, backed by our ongoing investment in product development and world-class support.”   Contact Info Greg Lunsford
Oracle
+1.650.506.6523
greg.lunsford@oracle.com Mary Ellen Amodeo
Amodeo Associates
+1.612.963.5797
meamodeo@gmail.com About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit http://www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Learn More Subscribe to the Oracle Retail Community Talk to a Press Contact

Greg Lunsford

  • +1.650.506.6523

Mary Ellen Amodeo

  • +1.612.963.5797

Follow

Follow Oracle Corporate

Categories: Database, Vendor

Optimize data storage for cloud

IBM - DB2 and Informix Articles - Tue, 04/14/2015 - 05:00
Data storage is no longer a warehousing issue; implicit in the new world of data everywhere is the implied ability to find, access, and use that data in an efficient manner. Much of that data exists on a cloud, so you need to know how to make sure data storage is optimized and doesn't become a weak link in your cloud platform. Storage techniques and software tools can help you achieve data and database optimization, and help to manage virtualized data storage through the software layer. This article explores what storage optimization tools can do for you.
Categories: Database

Still running SQL Server 2005? Now is the time to upgrade

Can you believe it’s been 10 great years since SQL Server 2005 was released? Extended support for this offering will end on April 12, 2016. Before support ends, you’ll need a plan for migrating remaining instances of SQL Server 2005. But, why wait to migrate when you have an opportunity to provide new value to your business now with a modern data platform? Many customers are already experiencing the benefits of upgrading to SQL Server 2014. GE Healthcare, for example, wanted a more flexible, scalable platform to deliver applications to healthcare providers worldwide. They met this goal using a cross-platform cloud strategy with SQL Server 2014 and Microsoft Azure. With SQL Server on Azure VMs, GE Healthcare can accelerate time-to-market, cuts costs and enable compliance for more customers.

If you’re hesitant to make this move, it is important that you know what end of support means for your business. After the end of support date, hotfixes and security updates will no longer be provided. The costs to maintain security and support as well as the potential liabilities associated with compliance audits can make it more expensive to stay on the old version than to upgrade. Now is the time to take advantage of new technology to support your business with SQL Server 2014, SQL Server 2014 in a VM (on-premises or in Azure), and/or Azure SQL Database.

Read more about SQL Server 2005 end of support on the Official Microsoft Blog and start planning your upgrade today. 

Categories: Database

More Than Oracle Knows What To Do With

Database Journal News - Mon, 04/13/2015 - 08:01

In Oracle 12c an interesting problem arises with ANSI joins, star expansion and tables with 500 columns or more.  Read on to find out what happens and how you can work around the problem.

Categories: Database