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.