Chris Foot

Subscribe to Chris Foot feed
RDX, the Remote Database Experts provides tips and information for database administration and other topics related to remote DBA services.
Updated: 2 hours 56 min ago

Remote DBA Benefits Comparison Series- Cost Reduction

Thu, 2016-06-23 10:30

Introduction

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 DBA Best Practices Series- Maximizing Your Organization's Database Technology Investment

Wed, 2016-06-22 08:12

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.

The DBA Best Practices Series- Becoming a Strategic Resource, Not Just a Utility Provider

Fri, 2016-05-20 06:27

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: Learn Where You Can See Presentations by RDX SQL Server Experts

Fri, 2016-04-22 12:10

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. 

How RDX Remote DBAs Stay on Top of Evolving Technologies

Thu, 2016-04-14 08:00

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 MongoDB Service Launch Announcement

Wed, 2016-04-06 08:00

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. 

The NoSQL- Relational Comparison Series Continues- Relational SQL vs MongoDB Methods

Tue, 2016-03-29 09:01

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.  

Using Remote DBA Support to Achieve High Availability

Fri, 2016-03-18 08:57

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.

The Most Important Responsibility of a Remote DBA

Wed, 2016-03-02 08:00

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.

Part 2: MDX Code Development for Beginners

Mon, 2016-02-29 08:30

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.