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

Data Connect Newsletter – September 2018

By | Dobler Consulting Newsletter
  Data Connect Newsletter – September 2018 Announcements Something Sure Seems Different This Year… Traditionally, summer and particularly the end of summer is the slowest point of the sales cycle for IT services and consulting firms. But not this year, August was one of our busiest months. Why is that? For one, the booming economy requires business investment in efficient and innovative technologies and there are some amazing new products and services on the market today. And two, we have positioned ourselves for this moment; achieving SAP Gold Partnership status and Microsoft Gold and Silver Partnership status this year didn’t hurt. Also, traditionally there is the Q4 mad-dash towards the end of the year so as to be able to hit the ground running in Q1 and Q2 ’19. Our partnerships with market leaders SAP, Oracle and Microsoft and other emerging technologies mean we can better assist in the planning, purchase, design and implementation of your data management, analytics, cloud migration and or cyber security services needs. So avoid the year-end mad-dash –the time is now. To learn how we can be of value and service to you, contact our team today. What Does This Mean For Our Clients? Increased (more…)

Data Connect Newsletter – June 2018

By | Dobler Consulting Newsletter
  Data Connect Newsletter – June 2018 Don’t miss our upcoming June 19th webinar with Anthony Antonello, VP, SAP HANA Global Center of Excellence. SAP Sybase Roadmap 2018 Webinar Tuesday June 19th, 2018 @ 2:00 PM EDT REGISTER NOW Announcements Dobler Consulting Nominated for the 2018 Small Business Of The Year Award by the Tampa Bay Chamber of Commerce Recognition of the Dobler Consulting’s Civic and Business Leadership Continues to Grow Tampa Bay June 7th, 2018. The Tampa Bay Chamber of Commerce announced that Dobler Consulting is a semifinalist for the 2018 Small Business of the Year Award for companies between 21–50 employees. The awards are given annually and the winners will be announced in September 2018. The companies are evaluated on the criteria’s of operational management, community involvement, and ethical business practices. Read more Upcoming Events SQL Saturdays Dobler Consulting attends and sponsors SQL Saturday events to promote training to the SQL community. We will share our knowledge through presentations and teach attendees on new options Microsoft introduces in their database products. If you are in the area, please join us. Click on the links below to learn more about each event. Orlando SQL Saturday #801 – October 6, 2018 Product/Service Updates XpressInsight The (more…)

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

By | Database Technology Trends
More Companies Will Die From Data indigestion Than From Data Starvation   Read about Trend 2 It’s True – companies today are swimming in data. And all the while, they are spending more money to create data, store data, manage data and secure data. Plus, the Internet of Things (IoT), and the Internet of Everything (IoE)  thing, is really just getting started. Data lakes, warehouses and silos are increasingly becoming obsolete words in the modern vocabulary of data management. A new approach of data architecture that facilitates orchestrating, securing and rapidly deploying data from various structured and unstructured sources to create actionable value is emerging. When data doubles every two years, the new tools and approaches to data management, real-time analytics and actionable solutions will no longer be nice-to-have. They will be got-to-have. Business data now is now a two-edged sword, it presents an existential opportunity and an existential crisis for your company. Want to avoid the crisis and leverage the opportunity?   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…)

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

By | Database Technology Trends
The Rise of Real-Time Transactional Data   Read about Trend 1 Read about Trend 3 It seems analyst are hard at work to find the right wording that connects the promise of in-memory technology, to advanced analytics to multiple database sources, at the precise moment of transaction with the customer. Forrester calls it the odd-looking word  “translytic” as in “translytic data platforms”, Gartner uses the term “hybrid transaction / analytical processing, hopefully, HTAP for short, and IDC uses the rather straightforward “analytic transactional processing” which could mean everything and nothing at the same time. These rather athletic examples of concept mash-ups got me thinking about basketball and that maybe in-memory technology which makes it really all happen, is a point guard and that analytic engines and datasets are the centers and forwards of the game. And who was inarguably the greatest point guard in the history of the game, guy named Magic – Magic Johnson. So maybe the word the analyst are searching for is Magic… My point is, that technology and dry sounding words are not the point at all. Creating business value, creating Magic is the point. It’s when data meets analytics, meets creativity and meets the customer (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…)

April 2017 Data Connect Newsletter

By | Dobler Consulting Newsletter
  April 2017 Data Connect Newsletter View in your browser Bringing you the latest on database technology, news, and events. Announcements Join Us for Dobler’s Open House – April 6, 2017 Dobler Consulting is hosting an open house on April 6th from 4pm to 7pm. This RSVP event is for our customers, employees, vendors and friends. Join us, meet the team, network, and enjoy drinks and appetizers. If you would like to attend, please email us at events@doblerllc.com.  Events ISUG – TechSelect in NYC April 4th, 2017 Dobler Consulting sponsored April’s ISUG TechSelect Meeting. Several of our team members were in attendance to talk about SAP Data Management products including SAP ASE, SAP IQ, and SAP Replication Server. In addition to being a sponsor, Dobler’s Chris Brown, one of our Senior SAP Sybase ASE and Replication Server consultants shared a recent client success story. SQL Saturdays Dobler Consulting sponsors the SQL Saturday events to promote free training to the SQL community. We get the opportunity to share our knowledge through presentations and educate attendees on new and exciting options Microsoft introduces in their database products. If you are in the area, please join us. Click on the links below to learn more about each (more…)