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

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

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

Improving your Database Security with Microsoft Azure

By | Azure
If you are interested in migrating to a cloud database but concerned about security issues, look no further. Hybrid and cloud native databases do have their own set of security concerns, but if you go with a trusted company and maintain it appropriately, you have nothing to fear. In fact, cloud databases can be more secure since they have access to the most advanced security protocols and automatic updates. Cloud native databases, or DBaaS (Database as a Service) platforms are databases hosted and maintained by third party providers. Operating a DBaaS means that your company will access data through the internet instead of through your internal network. DBaaS solutions offer great benefits for organizations in today’s “Big Data” arena. DBaaS is more scalable and flexible than traditional VM databases. It also eliminates the hardware requirements of maintain a database system. It is crucial to understand and trust the security protocols of your cloud provider before making the switch. Microsoft Azure is at the top of the list when it comes to cloud database offerings. It is a particularly good choice for the security conscious client. Microsoft in general, and particularly Azure, have a long history of prioritizing security for its (more…)

5 Ways MS SQL Server Enhances Data Integrity

By | SQL Server
We’ve entered a time in which high quality data is at the heart of operating a successful organization. For many companies these days data IS the business. For others, data is a driver. In both scenarios its critical to maximize your data’s efficacy, and this means being sure you can trust that data. I’m talking about data integrity. It’s essential to be able to trust your data, and that means using a database you can trust that is actively working toward ensuring your data.  Microsoft SQL is a longstanding leader in the game. Their database offers top of the line stability and data integrity. If you are concerned about ensuring your data integrity this database might just be right for you. Why Microsoft SQL Server? – Microsoft SQL Server 2019 features upgrades that will give your organization greater access to large amounts of valuable data quickly. Once it’s released, querying multiple sources of data, both structured and unstructured, will be simpler and more secure than ever. MS SQL preview CTP 2.0 is now available in preparation for the upcoming official release. If you’re interested in experiencing some of the new features beforehand, consider downloading it soon. In the meantime, here (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…)

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

Cloud Security with Oracle’s Identity SOC

By | Oracle
Databases are high value targets. 76% of organizations have experienced a security incident.[i] Add that to the semi-novelty and porosity of the cloud, and it’s no wonder you’re a little nervous about security. If you’re not concerned, you’re not paying attention. But the best products out there are designed to help reduce your workload and bring peace of mind. Oracle’s cloud security protocols do just that. The innovative Security Operations Center gives you visibility, control and intelligent detection with less oversight. Oracle’s SOC Oracle’s Identity Security Operations Center (SOC) is comprised of several offerings to create a comprehensive security system for cloud, on-premises and hybrid environments. It takes Oracle CASB Cloud Service, Oracle Identity Cloud Service, Oracle Security and Monitoring Analytics Cloud Service, and Oracle Configuration and Compliance Cloud Service and rolls them into one package. Let’s look at some key features. Identity-Based – Network-centric security just doesn’t cut it anymore with the rapidly diversifying landscape of platforms and users. With more and more people accessing SaaS from mobile devices, you need a more intelligent way to monitor threats. Identity-based security uses machine learning and AI to detect patterns in user activity and target potential threats. Oracle’s Security Operations Center (more…)

Data Science: Making the Most of your Big Data

By | Azure, Database Technology Trends, Oracle, SQL Server, Sybase
As today’s trends bring more and more data to our fingertips, the next challenge is figuring out what to do with it all. The insights gained from proper data analysis have major implications for business. Proper data analysis takes careful consideration, appropriate infrastructure, and understanding of data science. What is Data Science? This is the process of using data to draw conclusions or predict outcomes. You probably use data science already. For example, a restaurant owner may keep records of which dishes are ordered. Over time, he may notice that chili is ordered more frequently on rainy days than on sunny days. This may encourage him to prepare larger batches of chili when the weather calls for rain. This is a very simple example of data science. You can see how understanding patterns and trends in data can help prepare your business. Data science can contribute to the following business improvements: Streamline Processes – You can use data science to analyze your business processes and identify areas to streamline. Looking at your website usage statistics may show areas where your potential clients are losing focus, or identify slow and frustrating pages in your online ordering forms. Identifying these patterns can (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…)