Security

Protect Your Cloud Database with Top Strategies for Cloud Security

By | Security
Database and data security are major concerns for most organizations, with good reason. Bad actors are pervasive in our interconnected environment and staying one step ahead takes strategic planning and active management. With more and more databases hosted in the cloud, organizations must be particularly aware of the security risks and data protection strategies available. According to the 2019 Cloud Security Report from Synopsys, 93% of organizations reported being “moderately or extremely concerned about cloud security.” This is understandable, but this concern doesn’t outweigh the benefits of utilizing a cloud or hybrid infrastructure. Instead, the important focus should be on developing and maintaining a robust security strategy, identifying top products and service providers, and taking a proactive stance in your data security platform. Selecting a Secure Cloud Provider – One of the first steps in establishing and maintaining a secure cloud database for your company is identifying the best provider for your needs. Going with a well-established service provider, like Microsoft or Oracle, means peace of mind knowing that the company has an established record of industry-leading security practices. Saving a few dollars on the front end with lesser known providers is just not worth it if it opens up (more…)

Simplify Data Management with Azure Data Studio

By | Azure
Azure is well known as one of the industry’s leading cloud providers, offering exceptional security, business management, and analysis tools in affordable packages. In this article we take a look at one of the best tools for editors and DBAs, the Azure Data Studio. This resource, formerly known as SQL Operations Studio, is a platform for building and editing your SQL queries with useful tools and an intuitive UI. If you are looking for a tool to seamlessly integrate your query editing with your database management, look no further than Azure Data Studio. This cross-platform tool makes managing your database, objects, and queries easier than ever. Initial Release and Rebrand – This product was released for public preview nearly 2 years under the name of SQL Operations Studio, and last fall was released for general availability (GA) under the new name, Azure Data Studio. Some customers questioned whether the Azure heading would pose problems for on-prem SQL infrastructures. The answer is no. Microsoft is dedicated to supporting all instances of SQL Server and related database products, including on-premises and hybrid infrastructures. This means that whether you are hosting on site SQL Servers or utilizing the Azure Cloud infrastructure, you can (more…)
Oracle Gold Partner

What’s New in Oracle’s Database 19c

By | Oracle
Oracle is one of the leading providers of database services with decades of experience at the top of the pack. Their new product releases are always exciting to watch, improving upon their legacy of client-focused products and services. Last year they released database 18c, the first of a new annual release schedule, that featured the revolutionary Autonomous Cloud database along with Multitenant Architecture, In-Memory Columnar Architecture, and Native Database Sharding. This year’s database 19c continues to build on the foundations set in previous years with a focus on stability and efficiency. If you are thinking about upgrading or migrating to Oracle’s database 19c, here are a few special features to expect in this newest version. New Features in 19c This database version comes with some exciting enhancements to make your job faster and easier. While the main focus of this development cycle has been on stability, there are a few new features focused on automating and optimizing for the client. Let’s look at a few of these enhancements. Automatic Indexing – Indexing items takes time and can mean a lot of busywork for your IT team. With Automatic Indexing, Oracle’s 19c uses machine learning algorithms to identify items, map and (more…)

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

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

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

What You Need to Know to Migrate Your Oracle Database to the Cloud

By | Oracle
Many organizations are making the switch from on-prem to cloud databases. These cloud native warehouses can provide more reliable and timely access, cost-efficiency, and automated backup and recovery. If you are using any on-premises version of Oracle Database, you might want to consider whether moving to the Oracle Database Cloud is right for your company. There are numerous migration methods, and the process can be very simple when you work with an expert. Try reviewing these key factors prior to selecting a migration method and save yourself some additional time. Know Your On-Premises Operating System/Platform and Version – Ensure you have a full understanding of the platform your company is currently working on along with the version. Are you using Windows, Mac OS, or Linux? There are some operating requirements that will be applicable depending on the migration method you are interested in adopting. Know Your On-Premises Database Version & Cloud Database Version – Are you currently using Oracle Database 11g, 12c CDB, or 12c Non-CDB? Depending on your response and the cloud version you are transferring to, Oracle has multiple migration options for you to choose from. For example, a move from on-premises Oracle Database 11g to Oracle Database (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…)