Databases in the Cloud
Technology leaders are being inundated with a flood of new cloud architectures, strategies and products – all guaranteed by vendors and various industry pundits to solve all of our database challenges. The seemingly endless array of public cloud based DBMS offerings can quickly become bewildering. This article is intended to peel back the veil of cloud based DBMS offerings by providing readers with our experiences with cloud based database architectures.
Those who excel at tuning understand that the tuning process starts with an understanding of the problem and continues with the administrator collecting statistical information. Information collection begins at a global level and then narrows in scope until the problem is pinpointed. This article provides hints and tips that can be used to determine what architectural component is causing the problem.
We learned in previous articles that it takes more than just being a great technician to keep your customers happy. The theme of this series is that if you want to be viewed as a strategic resource in your organization, being a technical expert isn’t enough. Because of the trade you have chosen, the DBA position provides you with an excellent opportunity to play a more strategic role in your organization.
This is Part 4 of a series that compares in-house personnel, consultants and remote DBA service providers. In Part 1, we talked about the cost reduction benefits that remote DBA service providers offer customers. In Part 2, we discussed service continuity and quality as well as the flexibility benefits customers receive when utilizing a remote DBA service provider. In Part 3, we reviewed the benefits of collective knowledge and deep dive subject matter expertise.
In part 4 of the Remote DBA Benefits Comparison Series, we’ll discuss how remote DBA providers deliver personalized services to customers. I use RDX’s service delivery approach as an example of how remote DBA providers can exceed the quality of work performed by in-house personnel or consultants.
This is Part 3 of a series that compares in-house personnel, consultants and remote DBA service providers. In Part 1, we talked about the cost reduction benefits that remote DBA service providers offer customers. In Part 2 we discussed service continuity and quality as well as the flexibility benefits customers receive when utilizing a remote DBA service provider.
In this installment of the series, we’ll focus on the collective knowledge benefits and subject matter expertise remote DBA service providers offer clients. I use my organization, RDX, as an example.
In part 1, we talked about the cost reduction benefits that remote DBA service providers offer customers. In part 2 of the Remote DBA Benefits Comparison Series, we’ll discuss the continuity and quality of service and support flexibility benefits customers experience when utilizing a remote DBA service provider. We’ll also compare these benefits to in-house and consulting alternatives.
I’ve been working in the IT profession for close to 30 years now. In virtually all facets related to database administration, I’ve had the good fortune of performing a fairly varied set of tasks for my employers over the last couple of decades.
The theme of this series of articles is that if you want to be viewed as a strategic resource in your organization, being a technical expert isn’t enough. Because of the trade you have chosen, the DBA position provides you with an excellent opportunity to play a more strategic role in your organization.
As a DBA, it takes more than just being a great technician to keep your customers happy. There are dozens of database experts that are willing to provide you with their own technical administration best practices. In this series, I intend to round out your knowledge to make you more than just a good administrator. And I have a news blast for you: if you want to be viewed as a strategic resource, being a technical expert isn’t enough.
SQL Saturdays are free, one-day training events and are held in cities worldwide throughout the year. Hundreds of SQL Server professionals attend to hear presentations by those highly regarded in the field and to learn best practices associated with their trade. Since speaking sessions range from beginner to advanced levels, professionals of all levels are encouraged to attend. There are also a variety of networking opportunities available such as pre-conference sessions in select cities and after parties.
As the modern database continues to grow, its inherent feature set expands alongside it. More solutions allow remote DBAs and internal teams alike to solve business problems tied to cutting costs and improving efficiencies. However, with these solutions comes increased complexity surrounding database administration, and it falls on the shoulders of DBAs to understand and leverage the industry’s evolving technologies.
RDX is pleased to announce the launch of our MongoDB NoSQL database service offering. NoSQL architectures have been gaining an increasing amount of attention from the IT community. Many organizations now consider NoSQL offerings to be standard infrastructure choices for new database-driven application implementations.
When we compare relational and NoSQL Systems, one of the critical analyses we have to perform is data access mechanisms. As we’ll learn over the next few articles of this series on data access, the SQL language used by relational database management systems is much more feature rich and powerful than its NoSQL counterpart. This statement isn’t intended to sway readers to relational systems, it is just the author’s evaluation of both systems’ access languages.
Designing, building and maintaining highly available (HA) architectures is the key to providing end users with 24x7 access to mission-critical applications. From the financial services sector to higher education, organizations require their databases be online and readily accessible. When these critical applications become unresponsive or performance is hindered, the resulting downtime can have extreme consequences. With the potential for legal penalties, bad press, loss of customer goodwill and other repercussions looming, DBAs must constantly focus on ensuring their systems are highly available, quickly recoverable and protected from natural or human-induced disasters.
As the modern database continues to evolve and take on a more strategic role in business, the complexities associated with managing these environments grows as well. For database administrators, this changing landscape forces them to continuously adapt and grow alongside the database engine to properly design, support, and secure an enterprise’s critical data stores. Their in-depth knowledge of the infrastructures so crucial to operations make DBAs an integral part of not only day-to-day functions, but business decisions aimed at reducing operation costs, improving margins, and more.
Welcome back to part 2 of MDX Code Development for Beginners. In part 1, we looked directly at the basic SELECT FROM clause in T-SQL and converted it to the SELECT ON COLUMNS ON ROWS FROM which is the equivalent in MDX. In part 2 we will be looking into the different BASIC filters that can be introduce into the SELECT statement in comparison to T-SQL “WHERE” clauses.