Oracle 19C Available on Linux!

By | Oracle
If you are a fan of open source operating systems, you’re not alone. These robust systems are gaining popularity as the era of proprietary restriction putters to a close. These resources have a lot going for them, from high compatibility to high security and flexibility. Industry leading database providers are taking notice and incorporating Linux compatibility into their products. Now Oracle has announced the exciting news that their Oracle 19c database is available on Linux, one of the most well-known open source operating systems. This opens up an exciting host of possibilities and brings the Oracle database to a whole new client base. 19c Focus on The Client, Adds Linux to Boost Compatibility Oracle 19C is the newest release of the 12c database line, continuing to contribute to the continuous release schedule established in 2018. This release schedule means more flexibility and stability of the database created by eliminating the major and minor release pattern. This newest release features fewer new additions than last year’s 18c, but has many enhancements designed to continue improving the user’s experience and ease of use (for more on new features, check out our blog post What’s New in Oracle’s Database 19c)To that end, offering (more…)

Understanding Blockchain, the Trending New Tool

By | Database Technology Trends
There’s been an increasing amount of buzz around blockchain technology lately, and people are more interested than ever before. “A new technology that functions as a distributed ledger within a decentralized network and promises greater security, lower transaction costs, etc.” is usually how it’s described. But what does all of this really mean? What is Blockchain? In its simplest form, Blockchain is a digital ledger (consider the general ledger your organization’s finance/accounting teams use) that stores information across a network of computers. It stores information in batches called “blocks,” that are linked together in a chronological fashion, similar to a chain of blocks. This information can be virtually anything, but try imagining it in terms of a financial transaction, since that’s probably the easiest to visualize. To illustrate, here’s what happens when you make a purchase: Imagine purchasing new software online from Microsoft (for illustrative purposes only). The block would store the date, time, and dollar amount of your purchase. It would also log information about who is making the transaction. For security purposes, your name would be recorded as a unique “digital signature,” more like a username instead of your actual name. Once your block has been verified and (more…)

What’s New in Management Studio Version 17.6

By | SQL Server
Microsoft continues to make great strides in improving SQL Server Management Studio (SSMS). Version 17.6 comes with some impressive new features and bug fixes that enhance your user experience. Azure SQL Database Managed Instance Users If you’re using the newly developed Azure SQL Database Managed Instance, a new model of Azure SQL Database, you should definitely consider upgrading to SSMS v 17.6. One of the most notable changes is the added support for some of its most common management scenarios. After you complete the upgrade, you can expect a much more efficient support process if you encounter issues with the following: Databases – Creating, altering, backing up, and restoring databases are all fairly common tasks in database management, which makes their processes easy to support. Object Explorer – All technical issues that arise while using Object Explorer to manage objects in each SQL Server instance are eligible for support. SQL Linked Servers – You can relax when using Linked Servers to connect to other database instances on a remote server, same server, or an entirely different machine. The SQL Tools Team has you covered. SQL Agent Jobs – Your automated execution jobs/tasks usually consist of several steps. Any disruption can (more…)

Integrating Oracle Cloud Mobile Apps into Your Workload

By | Oracle
As the digital world continues to expand, the demand for mobility solutions is increasing. The good news is that the prevalence of cloud migrations is making the transition much smoother. Oracle recommends you move any on-premise Oracle application to the cloud. As a leader, knowing your enterprise’s data and applications are accessible regardless of your physical location can do wonders for your peace of mind. Consider Oracle Mobile Hub If you are interested in enterprise mobility for your organization, consider the Oracle Mobile Hub. It provides a comprehensive platform that simplifies application development for your developers and business owners. It focuses on extending your back-end systems so you can take advantage of applications you already use in a secure mobile environment. You also have the option of using your own developers to build and deploy new apps that will integrate seamlessly onto the platform. What Other Capabilities Does Oracle Offer to Enhance Enterprise Mobile Strategies? Using Oracle’s mobile development framework, you can create a single application that will run on multiple devices, phones and tablets, and operating systems. Android and iOS are both compatible. Oracle’s service bus manages interactions between services and applications throughout the network. This includes both newly (more…)

How to Make Power BI Work for You

By | Database Technology Trends, SQL Server
If you’re searching for software that will enhance your analytics process while making it simpler and more flexible, Power BI is worth looking at. It provides tools that the non-technical users on your team can use to perform analytics with minimal help from the IT team. You can create intuitive models, data visualizations, and dashboards and share them with whoever you want. What is Power BI? –Power BI is a cloud-based analytics software service consisting of a combination of tools (i.e., visualization, self-service data analysis, etc.) that allows users to connect to multiple data sources—no matter where the data resides— and create customized, coherent insights. It’s not exactly new since many of its components were in the market prior to its 2015 release. For instance, Microsoft released Power Pivot as an Excel add-on in 2010. This tool alone is a game changer as it gives analysts the tools to import large volumes of data, create relationships between the data, and perform powerful analysis using PivotTables and Pivot Charts. Using Power BI, you can further manipulate these datasets to perform more complex analyses. Utilize All Components of Power BI – Power BI consists of many components. Users find some more useful (more…)

Make the Most of Microsoft SQL Server with Management Studio

By | SQL Server
Microsoft SQL Servers are an industry leading choice for your workloads, but if you are not using Management Studio you may be making things harder for yourself. The additional service is designed to integrate with your SQL database engine and improve object management, database queries, and other management functionality. What is Management Studio? – SQL Server Management Studio (SSMS) was originally released with SQL 2005 and helps users access and manage their SQL instances. It is an integrated management interface that allows you to access your SQL Server, manage objects, write scripts and perform queries with a number of tools and features. It combines tools from Enterprise Manger, Query Analyzer, and Analysis Manager to get this job done. SSMS is easy to use with an intuitive User Interface (UI) and familiar design built on Visual Studio and will help improve your team’s management of SQL Server objects and elements Object Explorer – The interface is intuitive and makes accessing and managing your databases simple and efficient. The Object Explorer is a hierarchical navigation tree that allows you to locate and act upon objects in your environment. These objects can be databases, tables, etc. You can click through the tree to (more…)

What is Azure Stack and Why Do You Need It?

By | Azure
Whether you are using Azure or not, I am sure you are familiar with the term. The Azure Cloud is the fastest growing cloud computing service out there and is quickly edging out AWS for the market. It is a powerful and expansive service that fully supports hybrid infrastructures for robust data management. You may not know quite as much about Azure Stack, so we wanted to shed some light on this Azure extension. What is Azure Stack? – This service is an addition to your Azure Cloud network that enables offline operations on your edge computing machines. It allows your on-site users to manage data, perform analyses, and even design queries using little bandwidth. Actions can be performed in an offline environment and then reserved for specific connection windows and deployed to the cloud. Let’s Talk About Edge Computing – Your network is a complicated series of user APIs and core network processing capabilities. Think of this overall structure as a web of interconnected strings leading back to the central data hub. Edge computing refers to the processes that take place farther away from your centralized network, literally at the edge of your web. We will discuss this in (more…)

We’re Excited About SQL Server 2019, Here’s Why

By | Azure
Microsoft SQL Server 2019 is out in preview and it’s got some exciting new features. When Microsoft announced the release at their Ignite 2018 conference on Sept 24th, we couldn’t wait to see what was in store. This newest offering will continue to build on the solid foundation of SQL servers while expanding offerings of flexibility and further embracing big data by adding support for Kubernetes, Apache Spark, and Hadoop clusters. Embraces Big Data – Probably the biggest change to SQL 2019 is the ability to manage big data clusters. Big data has always been a bit of a gap in the arsenal of Microsoft’s SQL servers, but not anymore. With SQL 2019, Microsoft is fully embracing big data with Kubernetes. Kubernetes is an open-source container-based platform that represents exciting new possibilities for this SQL engine. With SQL on Kubernetes you will be able to can create high availability solutions with Linux containers and manage multiple data sources all in one place. Manage Relational and Non-Relational Data – The new engine can query data from a number of different sources, including relational and non-relational data storage. Microsoft has built in native support of Apache Spark and Hadoop Distributed File System (more…)

Reducing Application Errors with Application Continuity

By | Database Technology Trends
The database and application work hand in hand. When a client interacts with features on your website the application calls back to the database, and the database responds by giving it the right information or action. It’s a well-orchestrated conversation. When something happens that stops the conversation the application doesn’t get what it needs and the customer receives an error. This is where application continuity comes in. The idea is to enable maximum continuous communication between the application and your database instances even if there is an outage. This is a massive step in maintaining data integrity and improving the end user experience. The first step in understanding continuity is virtualization. This means that your database layers are virtualized in the stack and your infrastructure can create multiple nodes and instances for your workload, shuffling transaction and processing usage as needed. It is useful for scaling up and down easily and allows more redundancy to protect in case of outages. When one node goes down, whether for scheduled maintenance or unexpected failure, the other nodes are there to take its place and your customer is never the wiser. There are some software products that can help you design this virtualization (more…)

3 Top Analytics Tools To Boost Your Productivity

By | Azure, Database Technology Trends, Oracle, SQL Server
Data analytics have become a major focus for companies determined to be competitive in the market. Leaders need to be able to access and analyze timely data quickly to help drive business decisions that will sustain their companies’ competitive advantage. Thankfully, the growing technology market continues to make this possible. Companies already have numerous analytics tools to choose from, and the options will continue to grow. We will now discuss three of the top analytics tools you should consider before making your next strategic move. 1. Microsoft SQL Server Analysis Services (SSAS) – SSAS is an innovative processing and data mining tool within the Microsoft SQL Server. It analyzes large amounts of data, provides business intelligence reports, and can be used to create business models to support business decisions. All data is stored within a data warehouse, and users can access to create cubes that allow faster analysis. These cubes are multi-dimensional and can be viewed in various ways. Imagine the data as a pivot table that can be modified using certain dimensions and attributes. Multi-dimensional expression (MDX) is the language used to query a cube. Compared to other leading analytics tools, Microsoft SSAS is less complex and much easier (more…)