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

Data structures with Couchbase and .NET (video)

NorthScale Blog - Mon, 03/27/2017 - 19:47

In February, I wrote a blog about using data structures with .NET (and .NET Core): List, Queue, and Dictionary.

Now, I’ve created a video to show the same concepts in action.

How to use Couchbase Data Structures with .NET

The source code used in this video is available on GitHub. Note that the source code uses .NET Core, but this should work just the same in .NET.

Thanks for watching!

If you have any questions about Couchbase and .NET, please ask away in the Couchbase .NET Forums. Also check out the Couchbase Developer Portal for more information on the .NET SDK and Couchbase in general.

You can also contact me at Twitter @mgroves.

The post Data structures with Couchbase and .NET (video) appeared first on The Couchbase Blog.

Categories: Architecture, Database

Performance Enhancements to N1QL in the Couchbase 5.0 March Developer Build

NorthScale Blog - Mon, 03/27/2017 - 18:20

N1QL in Couchbase has come a long way since it was first introduced in Couchbase Server 4.0.  In Couchbase 5.0, things are taken to the next level in terms of performance.  In terms of the March 2017 Developer build of Couchbase 5.0, there are performance enhancements to N1QL in the flavor of index projection, enhancements to COUNT and DISTINCT, and the much requested ORDER BY, LIMIT, and OFFSET operators.

So what in specific was done to enhance all of these areas and how can we make use of the changes?

Let’s take index projection for example. ¬†When creating an index, you can create one with any number of properties. ¬†For example, take the following index:

CREATE INDEX idx ON default(type, firstname, lastname);

The above statement will create a covering index on the default Bucket for the type, firstname, and lastname properties of any given document.

Now let’s say we created the following N1QL query to retrieve a few documents with the¬†idx index we had created:

SELECT firstname
FROM default
WHERE type = 'person'

The above query would use the¬†idx index and return only the¬†firstname¬†property for every document that matches. ¬†The concept of querying this way is nothing new, however, what happens¬†behind the scenes has changed. ¬†You’ll notice that even though¬†our index has many keys, we’re only interested in a subset, or in this case two¬†keys.

So what is happening and why is this important?

In previous versions of Couchbase all keys of the index were taken into consideration regardless if only a subset were used.  As a result, more network, CPU, and memory were needed to accommodate what was happening.  Now this is not the case.

So how do you know index projection is happening?

Do an¬†EXPLAIN on the query that you’re running:

EXPLAIN SELECT firstname
FROM default
WHERE type = 'person'

In the results you should see something regarding index_projection that looks like the following:

...
"index_projection": {
    "entry_keys": [
        0,
        1
    ]
},
...

The entry_keys property will change based on your query.  For example, what if we add one WHERE condition like so?:

SELECT firstname
FROM default
WHERE type = 'person' AND lastname = 'Nic'

In the above scenario, we would get an EXPLAIN result that looks like the following:

...
"index_projection": {
    "entry_keys": [
        0,
        1,
        2
    ]
},
...

Now the above query wasn’t an index projection because we used all keys in our covering index.

Creating proper indexes paired with index projection can really help in overall performance and scaling your Couchbase Server cluster.

Index projection wasn’t the only performance enhancement made in the March 2017 build right? ¬†That is correct, there is more!

Let’s take the¬†COUNT(DISTINCT) operation for example. ¬†Now let’s use that operation in the following query:

EXPLAIN SELECT COUNT(DISTINCT type)
FROM default;

In the results you’ll notice that it is using¬†IndexCountDistinctScan2 and what it is doing is storing all¬†type in the index and processing the distinct values. ¬†While it happens in the indexer in Couchbase 5.0, it previously happened in the N1QL service in prior editions. ¬†By offloading¬†this operation in the indexer, we can experience significant performance gains.

Similarly, take the OFFSET, LIMIT, and ORDER BY operators that can be used in N1QL queries.  Take the following query for example:

EXPLAIN SELECT firstname
FROM default
WHERE type = 'person'
ORDER BY firstname
LIMIT 1
OFFSET 1;

You’ll notice that the¬†LIMIT, ORDER BY,¬†and¬†OFFSET operators will appear in the indexer. ¬†Prior to 5.0, the LIMIT operator appeared in the indexer, but now the others do as well. ¬†This is a huge win because in previous versions of Couchbase if you were to offset the results, N1QL would get all X number of results, and drop everything before the offset.

For more help with N1QL, check out the Couchbase Developer Portal which contains a ton of useful developer documentation.

The post Performance Enhancements to N1QL in the Couchbase 5.0 March Developer Build appeared first on The Couchbase Blog.

Categories: Architecture, Database

Get to know our Couchbase Community Meet ‚Äď Shivansh Srivastava

NorthScale Blog - Mon, 03/27/2017 - 10:23

In our latest interview for Get to Know Our Couchbase Community Champions, we meet Shivansh Srivastava from Delhi, India.

ShivanshSrivastava 181x300 1

Tell us about yourself and what you do in your daily role?

I consider myself to be a polyglot developer and a Scala, Spark, and Couchbase aficionado. I like to contribute to Open Source projects, and have contributed to projects like Apache iota, Apache Spark, Apache CarbonData, Couchbase-Spark-Connector, Akka, Alpakka, and many others. I’ve a keen interest in upcoming technologies like IoT, deep learning, etc. Currently, I’m employed as a Sr. Software Engineer at Chirpanywhere Inc, an IoT-based startup, where my main work is to manage many things from programming to designing the whole solution and deploying it. I’m also interested in building communities and am currently building my own community, Internity, to revolutionize the learning in colleges in India.

Where are you based and what do you like to do in your spare time?
I am currently based in Delhi, India. In my spare time I like to contribute to community building and help out others so they do not get stuck on the same problems I have experienced. Hence, I like to respond on Stackoverflow, write blogs, and learn from online courses (i.e., Coursera and edX, etc.). I also want to build a community offline, which is why I started the Internity initiative.

What made you choose Couchbase?
We’ve explored many options, but we chose Couchbase because of some pretty cool features like user-friendly UI, hence the cost of database management was reduced. It was in-memory, therefore, the reads were quite fast, and it has Couchbase Full Text Search (CBFT), which provides all the benefits of using a single database.

What one feature of Couchbase do you use and what should people know about it?

One feature is getting nearly ACID properties in a NoSQL database. Using the approach stated in Pro Couchbase Server by David Ostrovsky, Yaniv Rodenski, and Mohammed Haji, we formulated our solution and we were able to get nearly ACID properties in Couchbase. This book is a must-read.

What have you accomplished using Couchbase?

Earlier, I worked with a company related to the stock market and the data was semi-structured. With Couchbase, we were able to apply real-time N1QL queries to the data and integrate with Spark using the Spark-Couchbase Connector. And using Couchbase-Elastic river plugin to transfer data directly to ElasticSearch using the Couchbase UI is very user-friendly. There were many things we did not need to write code for that was managed by Couchbase itself, and the Couchbase UI has been very helpful in monitoring it as well.

If you could have three wishes for Couchbase what would they be?

My three wishes would be:

1. Increase the writing speed of the data which can be achieved in the near future.

2. Develop some compression algorithm like Pied Piper in Silicon Valley and inculcate into Couchbase to deal with the data volume.

3. To keep on increasing the open source activities to promote open source culture in other companies too.

What is your favorite book or author, and why?

My favourite book is Artificial Intelligence: A Modern Approach by Peter Norvig and Stuart J. Russell because of the ease with which they have explained such difficult topics. I also love to read biographies and autobiographies and am currently reading Playing It My Way, by Boria Majumdar and Sachin Tendulkar.

The post Get to know our Couchbase Community Meet – Shivansh Srivastava appeared first on The Couchbase Blog.

Categories: Architecture, Database

Setting A Logon Security Message In Oracle

Database Journal News - Mon, 03/27/2017 - 08:01

Many enterprises are requiring user notification of session monitoring at login, at both the server and database level. Read on to see how to enable this feature and provide custom text.

Categories: Database

ANN: Couchbase Lite Developer Build 003 (Obj C, Swift, .NET)

NorthScale Blog - Fri, 03/24/2017 - 19:57

I am very pleased that Couchbase Lite Developer Build 003 is now available for download for Objective C, Swift and ‚Äú.NET‚ÄĚ.

Database queries have changed significantly in this release. Couchbase Lite 2.0 uses semantics based on N1QL query language defined by Couchbase. This API will be familiar If you’ve used Core Data, or other query APIs based on SQL (like jOOQ).

The Query API will have two styles – builder and fluent, and the implementation chosen would depend on the development platform.

Objective C

For Objective-C, we’ve implemented a builder API.

The SQL Statement

‚ÄėSELECT * FROM type=’account’ AND owner=’John’ ORDER BY dealSize‚Äô

can be written with the builder API as follows:

CBLQuery *query =

[CBLQuery select: [CBLQuerySelect all]

            from: [CBLQueryDataSource database: database]

¬†¬†¬†¬†¬† ¬†¬†¬†¬†where: [[CBLQueryExpression property: @”type”] equalTo: @”account”] and:

¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬† [CBLQueryExpression property: @”owner”] equalTo: @”Wayne”]]

¬†¬†¬†¬†¬†¬†¬†¬† orderBy: [CBLQueryOrderBy expression: [CBLQueryExpression property: @”dealSize”]]

];

The API Specification for Objective C is available here and the release notes are here.

Swift

We’ve implemented a fluent API with support for the following

  • CRUD operations
  • Document with property type accessors
  • Subdocument API
  • Blob data type
  • CouchbaseLiteSwift framework for the Swift API
  • Database and Document Change Notification

The API Specification for Swift is available here and the release notes are here.

.NET

The major changes in .NET are as follows –

  • We‚Äôve added the sub document API which allows you to access embedded JSON objects. This is a much cleaner and safer approach with type safe accessors and the thread safety rules.
  • Thread safety checking is optional now. When used, it will be rigorously enforced and fail quickly to indicate incorrect usage.
  • Plus, you get everything that was available in DB002 which is listed here. The key highlights being:
    • A new and simplified API to interact with Couchbase Lite. CRUD operations are available and each subsequent build will have API expansion and changes. More details are available here.
    • Blob data type support.
    • Database and Document Change Notifications.

We are working hard on creating samples for you but in the meanwhile you can check out the unit tests here to get started.

The API specification is available here and the release notes are available here.

The post ANN: Couchbase Lite Developer Build 003 (Obj C, Swift, .NET) appeared first on The Couchbase Blog.

Categories: Architecture, Database

Working with Arrays in Couchbase with N1QL ‚Äď Video Tutorial

NorthScale Blog - Fri, 03/24/2017 - 17:00

In a recent article, I wrote about flattening and querying arrays in Couchbase using N1QL. ¬†That article was inspired by a popular question in the Couchbase Forums. ¬†After publishing the article, I felt a write-up alone couldn’t do it justice so I decided to create a video tutorial that walked through a bunch of queries on array data.

The video can be seen below:

I encourage you to read the write-up as well as it will help you when learning about N1QL and the cool things you can do with it.

For more information on using N1QL or Couchbase in general, check out the Couchbase Developer Portal.

The post Working with Arrays in Couchbase with N1QL – Video Tutorial appeared first on The Couchbase Blog.

Categories: Architecture, Database

Codenvy, Eclipse Che, Docker, and Couchbase: Coding in the Cloud at Devoxx US

NorthScale Blog - Thu, 03/23/2017 - 23:07

This week Couchbase was at Devoxx US.  Devoxx is a hugely influential conference series, well known in Europe.  This was the first one to take place in the United States.

While I was there I had a chance to talk with a group from Codenvy.  Codenvy allows you to quickly set up development stacks based on Docker containers.  They have several standard environments.  You can add to the existing ones or roll your own by adding Docker images.

Codenvy hosts everything in the cloud, so you can collaborate directly with other developers.  This means you can have applications that run against full-featured backend systems available at the click of a button.

I’m interested in using Codenvy for blogging. ¬†I like the idea of building a sample and having a link to code a reader can try out directly. ¬†So, I sat down during a break in the conference and knocked out a simple Couchbase Lite Java app. ¬†Codenvy has adopted Eclipse Che, which gives you a full featured editor that runs in your browser. ¬†(You can use any IDE and sync, too, if you don’t want to use Che.) ¬†I built the app using Che. ¬†The whole process was pretty easy. ¬†I’m looking forward to trying this out further, ideally with a complete Couchbase Mobile stack setup, including Couchbase Server running in its own container.

The app has no UI. ¬†It just shows how to open a database and perform simple CRUD operations. ¬†I used a helper class I find convenient that also wraps Couchbase replication, although I didn’t use that aspect.

I’ve barely scratched the surface on the features Codenvy offers. ¬†For now, click on the badge below and try it out with the sample I wrote.

Postscript

You can find more resources on our developer portal and follow us on Twitter @CouchbaseDev.

You can post questions on our forums. And we actively participate on Stack Overflow.

Hit me up on Twitter with any questions, comments, topics you’d like to see, etc. @HodGreeley

 

The post Codenvy, Eclipse Che, Docker, and Couchbase: Coding in the Cloud at Devoxx US appeared first on The Couchbase Blog.

Categories: Architecture, Database

FakeIt Series 3 of 5: Lean Models through Definitions

NorthScale Blog - Thu, 03/23/2017 - 20:05

Aaron Benton is an experienced architect who specializes in creative solutions to develop innovative mobile applications. He has over 10 years experience in full stack development, including ColdFusion, SQL, NoSQL, JavaScript, HTML, and CSS. Aaron is currently an Applications Architect for Shop.com in Greensboro, North Carolina and is a Couchbase Community Champion.

Aaron Benton

FakeIt Series 3 of 5: Lean Models through Definitions

In our previous post FakeIt Series 2 of 5: Shared Data and Dependencies we saw how to create multi-model dependencies with FakeIt. Today we are going to look at how we can create the same, but smaller models by leveraging definitions.

Definitions are a way of creating reusable set(s) within your model. It allows you to define a set of properties / values one time, referencing them multiple times throughout your model. Definitions in a FakeIt model are very similar to how definitions are used in the Swagger / Open API Specification.

Users Model

We will start with our users.yaml model that we defined in our first post.

name: Users
type: object
key: _id
properties:
  _id:
    type: string
    description: The document id built by the prefix "user_" and the users id
    data:
      post_build: `user_${this.user_id}`
  doc_type:
    type: string
    description: The document type
    data:
      value: user
  user_id:
    type: integer
    description: An auto-incrementing number
    data:
      build: document_index
  first_name:
    type: string
    description: The users first name
    data:
      build: faker.name.firstName()
  last_name:
    type: string
    description: The users last name
    data:
      build: faker.name.lastName()
  username:
    type: string
    description: The username
    data:
      build: faker.internet.userName()
  password:
    type: string
    description: The users password
    data:
      build: faker.internet.password()
  email_address:
    type: string
    description: The users email address
    data:
      build: faker.internet.email()
  created_on:
    type: integer
    description: An epoch time of when the user was created
    data:
      build: new Date(faker.date.past()).getTime()

Lets say that we have a new requirement where we have to support a home and work address for each user. Based on this requirement, we have decided to create a top-level property named addresses that will contain nested properties of home and work.

{
   ...
   "addresses": {
       "home": {
           "address_1": "123 Broadway St",
           "address_2": "Apt. C",
           "locality": "Greensboro",
           "region": "NC",
           "postal_code": "27409",
           "country": "US"
       },
       "work": {
           "address_1": "321 Morningside Ave",
           "address_2": "",
           "locality": "Greensboro",
           "region": "NC",
           "postal_code": "27409",
           "country": "US"
       }
   }
}

Our users.yaml model will need to be updated to support these new address properties.

(For brevity the other properties have been left off of the model definition)

...
properties:
 ...
  addresses:
    type: object
    description: An object containing the home and work addresses for the user
    properties:
      home:
        type: object
        description: The users home address
        properties:
          address_1:
            type: string
            description: The address 1
            data:
              build: `${faker.address.streetAddress()} ${faker.address.streetSuffix()}`
          address_2:
            type: string
            description: The address 2
            data:
              build: chance.bool({ likelihood: 35 }) ? faker.address.secondaryAddress() : null
          locality:
            type: string
            description: The city / locality
            data:
              build: faker.address.city()
          region:
            type: string
            description: The region / state / province
            data:
              build: faker.address.stateAbbr()
          postal_code:
            type: string
            description: The zip code / postal code
            data:
              build: faker.address.zipCode()
          country:
            type: string
            description: The country code
            data:
              build: faker.address.countryCode()
      work:
        type: object
        description: The users home address
        properties:
          address_1:
            type: string
            description: The address 1
            data:
              build: `${faker.address.streetAddress()} ${faker.address.streetSuffix()}`
          address_2:
            type: string
            description: The address 2
            data:
              build: chance.bool({ likelihood: 35 }) ? faker.address.secondaryAddress() : null
          locality:
            type: string
            description: The city / locality
            data:
              build: faker.address.city()
          region:
            type: string
            description: The region / state / province
            data:
              build: faker.address.stateAbbr()
          postal_code:
            type: string
            description: The zip code / postal code
            data:
              build: faker.address.zipCode()
          country:
            type: string
            description: The country code
            data:
              build: faker.address.countryCode()

As you can see our home and work address properties contain the exact same nested properties. This duplication makes our model bigger and more verbose. Additionally, what happens if our address requirements need to change? We’d have to make two updates to keep the structure the same. This is where we can take advantage of definitions, by defining a single way to create an address and reference it.

(For brevity the other properties have been left off of the model definition)

...
properties:
 ...
  addresses:
    type: object
    description: An object containing the home and work addresses for the user
    properties:
      home:
        description: The users home address
        schema:
         $ref: '#/definitions/Address'
      work:
        description: The users work address
        schema:
         $ref: '#/definitions/Address'
definitions:
  Address:
    type: object
    properties:
      address_1:
        type: string
        description: The address 1
        data:
          build: `${faker.address.streetAddress()} ${faker.address.streetSuffix()}`
      address_2:
        type: string
        description: The address 2
        data:
          build: chance.bool({ likelihood: 35 }) ? faker.address.secondaryAddress() : null
      locality:
        type: string
        description: The city / locality
        data:
          build: faker.address.city()
      region:
        type: string
        description: The region / state / province
        data:
          build: faker.address.stateAbbr()
      postal_code:
        type: string
        description: The zip code / postal code
        data:
          build: faker.address.zipCode()
      country:
        type: string
        description: The country code
        data:
          build: faker.address.countryCode()

Definitions are defined at the root of the model by specifying a definitions: property, then the name of the definition. Definitions are referenced by using $ref with the value being the path to the definition, for example #/definitions/Address. By using definitions we have saved almost 30 lines of code in our model and created a single place for how an Address is to be defined and generated within our Users model.

We can test the output of our updated Users model addresses using the following command:

fakeit console --count 1 models/users.yaml

blog3 example1

Now, lets say we have a requirement to store a Users main phone number, and then store optional additional phone numbers i.e. Home, Work, Mobile, Fax, etc. For this change we will use two new top-level properties: main_phone and additional_phones that is an array.

{
   ...
   "main_phone": {
       "phone_number": "7852322322",
       "extension": null
   },
   "additional_phones": [
       {
           "phone_number": "3368232032",
           "extension": "3233",
           "type": "Work"
       },
       {
           "phone_number": "4075922921",
           "extension": null,
           "type": "Mobile"
       }
   ]
}

While this may not be the most practical data model, or how I personally would have modeled this data we can use this example again to illustrate how we can take advantage of using definitions within our FakeIt model.

(For brevity the other properties have been left off of the model definition)

...
properties:
 ...
  main_phone:
    description: The users main phone number
    schema:
     $ref: '#/definitions/Phone'
    data:
      post_build: |
       delete this.main_phone.type
       return this.main_phone
  additional_phones:
    type: array
    description: The users additional phone numbers
    items:
     $ref: '#/definitions/Phone'
      data:
        min: 1
        max: 4
definitions:
  Phone:
    type: object
    properties:
      type:
        type: string
        description: The phone type
        data:
          build: faker.random.arrayElement([ 'Home', 'Work', 'Mobile', 'Other' ])
      phone_number:
        type: string
        description: The phone number
        data:
          build: faker.phone.phoneNumber().replace(/[^0-9]+/g, '')
      extension:
        type: string
        description: The phone extension
        data:
          build: chance.bool({ likelihood: 30 }) ? chance.integer({ min: 1000, max: 9999 }) : null

For this example we have created a Phone definition that contains 3 properties: type, phone_number and extension. You will notice that we have defined a post_build function on the main_phone property that removes the type attribute. This is illustrating how definitions can be used in conjunction with a build function to manipulate what is returned by the definition. The additional_phones property is an array of Phone definitions that will generate between 1 Р4 phones. We can test the output of our updated Users model phone numbers using the following command:

fakeit console --count 1 models/users.yaml

blog3 example2

Conclusion

Definitions allow you to streamline your FakeIt models by creating reusable sets of code for smaller more efficient models.

Up Next
  • FakeIt Series 4 of 5: Working with Existing Data
  • FakeIt Series 5 of 5: Rapid Mobile Development w/ Sync-Gateway
Previous

Couchbase Champion This post is part of the Couchbase Community Writing Program

The post FakeIt Series 3 of 5: Lean Models through Definitions appeared first on The Couchbase Blog.

Categories: Architecture, Database

Five reasons to run SQL Server 2016 on Windows Server 2016 ‚ÄĒ No. 1: Security

This is the first blog in a five-part series. Keep an eye out for upcoming posts, which will cover cutting costs and improving performance of storage, BI, and analytics; improving uptime and reliability; reaching data insights faster by running analytics at the point of creation; and maintaining a consistent data environment across on-premises, hybrid, and cloud environments.

Wall, ditch, moat, palisades, watch towers, guards, highly trained soldiers: Even 2,000 years ago, when the Romans built their defenses, they deployed multiple layers of protection to deter invaders and keep intruders out. Today, on the electronic front, IT environments demand no less than a strong, layered approach to ensuring that data assets are protected from attacks such as stolen administrator credentials, unauthorized access, and pass-the-hash exploits.

You can see how important security is by examining the cost of data breaches, which is growing rapidly and represents a significant risk to business, as Figure 1 illustrates. To address this, Microsoft’s $1 billion annual investment in security demonstrates the company’s longstanding and proven commitment to building security capabilities into both its applications and operating systems. This means you can take advantage of layered security and mitigate risk.

Figure 1: Growing cost of data breach [1]

figure-1

Consider SQL Server 2016 and Windows Server 2016, for example: Security is built into both. In fact, the National Institute of Standards and Technology (NIST) has shown SQL Server to consistently be the least vulnerable database.[2] Underpinning the built-in security you get with SQL Server, Windows Server 2016 adds new OS-level security capabilities to existing security functionality. As a result, if you use both SQL Server 2016 and Windows Server 2016 together, you get enterprise-scale security that meets the strictest organizational and industry standards for your infrastructure and your data.

Figure 2: Independent findings show unparalleled security

figure-2[3]

SQL Server 2016 security

When you modernize your data platform to SQL Server 2016, you get access to innovative advanced security features of the least vulnerable database.[4] Three key built-in features that keep unauthorized users from accessing SQL Server data are:

  • Always Encrypted enables encryption inside client applications without revealing encryption keys to SQL Server. It allows changes to encrypted data without the need to decrypt it first, as shown in Figure 3. The combination of Transparent Data Encryption and Always Encrypted ensures that data is encrypted both at rest and in motion. (To learn more, see ‚ÄúAlways Encrypted in SQL Server & Azure SQL Database.‚ÄĚ)

Figure 3: Always Encrypted protection

figure-3

Figure 4: Row-Level Security

figure-4

  • Dynamic Data Masking (DDM) lets you conceal your sensitive data or personally identifiable information (PII) such as customer phone number, bank information or Social Security number. DDM and RLS help developers build applications that require restricted direct access to certain data as a means of preventing users from seeing specific information. Figure 5 illustrates. (For deeper information, see ‚ÄúUse Dynamic Data Masking to obfuscate your sensitive data.‚ÄĚ)

Figure 5: Dynamic Data Masking

figure-5

To learn more about SQL Server 2016 security, you can visit the SQL Server data security webpage and read the security white paper.

Windows Server 2016 security

Just as SQL Server 2016 provides advanced security features that are not available in other data platforms, Windows Server 2016 includes built-in breach-resistance mechanisms to establish strong security layers to help thwart attacks.

The Windows Server 2016 operating system is a strategic layer in your infrastructure and serves as the foundation for your SQL Server data security. To prevent data exposure, you need the most advanced protection you can get. By modernizing both your server platform and your data platform together, you can be assured you’re doing your best to protect your business. The security functionality in Windows Server 2016 includes the following:

  • Device Guard helps lock down what runs on the server so that you are better protected from unauthorized software running on the same server as your SQL Server application.
  • Credential Guard to protect SQL Server admin credentials from being stolen by Pass-the-Hash and Pass-the-Ticket attacks. Using an entirely new isolated Local Security Authority (LSA) process, which is not accessible to the rest of the operating system, Credential Guard‚Äôs virtualization-based security isolates credential information to prevent interception of password hashes or Kerberos tickets.
  • Control Flow Guard and Windows Defender protect against known and unknown vulnerabilities that malware can otherwise exploit. Control Flow tightly restricts what application code can be executed ‚ÄĒ especially indirect call instructions. Lightweight security checks identify the set of functions in the application that are valid targets for indirect calls. When an application runs, it verifies that these indirect call targets are valid. Windows Defender works hand-in-hand with Device Guard and Control Flow Guard to prevent malicious code of any kind from being installed on your servers.

To learn more about the advanced layers of OS security, visit the Windows Server security webpage and read the white paper.

Thanks for reading our first blog in the series. For more info, check out this summary of five reasons to run SQL Server 2016 with Windows Server 2016.

Ready to give it a try? Here are some options to get started:

Windows Server Virtual Labs

Windows Server 2016 Free Evaluation

SQL Server 2016 Free Evaluation

SQL Server Virtual Labs

[1] ‚ÄúData Breach Costs Rising, Now $4 Million per Incident‚ÄĚ

[2] National Institute of Standards and Technology Comprehensive Vulnerability Database, update 2016

[3] National Institute of Standards and Technology Comprehensive Vulnerability Database, update 2016

[4] National Institute of Standards and Technology Comprehensive Vulnerability Database, update 2016

Categories: Database

TNDP Episode #16: The MEAN Stack for Application Development

NorthScale Blog - Thu, 03/23/2017 - 15:00

I am pleased to announce that the latest episode of The NoSQL Database Podcast titled, The Mean Stack for Application Development, has been published to all the popular podcasting networks.  In this episode I have special guest Jonathan Casarrubias from mean.expert come talk about the MongoDB, Express Framework, Angular, and Node.js (MEAN) development stack.

If you’re unfamiliar with the MEAN stack, it is a wildly popular development stack amongst JavaScript developers because all components in the stack have some relationship to JavaScript, making all the technologies play nice together.

This episode can be found on all the major podcast networks including iTunes and Pocket Casts, but if you’d prefer, you can listen to it below.

http://traffic.libsyn.com/nosql/TNDP_-_Episode_16_-_The_MEAN_Stack_for_Application_Development.mp3

If you’d like to follow up with Jonathan, you can find him on Twitter or via his website. ¬†If you’d like to learn about the previous podcast episode, find it here.

To learn more about Couchbase and what it has to offer, check out the documentation in the Couchbase Developer Portal.

The post TNDP Episode #16: The MEAN Stack for Application Development appeared first on The Couchbase Blog.

Categories: Architecture, Database

Can Automated Data Integration Set Data Scientists and Developers Free?

Database Journal News - Thu, 03/23/2017 - 08:01

Data integration often splits the data science community into two factions: those who automate and those who prefer manual coding. While automated tools are still sometimes viewed with suspicion by data ‘purists’ who favor SQL or other programming or scripting languages, even the most hardened coders can benefit from automated data integration systems.

Categories: Database

Importing Structures using Staging Tables and Microsoft SQL Server

IBM - DB2 and Informix Articles - Thu, 03/23/2017 - 05:00
Importing structures into Controller using Staging Tables and Microsoft SQL Server.
Categories: Database

Oracle Hotel 2025 and Oracle Restaurant 2025 Reports Audit Consumer Attitudes on Emerging Technologies and Their Impact on Future Hospitality Experiences

Oracle Database News - Wed, 03/22/2017 - 13:08
Press Release Oracle Hotel 2025 and Oracle Restaurant 2025 Reports Audit Consumer Attitudes on Emerging Technologies and Their Impact on Future Hospitality Experiences Oracle Hospitality Research Identifies the Future of IoT, Virtual Reality and Wearables in the Guest Experience

Oracle Industry Connect, Orlando, FL.—Mar 22, 2017

Today Oracle announced the findings of two research initiatives aimed at identifying consumer attitudes to new technologies and how their implementation will shape consumer behavior in the years to come. Insights from both the Oracle Hotel 2025 and Oracle Restaurant 2025 highlight that consumers are most willing to engage brands with new technology if they feel that they are in control of their experience and that hospitality operators should be wary of implementing automation without personal service.

‚ÄúGiven the heritage of service throughout the Hospitality industry, we‚Äôre not surprised that guests want a continued human connection with their food and beverage and hotel brands of choice, despite the emergence of new technologies,‚ÄĚ said Mike Webster, senior vice president and general manager Oracle Hospitality. ‚ÄúOur hotel and restaurant management platforms OPERA and Simphony will continue to be enabling investments given their ability to provide a singular view of how guests engage and interact.‚ÄĚ

The Hotel 2025 and Restaurant 2025 reports audited 250 restaurant operators, 150 hotel operators and 702 consumers in February 2017 on their reactions to technology’s role in the guest experience over the next 8 years.

Recognition and Personalization Will be a Driver for Future Technologies
  • 33 percent of restaurant and 72 percent of hotel operators say that guest recognition via facial biometrics will be in use within the next five years.
  • 31 percent of restaurant guests and 41 percent of hotel guests will be more likely to visit an establishment with greater frequency if they are recognized by a server or associate without having to give their name or show a loyalty card.
  • Both restaurant (49 percent) and hotel (62 percent) guests agree that having this recognition would improve their experience.
  • 28 percent of restaurant customers would visit more often and 45 percent said it would improve their experience if service was faster because they were recognized.
  • 42 percent of restaurant guests find suggestions based on health invasive and 68 percent find suggestions based on digital footprint invasive.
  • 47% of hotel guests agree that using artificial intelligence to suggest items based on past purchases would improve their experience.  72% of hotel operators agree that AI-based systems that leverage guest preferences and buying history to make targeted dining recommendations will be mainstream by 2025.
Consumers are Warming to Voice-Activated Experiences
  • 36 percent of restaurant guests say ordering through a virtual assistant would improve experience and 17 percent would visit more often, along with 50 percent and 33 percent of hotel guests respectively.
  • 59 percent of hotel guests believe controlling their room via a voice-activated device would enhance the guest experience and operators agree. Hotel operators polled indicated that managing room control and ambiance management (78 percent) via voice activation would be widespread by 2025. Hotel operators also believed that ordering room or hotel services (70 percent) via voice activation would be adopted by 2025.
  • Operators are keen on gathering customer feedback by voice; 61 percent of restaurant operators and 68 percent of hotels said this will be in use in the next 5 years.
Virtual Reality will Enhance the Booking and on-Property Experience in Hotels
  • Consumers also indicated that virtual reality tours of hotel properties (66 percent) and virtual reality lounges for entertainment (44 percent) would improve the guest experience.
  • Hotel operators also believe virtual reality technology will be widespread by 2025 with a variety of use cases: staff training (68 percent), guest entertainment on property (64 percent), and previewing meeting rooms (63 percent).
Robots Won’t be Replacing Hospitality Staff Anytime Soon
  • 50 percent of restaurant guests said being served by a robot would not improve the guest experience and 40 percent would visit less.
  • 37 percent of hotel guests said being served by a robot would not improve the guest experience and 22 percent would visit less.
  • 64 percent of restaurant and 58 percent of hotel operators say that the use of robots for cleaning is appealing.
Operators Begin To Consider Investment in Wearable Technology
  • 51 percent of restaurants and 63 percent of hotels say staff activity monitoring via wearable device will be in use in the next 5 years.
  • 59 percent of restaurants and 78 percent of hotels say that staff checking into work and onto workstations via wearable device will be in use in the next 5 years.
Contact Info Matt Torres
Oracle
415-595-1584
matt.torres@oracle.com Dan Brady
Burson-Marsteller
516-650-7354
dan.brady@bm.com About Oracle Hospitality

Oracle Hospitality brings 35 years of experience in providing technology solutions to food and beverage operators. We provide hardware, software, and services that allow our customers to deliver exceptional guest experiences while maximizing profitability. Our solutions include integrated point-of-sale, loyalty, reporting and analytics, inventory and labor management, all delivered from the cloud to lower IT cost and maximize business agility.

For more information about Oracle Hospitality, please visit www.oracle.com/hospitality.

About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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 preceding 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. 

Talk to a Press Contact

Matt Torres

  • 415-595-1584

Dan Brady

  • 516-650-7354

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Retail 2025 Study Reveals Consumer Attitudes on Disruptive Technologies and Their Impact on Future Retail Experiences

Oracle Database News - Wed, 03/22/2017 - 13:08
Press Release Oracle Retail 2025 Study Reveals Consumer Attitudes on Disruptive Technologies and Their Impact on Future Retail Experiences Research Highlights Differing Sentiments on the Role of Automation, Drones, IoT, 3D Printing, Virtual Reality and Wearables in Customer Experience

Oracle Industry Connect, Orlando, FL.—Mar 22, 2017

Today Oracle announced the findings of new research that examines consumer attitudes to new technologies and how their implementation will shape consumer behavior in the years to come. Insights from the Oracle Retail 2025 study highlight that consumers are most willing to engage brands with new technology if they feel that they are in control of their experience.

“Consumers clearly indicated that they have a conservative appetite for retail techologies that requires deep personal data and make decisions on their behalf,” said Mike Webster, senior vice president and general manager at Oracle Retail and Oracle Hospitality. “This signals brands to focus on building a strong foundation to win trust. Warm attitudes toward utilizing virtual reality and receiving recommendations for custom-made accessories produced with 3D printing points to consumers’ willingness to adopt new technologies if they are in control of their experience.”

The Retail 2025 Report results provide a benchmark for where consumers are on the retail technology adoption lifecycle and the impact on retail in the next eight years. The Retail 2025 Report polled 709 consumers in February 2017.

Smart Gets Smarter

AI, VR and IoT present the opportunity to better anticipate consumers’ next purchase. However, establishing a strong foundation of trust is critical to success when rolling out new experiences to consumers. If brands over step the reaction can be visceral.

  • 64 percent of respondents liked the option of using virtual reality to navigate a personalized in-store experience and having a hand-picked wardrobe to try on in-store
  • 58 percent of consumers indicated a positive attitude toward the idea of having their grocer suggest a shopping list for their approval based on purchase history, social and environmental data
  • 54 percent of respondents indicated that having a grocer automatically charge and ship items based on purchase history, social and environmental data was invasive
Fast Gets Fierce

Velocity in fashion is critical and it will only get faster. 3D printing and drone deliver will accelerate the product design to consumer process from months, to days and eventually hours.

  • 67 percent of consumers like the option of near real-time delivery to their doorstep by drones
  • 64 percent of consumers responded favorably to the concept having a retailer suggest a custom-made accessory for them produced with 3D printing
  • 57 percent of consumers find apparel recommendations from robots based on their social media profile invasive
Personalization Gets Perfected

Consumers are wary about volunteering data necessary for personalization but still look for a tailored experience, reinforcing the need for stronger brand relationships. On the flipside; there is a clear difference in consumer expectation for retailers to make data available and customize information about components, origin and recalls to their specific buying patterns.

  • 54 percent of respondents viewed the concept of linking their wearable activity tracker to their pharmacy so they can suggest products to meet specific health and wellness needs as favorable
  • 78 percent favor the option of having detailed information about product components (e.g., cotton, spandex, etc) and their origin prior to purchase
  • 46 percent of respondents indicated that receiving real-time alerts on current product recalls, and time since last recall by a manufacturer, based on previous purchase history would improve their experience
Contact Info Matt Torres
Oracle
415-595-1584
matt.torres@oracle.com Dan Brady
Burson-Marsteller
516-650-7354
dan.brady@bm.com About Oracle Retail

Oracle provides retailers with a complete, open, and integrated suite of best-of-breed business applications, cloud services, and hardware that are engineered to work together and empower commerce. Leading fashion, grocery, and specialty retailers use Oracle solutions to anticipate market changes, simplify operations and inspire authentic brand interactions. For more information, visit our website at www.oracle.com/retail.

About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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 preceding 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. 

Talk to a Press Contact

Matt Torres

  • 415-595-1584

Dan Brady

  • 516-650-7354

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Utilities Launches Smart Grid and IoT Device Management Solution in the Cloud

Oracle Database News - Wed, 03/22/2017 - 13:00
Press Release Oracle Utilities Launches Smart Grid and IoT Device Management Solution in the Cloud Oracle Utilities Operational Device Cloud Service is the Foundation for Next Generation Smart Grid and IoT Device Management

Oracle Industry Connect—Orlando, Fla.—Mar 22, 2017

Oracle today introduced Oracle Utilities Operational Device Cloud Service (ODCS), a new cloud offering that enables utilities to further automate the management of their grid assets and devices, at a total lower cost of ownership.

The utilities industry is going through tremendous transformation as a result of IoT and increasing distributed energy resources. The United States alone has more than 70 million smart meters installed [footnote] and utilities are increasingly deploying smart field sensors. As each smart device has its own unique requirements for maintenance, inspection, firmware upgrades and security, utilities are struggling to manage the lifecycle of these assets in a single, centralized way. In response to these challenges, Oracle has unveiled a cloud-based version of its Operational Device Management Solution that provides a scalable and future-proof way to manage IoT device operations.

Available as a new stand-alone cloud service, ODSC automates the management of smart grid and IoT devices. When combined with Oracle Utilities Work and Asset Management solution, it delivers a unified solution in the cloud to extend asset performance management to smart devices at a massive scale. This complete visibility of smart assets delivers detailed insights into each device‚Äôs location, characteristics, health, and firmware upgrade status. In addition, utilities can extend ODCS for customer‚ÄĒowned asset registration processes such as smart thermostats and solar PVs. Additionally, by leveraging the cloud, utilities can reduce their total cost of ownership.

‚ÄúWe‚Äôre in front of the dramatic shifts the utilities industry is experiencing, providing new technologies that meet the needs of our customers as they navigate this changing landscape,‚ÄĚ said Rodger Smith, general manager and senior vice president for Oracle Utilities. ‚ÄúWe‚Äôre committed to innovation, and to providing cloud solutions that make operational excellence a reality for electric, gas and water utilities worldwide.‚ÄĚ

The solution can be added to Oracle Utilities Work and Asset Cloud Service and Oracle Utilities Meter Data Analytics Cloud Service or used as a stand-alone solution depending on a utility’s requirements.

New Features in Oracle Utilities Operational Device Management Cloud Service:
  • Proactively adjust, update, and repair smart grid and IoT devices as needed
  • Enable significant cost savings by eliminating labor costs due to physical data collection with automated processes
  • Reduce total cost of ownership by using the most up to date IT infrastructure in the cloud and alleviating the need to continually maintain older systems
  • Find risks of device failures faster with increased visibility into the age and reliability of each device
  • Prepare for asset registration capabilities of customer-owned assets
Contact Info Valerie Beaudett
Oracle Communications
+1 650-400-7833
valerie.beaudett@oracle.com Christina McDonald
Burson-Marsteller
+1 212.614.4221
christina.mcdonald@bm.com About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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 preceding 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. 

Talk to a Press Contact

Valerie Beaudett

  • +1 650-400-7833

Christina McDonald

  • +1 212.614.4221

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Utilities Launches a New Asset Performance Management (APM) Solution in the Cloud

Oracle Database News - Wed, 03/22/2017 - 13:00
Press Release Oracle Utilities Launches a New Asset Performance Management (APM) Solution in the Cloud Oracle Utilities Work and Asset Cloud Service is the foundation that supports next generation APM

Oracle Industry Connect—Orlando, Fla.—Mar 22, 2017

Oracle today introduced Oracle Utilities Work and Asset Cloud Service, an innovation foundation for asset performance management. The new cloud offering enables utilities to make the necessary transition from reactive to proactive asset management strategies. Utilities can increase asset reliability by finding asset failures faster and performing predictive maintenance with integrated APM and analytics.

Asset reliability and performance is core to well-functioning electric, gas, and water utilities. An aging workforce, pressure from regulators, and scrutiny on cost reduction goals are driving the need to extend the life of existing assets. Distributed energy resources (DER) are adding layers of complexity that underpin a utility‚Äôs asset reliability. Market research indicates that enterprise asset management supported by analytics and performance monitoring is one of the top investment priorities for utilities today (see footnote).   Asset operations decision-makers are looking at advanced analytics to improve asset reliability and monitor their performance.

In response to these challenges, Oracle Utilities is taking a comprehensive approach to APM. Historically, work order management, reliability-centric maintenance, asset tracking, advanced analytics, mobile scheduling, and operational reporting have been siloed applications. Today marks an important step towards integrating these capabilities.

‚ÄúPredictive analytics are changing the game for utility asset maintenance. Extending the life of utility assets can avoid expensive capital projects and lower maintenance costs,‚ÄĚ said Kevin Prouty, Vice President, IDC Energy Insights. ‚ÄúWith the explosion of IoT devices and data around the corner, scalability of these systems will require IT infrastructure that can react and scale quickly. This makes utility asset maintenance applications even more prime for deployment in the cloud.‚ÄĚ

Oracle Utilities Work and Asset Management Cloud Service improves asset operations ability to predict risk of failures faster with out-of the-box APM analytics. The cloud deployment delivers immediate value by reducing total cost of ownership. With integrated analytics, utilities can operationalize insights by optimizing work and maintenance schedules in real time. Unlike stand-alone analytic solutions, integration of these analytics into established work order management systems is an accelerant to optimizing performance of assets.

‚ÄúWhen you combine deregulation, changing legislation and market uncertainty stemming from increasing distributed energy resources, it‚Äôs no surprise that utilities are looking for more ways to improve operations and cut costs,‚ÄĚ said Rodger Smith, general manager and senior vice president, Oracle Utilities. ‚ÄúOracle Utilities Work and Asset Management Cloud Service provides more detailed analytics and deep insights into asset age, health and performance. The cloud infrastructure also gives utilities the flexibility to scale up quickly as new assets are added to the infrastructure from rising IoT and distributed energy resources that are adding more sensors on the network.‚ÄĚ

New Features and Benefits Include:
  • Prevent risk of asset failures faster with out-of-the-box analytics to support repair-versus-replace decisions
  • Detect patterns of asset failure with predefined dashboards and charts to improve investment and capital planning
  • Reduce total cost of ownership by using the most up to date IT infrastructure in the cloud and alleviating needs to constantly maintain older systems
  • Optimize asset reliability programs including ISO 55000 to increase overall value of asset operations more quickly
    • Footnote: ‚ÄúThe Black & Veatch 2016 Strategic Directions: Smart City/Smart Utility‚ÄĚ Research
    • Oracle Utilities Work and Asset Management overview
    • Follow us on Twitter: @OracleUtilities
Contact Info Valerie Beaudett
Oracle Communications
+1 650-400-7833
valerie.beaudett@oracle.com Christina McDonald
Burson-Marsteller
+1 212.614.4221
christina.mcdonald@bm.com About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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 preceding 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. 

Talk to a Press Contact

Valerie Beaudett

  • +1 650-400-7833

Christina McDonald

  • +1 212.614.4221

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Health Sciences Data Management Workbench Now Available in the Cloud

Oracle Database News - Wed, 03/22/2017 - 13:00
Press Release Oracle Health Sciences Data Management Workbench Now Available in the Cloud Speeds Clinical Discoveries and Reduces Research Costs

Oracle Industry Connect—Orlando, Fla.—Mar 22, 2017

Oracle Health Sciences today unveiled Oracle Health Sciences Data Management Workbench Cloud Service that promises to lower the cost and increase the traceability of clinical development by streamlining end to end clinical data flow across clinical R&D.

Planning and managing clinical trials has become more complex as additional data is being generated, collected and analyzed to demonstrate clinical efficacy, ensure successful regulatory approval and ultimately bring more therapies to market faster. Oracle Health Sciences Data Management Workbench Cloud Service enables pharmaceutical companies and contract research organizations to integrate, reconcile and analyze the growing variety and volume of clinical and healthcare data. By automating data flow and standardizing data for review, clinical researchers have near real time access to insights for clinical trial decision making‚ÄĒall at a dramatically lower total cost of ownership as a result of it being offered as a cloud service.

‚ÄúThe volume and complexity of data in healthcare and life sciences has increased on a massive scale as we capture more data from sources such as electronic health records, wearables and genomics. Clinical data managers and data scientists are now integrating more of this data into their clinical research and trials to improve the odds of more therapies making it to market and faster,‚ÄĚ said Steve Rosenberg, general manager, Oracle Health Sciences. ‚ÄúThe industry has been looking for a purpose-built data management solution that supports the clinical data flow from source to submission, with a lightweight, cloud-based solution, and Oracle‚Äôs new cloud-based data management platform is able to manage all of this new information while ensuring FDA data compliance‚ÄĒat a dramatically lower cost.‚ÄĚ

Oracle Data Management Workbench Cloud Service is pre-integrated with Oracle Health Sciences InForm, enabling two-way real time data flow. Additionally, it brings new levels of standardization, reusability and traceability among disparate clinical data sources by enabling clinical data managers to aggregate, clean and transform data into submission-ready deliverables more quickly than ever before. By using an integrated workflow, data discrepancies can be closed faster, reducing clinical review cycle times and increasing overall data quality.

Contact Info Valerie Beaudett
Oracle Communications
+1 650-400-7833
valerie.beaudett@oracle.com About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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 preceding 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. 

Talk to a Press Contact

Valerie Beaudett

  • +1 650-400-7833

Follow Oracle Corporate

Categories: Database, Vendor

Data Importing using IIF function for IBM Cognos Controller

IBM - DB2 and Informix Articles - Wed, 03/22/2017 - 05:00
This document will explain how to use IIF functions with importing data into IBM Cognos Controller.
Categories: Database

Hyper-V: How to run Ubuntu (or any Linux) on Windows

NorthScale Blog - Tue, 03/21/2017 - 15:57

I recently needed to install a Linux distro (Ubuntu being my favorite) in Hyper-V on Windows 10. I needed to do this because some internal builds of Couchbase were temporarily broken on Windows, but I still needed to use the latest builds. I’d never used Hyper-V to do this before, but it wasn’t that difficult. And the best part is that it comes with Windows: I don’t have to install VirtualBox or VMWare or anything like that.

Download Ubuntu

There are lots of great Linux distros out there, and Couchbase Server can be run on a variety of them. However, Ubuntu Desktop is my go-to.

The first thing I did was to download an Ubuntu Desktop ISO. I know that Couchbase support for Ubuntu 16 is coming, but for now I want to stick to Ubuntu 14. So, I downloaded an ISO of 14.04.5 (aka Trusty Tahr).

Make sure Hyper-V is enabled

Check to make sure that you have Hyper-V enabled on Windows.

First, open Control Panel. Next, go to Programs. Then, click “Turn Windows features on or off”. Finally, locate Hyper-V and click the checkbox (if it isn’t already checked).

Enable Hyper-V feature in Windows

You may also need to enable virtualization in the BIOS settings on your computer. The computer I’m using has it turned on by default. I wish I could give you instructions on how to do this, but it’s going to vary based on your BIOS.

Create a Hyper-V Virtual Switch

When connecting the virtual machine to a network, you’ll need to select a virtual switch. If you haven’t done this before, you’ll need to create one.

First, click “Virtual Switch Manager”, then select “External”. Click “Create Virtual Switch”. Finally, give the switch a name. (You also need to choose an external network; in my case I only have one). Hit “Apply”.

Create Hyper-V virtual switch

I wanted my machine to be connected to my home network, so I chose External. If you use External, it will connect to your network as a separate machine. After I create the machine (in the next section) it will appear on my router as it’s own machine:

Hyper-V machine attached to my network

Create a new Hyper-V Virtual Machine

Now you’re ready to create the virtual machine that will be running Ubuntu.

First, open the Hyper-V Manager from the Start menu. Then, click “New” and then “Virtual Machine”. This will start a wizard.

First, give your machine a name (like “UbuntuForCouchbase”). Optionally, you can choose where to store this machine, or use the default directory.

Next, you must choose Generation 1 or Generation 2. I used Generation 1, but Ubuntu 14+ should work on Generation 2 as well.

After that, specify how much memory to allocate to the machine. I have a lot of RAM on my desktop, so I gave it 8192mb.

Next, select the switch that was created in the previous section.

Then, setup the virtual hard disk to your liking. You can choose the location and size of the disk. I don’t need very much, so I went with 60gb.

Finally, you need to select an operating system. I’ll choose “Install an operating system from a bootable CD/DVD-ROM”, and then “Image file”, and find the Ubuntu ISO that I downloaded.

Click “Next”, view the summary, and click “Finish”.

Create Ubuntu Virtual Machine in Hyper-V

Start the machine and install Couchbase

Now that you’ve created a machine, you must start it. Right-click on the machine and select “Start” (or there’s a “Start” button in the actions menu to the right).

This starts the machine, but you can’t actually see the machine yet. You have to “Connect” to the machine to see what it’s doing. Right-click and select “Connect” (or again, there’s a “Connect” button in the actions menu to the right).

Ubuntu in Hyper-V

I won’t go through the installation process, since Ubuntu’s installation is pretty easy and self-explanatory (and well-documented).

At the end of the Ubuntu installation, installing Couchbase Server is also pretty easy and self-explanatory. Just go to the Couchbase downloads page and select the Ubuntu 14 version of Couchbase.

Download Couchbase for Ubuntu

Summary

I normally use the Windows version of Couchbase, but sometimes I need to use Ubuntu (or other Linux distros). Hyper-V on Windows is a convenient way for me to spin up virtual machines.

If you have any questions about Couchbase, please ask away in the Couchbase Forums or check out the Couchbase Developer Portal.

You can also contact me at Twitter @mgroves.

The post Hyper-V: How to run Ubuntu (or any Linux) on Windows appeared first on The Couchbase Blog.

Categories: Architecture, Database

Oracle Cloud Platform Continues to Gain Momentum with Customers, Partners, and Developers

Oracle Database News - Tue, 03/21/2017 - 13:00
Press Release Oracle Cloud Platform Continues to Gain Momentum with Customers, Partners, and Developers Developers at Global Enterprises, SMBs, and ISVs leverage Oracle’s PaaS and IaaS to develop and run modern Web, mobile, and cloud-native applications

Oracle Code, NEW YORK—Mar 21, 2017

Today at its premier developer event, Oracle announced that an increasing number of global enterprises, SMBs, and ISVs are choosing the Oracle Cloud Platform to speed innovation, simplify IT, reduce costs, and deliver stellar customer experiences. 7-Eleven, Altair, Astute Business Solutions, Bitnami, Calypso Technology, Ford Motor Company, GE Capital Business Process Management Services, HashiCorp, Infotech, SAS, Vertiv Corporation, and Zensar Technologies are just a few of the many organizations that are using Oracle Cloud’s PaaS and IaaS services to easily develop, test, and deploy high-performance applications in the cloud. Additionally, Oracle continues to expand its cloud portfolio, making it even more compelling for customers to move to the cloud.

The Oracle Cloud Platform provides customers, partners, and developers with everything they need to build, deploy, and extend applications and run business-critical workloads in a low-latency, highly available, secure cloud environment. For developers, the Oracle Cloud Platform provides the foundation they need to provide cutting-edge applications that leverage the latest technology innovations. Developers can use the platform to quickly create applications with microservices, APIs, containers, machine learning, mobile backends, and chatbots using modern DevOps processes. With pre-integrated big data and analytics, integration, management and monitoring, mobility and Internet of Things (IoT) capabilities, developers can easily connect these applications to other cloud or on-premises systems and devices to gain new levels of intelligence and customer success. In the past two years alone, Oracle has delivered more than 50 PaaS and IaaS services to market and introduced new deployment options such as Oracle Cloud at Customer, providing unparalleled opportunity for customers.

‚ÄúOrganizations across industries and geographies are increasingly taking advantage of the Oracle Cloud Platform to quickly develop and deploy business-critical applications,‚ÄĚ said Amit Zavery, senior vice president, Oracle Cloud Platform. ‚ÄúBy delivering the most advanced cloud capabilities, Oracle is helping customers and partners out-innovate the competition, transform their businesses, and increase profitability.‚ÄĚ

To participate in upcoming Oracle Code events in a city near you, visit: http://developer.oracle.com/code

Customers and Partners Benefit from Oracle Cloud Platform

‚ÄúAltair has a unique combination of engineering applications and enterprise computing offerings for high performance computing in the cloud,‚ÄĚ said Sam Mahalingam, chief technical officer, Altair. ‚ÄúOur solutions performed extremely well on Oracle Cloud Platform in terms of accuracy, consistency, and cost efficiency. We will continue building solutions for the Oracle Cloud Platform that can leverage the latest infrastructure technology along with Altair‚Äôs leading cloud solutions for HPC.‚ÄĚ

‚ÄúWe continue to be impressed by the breadth and depth of the Oracle Cloud Platform,‚ÄĚ said Daniel Lopez, CEO, Bitnami. ‚ÄúBitnami provides open source images to cover all the functionality a modern enterprise demands: from easy to use tools for developers to production-ready solutions, across Oracle Cloud‚Äôs IaaS services, virtualized and container-based platforms.‚ÄĚ

‚ÄúThe shift to cloud has created a unique opportunity for us to bring technological innovation to the forefront of the financial industry,‚ÄĚ said Pascal Xatart, CEO, Calypso Technology. ‚ÄúWe are deploying these transformative solutions with Oracle, whose technology stack is an excellent combination of performance, security and agility that allows us to increase the value of our cloud services.‚ÄĚ

‚ÄúHashiCorp and Oracle share many common customers,‚ÄĚ said David McJannet, CEO of HashiCorp. ‚ÄúOracle Cloud‚Äôs growing support for HashiCorp Terraform will enable our customers to use a common approach to infrastructure provisioning for those workloads that they choose to run in Oracle Cloud. This will enable our joint customers to deliver better applications, faster on the infrastructure of their choice.‚ÄĚ

‚ÄúOur market is changing, and so must our industry-leading life science labeling solutions. So we decided to start delivering our ROBAR service via the cloud to make it easier for new customers to access our world class labeling solutions. For us, high availability, reliability and security are top priorities, especially in the highly regulated industry in which we operate,‚ÄĚ said Ardi Batmanghelidj, president and CEO, Innovatum. ‚ÄúWe considered several solutions, including Amazon, but chose Oracle Cloud Infrastructure as a Service due to Oracle‚Äôs reputation as a leading technology provider. Oracle‚Äôs focus on security helped to tip the scales, along with the cost-effectiveness of its offerings.‚ÄĚ

‚ÄúEnterprises building modern apps rely on data services, and they want these data services on any infrastructure or cloud to support hybrid cloud and multi-cloud configurations,‚ÄĚ said Edward Hsu, vice president of product marketing at Mesosphere. ‚ÄúMesosphere DC/OS enables IT organizations to become hybrid cloud service providers, and we‚Äôre excited to have DC/OS on the Oracle IaaS to give businesses the broadest set of choices on where to run their modern applications.‚ÄĚ

‚ÄúQubole Data Service (QDS) is a turnkey, Big Data-as-a-service platform that accelerates data insight across companies leveraging open source technologies like Spark, Hadoop, Hive, etc. We believe Big Data belongs in the cloud, and we‚Äôre excited to support QDS on the Oracle Cloud Platform,‚ÄĚ said Ashish Thusoo, co-founder and CEO of Qubole. ‚ÄúMost of the world‚Äôs enterprise data touches the Oracle ecosystem, and we believe running on the Oracle Cloud Platform provides an ideal solution for turning data into valuable business insights at a compelling price/performance value.‚ÄĚ

‚ÄúSUSE, as an enterprise-focused ‚Äėopen‚Äô open source company, has been collaborating with Oracle on many joint technology innovations and for many years,‚ÄĚ said Dr. Thomas Di Giacomo, CTO at SUSE. ‚ÄúToday we‚Äôre very pleased and excited to announce that the SUSE Linux Enterprise Server image is available on the Oracle Cloud Marketplace. This opens the door to future cloud activities in the Oracle Cloud ecosystem around IaaS, PaaS, and enterprise cloud native DevOps, areas in which SUSE is rapidly expanding our solutions.‚ÄĚ

‚ÄúAs as public cloud implementer for many years, and as early adopters of Oracle Cloud IaaS and PaaS, in the last quarter we have seen significant adoption of Oracle Cloud across our large managed services customer base in the UK and Ireland. We have projects on-going on Oracle IaaS, PaaS and SaaS in multiple industries including public sector, utilities and the financial services,‚ÄĚ said Ken MacMahon, Head of Oracle Cloud Services at Version 1. ‚ÄúA real sweet-spot for its adoption for us has been customers who wish to leverage public cloud for deployment of key application workloads that are built on Oracle technology. This leverages both our Oracle and public cloud expertise to give customers the optimum benefits and power of the Oracle IaaS and PaaS."

Technology Innovations and Industry Accolades

Continuing its rich history of delivering game-changing cloud services, Oracle recently announced new enhancements to the Oracle Cloud Platform, making it even more compelling for customers to move their business-critical applications to the cloud. Most recently, Oracle became the first to offer Oracle Database Cloud on bare metal compute, and new virtual machine (VM) compute, load balancing, and storage capabilities, all on the same low latency, high performance modern IaaS platform. Oracle Cloud Platform now delivers differentiated database performance at every scale, and deeply integrated IaaS capabilities, for customers of any size to easily develop, test, and deploy their business-critical applications in the cloud.

Additionally, Oracle was recently recognized as a one of the 20 Coolest Cloud Infrastructure Vendors of 2017 in CRN Magazine’s Cloud 100 report.

Try Oracle Cloud for Free

Customers interested in trying Oracle Cloud can sign up for $300 in free credits at: https://cloud.oracle.com/tryit

Oracle Cloud

Oracle Cloud is the industry’s broadest and most integrated public cloud, offering a complete range of services across SaaS, PaaS, and IaaS. It supports new cloud environments, existing ones, and hybrid, and all workloads, developers, and data. The Oracle Cloud delivers nearly 1,000 SaaS applications and 50 enterprise-class PaaS and IaaS services to customers in more than 195 countries around the world and supports 55 billion transactions each day.

For more information, please visit us at http://cloud.oracle.com.

Contact Info Nicole Maloney
Oracle
+1.415.235.4033
nicole.maloney@oracle.com Kristin Reeves
Blanc & Otus
+1.415.856.5145
kristin.reeves@blancandotus.com About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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 preceding 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. 

Talk to a Press Contact

Nicole Maloney

  • +1.415.235.4033

Kristin Reeves

  • +1.415.856.5145

Follow Oracle Corporate

Categories: Database, Vendor