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…)

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…)

5 Tips for Managing Multiple Cloud Providers

By | Azure, Database Technology Trends, Oracle, SAP HANA, SQL Server, Sybase
Cloud adoption continues to rise and shows no signs of stopping anytime soon. As companies become more comfortable with the cloud platform as a tool, they are moving farther from on-prem setups. The newest trend shows many groups now using multi-cloud solutions. RightScale 201 State of the Cloud Report found that 81% of respondents have a multi-cloud environment. The organizational average was just under 5 clouds, including production and test environments. Why Multi-Cloud? – Each cloud provider has different strengths and weaknesses to offer. Using multiple clouds lets you take advantage of the best tools and applications for your workloads without limiting your resources. It can also be strategic as companies can shift workloads to their various platforms depending on current prices and availability parameters. Adopting a multi-cloud environment can help take your workload management to the next level, but it can also come with some challenges to prepare for. Here are 5 tips to help you manage multiple cloud providers. Choose Wisely – Don’t be suckered in by low rates and storage fees. Those numbers can (and will) change. The more important factor is to select the clouds that have key features you need. Look at the applications and (more…)
Server Data Migration

A Look at Azure Security Center

By | Azure
You can’t be too careful with the cloud. More enterprises are using cloud and hybrid environments for their organizational workloads. Microsoft Azure is a major player in this trend. In an assessment of cloud platforms and services provided by iDataLabs, Azure holds over 19% of the market share, the second biggest slice of the pie. This industry trend means more companies need to be prepared for cloud level security. Microsoft offers an in-house security solution in the form of Azure’s Security Center that is convenient and powerful. We want to talk briefly about what it does, and some new and exciting enhancements that have increased its scope as an organizational security tool. What is Security Center? This is Microsoft’s unified security solution that provides a platform for protocol deployment, monitoring and prevention. The service is available to Azure subscription users as a free extension or as an additional fee (Standard subscription). The free version covers your Azure cloud. But if you use hybrid environments and additional platforms, the Standard subscription allows you to deploy Security Center across your whole system. Intelligent and Adaptive – Azure Security Center sets itself apart from other security protocols with its adaptive analytics. Using machine (more…)
Staffing Database

2018 Trends for Database and Data Management – Six Months Later (Trend 1)

By | Database Technology Trends
Enterprise database platforms are expected to expand beyond traditional relational database models to include non-relational alternative models   Read about Trend 2 Six months in, it seems quaint now to say that the world of non-relational data has exploded. Customers now expect general purpose database platforms will support a whole new level of workloads and functions. This is driven in part by the emergence of the non-relational technologies of NoSQL and Hadoop and the creative force to extract new value from data. The new standard is the ability to use multiple data types, video, graph and spatial capabilities, in addition to data virtualization and data virtualization support. Real time data analysis is now the norm and no longer the exception. Six months in, is it safe to say we are at the acceptance level of this trend but implementation and vision remains another matter?  Want to find out more about how your company can leverage the power of non-relational data and your database platform?   Join Dobler Consulting and Anthony Antonello, VP, SAP HANA Global Center of Excellence, for a Live Webinar June 19th, 2018 @ 2:00 PM EDT for: SAP Sybase Roadmap 2018 View Video Replay and Download Presentation (more…)
Database Support

What’s the Deal with Oracle 18c? (part 2)

By | Oracle
Last week we introduced Oracle’s database 18c, and focused on the new release structure and its increased accessibility on cloud environments.  If you missed this article, here’s a link to go check it out now before heading back over for part 2.  – What’s the Deal with Oracle 18c (part 1) This week we are focusing on more specific feature enhancements to those areas you have come to expect in an Oracle product.  Starting with security and moving on to platform architecture we are looking at how this newest release helps simplify your data management.  We will discuss key features from Database 12c that get exciting upgrades in this new release. Stability – Several new features increase the platform stability, including Real Application Clusters, Recovery Manager and Flashback.  Oracle takes advantage of the multi-server architecture to deliver enhanced backup and recovery features, and reduced downtime for scheduled activities. Security Enhancements – Oracle has always prioritized security and this newest version builds upon that foundation.  With simplified and optimized security protocols, this database will help you prepare for more stringent security requirements coming up in the General Data Protection Regulation (GDPR).  Here are just a few ways Oracle emphasizes security in (more…)
Security

What’s the Deal with Oracle 18c? (part 1)

By | Oracle
Oracle’s newest release, 18c, is out, and I know what you’re thinking: what happened to 12.2.0.2?  Is it really time for a whole new version?  Well rest assured, this is not really a whole new version. It’s an entirely new method of naming that more accurately reflects what has been going on for years.  The old model of multiple release versions and patch sets wasn’t doing justice to the database.  The multiple release model led many to shy away from adopting any first release database for go-live workloads.  But honestly, for years the patch sets have been full releases in all but name. So now Oracle has decided to change its release schedule, and each annual release will be named after the last two digits of the year.  The plan is to speed the release of smaller changes while avoiding the massive overhauls that used to come with first releases.  What would have been database 12.2.0.2 is now 18c, and 12.2.0.3 will instead be 19. They have also gotten rid of the Patch Set Updates and Proactive Bundle Patches.  Instead we will now get Release Updates (RU) and Release Update Revisions (RUR).  So now that we understand the new release (more…)

SAP IQ Edge Edition

By | Preserved Content Pages | No Comments
SAP IQ 16 (Sybase IQ), Edge Edition, packs a set of powerful data warehousing functionality into one cost-effective solution. All the features in SAP IQ can be found in this new midmarket edition. An innovative, column-oriented design and open, flexible analytics architecture makes SAP IQ the choice of companies of all sizes – especially those keen on taking advantage of their data. Optimized to perform on less hardware, the Edge edition is a clear choice for midsize companies. View a replay of the webinar here   Objectives Uncover deep insights about business issues for today and tomorrow Extend the power of analytics with a proven data warehousing solution Scale and adopt to your growing business needs Deploy and manage with ease Solution Grid-based, column-oriented analytics platform In-database analytics with built-in numerical and analytical functions Plug-in to the SAP InfiniteInsight® solution and other predictive software Architecture optimized for queries and workloads in SAP BusinessObjects™ business intelligence solutions Benefits Rapid information access to transform your business Unified sources of diverse data for rich insights Efficient administration and optimized hardware for low total cost of ownership Improved control and security for private, secure data Vibrant community of knowledge enriching SAP IQ deployment and maintenance (more…)

SAP Sybase IQ 16 Goes Real-Time

By | Database Technology Trends, Sybase | No Comments

SAP announced at TDWI Conference, being held in Las Vegas February 17-22, the availability of SAP Sybase IQ 16, the next generation of data analytics. Equipped with in-memory data processing, SAP Sybase IQ 16 boosts its already lightning fast performance to new heights. Especially in mixed workloads with large numbers of concurrent users, the combination of disk-based column store analytics with in-memory real-time analytics will open new opportunities by adapting legacy infrastructure as well as new cutting-edge technology while working faster and more secure. Read More