Is SQL PaaS Right for You?

By | Azure
With the arrival of the new year, you might be considering how SQL Server can better fit your company’s growth in 2019.  SQL Platform as a Service (PaaS) could be a viable option for managing essential database operations. With PaaS, your SQL Server workloads would run as a hosted service in the cloud with most database management functions maintained by the cloud service provider instead of your IT team. Top Reasons to Consider PaaS Operates completely within the cloud. PaaS provides developers with an environment to develop and deploy applications entirely within the cloud. This includes complex enterprise applications your company may need to solve business problems and simple cloud-based applications. Scaling is easy. You can pay-as-you-go. Service providers allow you to take advantage of advanced development tools as you need them, giving you more value at an affordable rate. Your bottom line increases. You no longer need to purchase software licenses, application infrastructure, or development tools. Finally, your development team can have the opportunity to focus on managing the applications and services they create while the cloud service provider manages the rest. Decrease coding time. The development tools PaaS can provide include some pre-coded application components (i.e., security features, directory services, workflow, etc.) (more…)

Machine Learning, AI and Advanced Analytics

By | Database Technology Trends
Big data is big news across industry sectors. The digital age has given rise to information overload, and the most resourceful businesses are learning how to take advantage of that information. It takes a special type of skill to gain actionable insights from these massive amounts of data, and that is where advanced analytics comes in. With technologies like artificial intelligence (AI) and machine learning (ML), data-driven business insights are possible like never before. Here’s a breakdown of how these technologies really work. The Science of Advanced Analytics – Traditional analytics refers to more linear quantitative analysis, usually generated by business intelligence (BI) systems. These are examinations of performance drawn from a structured and pre-defined framework. They use existing historical data from a database or data warehouse. With advanced analytics, we are able to follow the data without a pre-determined scope. All you need is a starting point. For example, consider the question: what type of people buy yogurt in the mornings? With traditional analysis, you would be left skimming through sales data and designing reports to cross reference yogurt sales and time of day, but that only tells you how many people have performed this action, not what type (more…)
Database Consulting

What are Data Clusters and What Can They do For You?

By | Azure, SQL Server
Learning to effectively manage large datasets is key to optimizing your data analytics. Using data clusters can help optimize your data management. It involves grouping data points with similar characteristics into the same cluster to speed up processing time and improve analysis. Consider starting an analysis project on customer spending habits by gender in different regions. Your time on the project would be maximized if you’re able to use statistical techniques to automatically organize the data into logical groups prior to analyzing. How do data clusters work? Data clustering allows you to partition large volumes of structured and unstructured data/observations into logical groupings. One way it does this is by analyzing all of the data in the data warehouse and comparing each data point with clusters created. You rely upon the clustering algorithms to sort and cluster the data in a logical way. In a perfect world, all data points in the same group should be highly similar in nature, while data points in different groups should be dissimilar. There are several different models and algorithms that guide the clustering process. Here are a few: Hierarchical Method: This method creates separate successive clusters using specific criteria. Partitioning Method: This method (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…)