You've requested...

SQL Server Insider: Tips for the SQL Server Pro Vol. 8

If a new window did not open, click here to view this asset.

Download this next:

Jargon buster guide to database management

Database management roles have long been a rich career seam for IT professionals. However, there has been, in recent years, a “Cambrian explosion” in the previously steady but sleepy world of databases.

The relational database model, breaking the traditional dependency between data storage and applications, held sway in enterprise IT for decades, from the time of its serious commercialisation by Oracle in the mid-7os. Also hegemonic has been the language implementation of the relational model, SQL – Structured Query Language; which is of the same mid-70s vintage.

But, in recent years, with the rise of the big data technologies of the Hadoop stack and the NoSQL databases, the data store and database scene has become more complex.

And when it comes to the Oracle database, its creator announced it to be “autonomous” at Oracle Open World in San Francisco October 2017. What does this mean for database administrators (DBAs)? Does it mean the opening up of new roles of higher intellectual interest and value? Or does it mean redundancy and early retirement?

As always with IT, the technology is only one-third of the story – the others being process and, crucially, people. What are the operational and organisational design problems to be solved in this more heterogenous database management landscape?

This Jargon Buster e-guide to contemporary database management is an aid to stepping back and thinking afresh about an area of enterprise IT that has many decades of heritage. Or, as many sometimes (arguably rudely) put it, legacy.

These are also closely related to: "SQL Server Insider: Tips for the SQL Server Pro Vol. 8"

  • A Computer Weekly buyer's guide to NoSQL

    There’s a lot of data out there, much of which doesn’t

    need to be stored in heavyweight relational databases complete with complex query languages. In this 13-page buyer’s guide, Computer Weekly looks at a new category of NoSQL data stores and how they are being used. 

    Discover more on: 

    - NoSQL offerings from Microsoft and Oracle

    - The suppliers behind the emergence of databases that organise web-scale datasets and the like – and the most recent set of upstarts dubbed NewSQL

    - Enterprise use cases  for NoSQL database technology

  • CW APAC: Trend Watch: Database technology

    Innovative data management offerings are improving the efficiency of enterprise operations. In this handbook, focused on database technology in the Asia-Pacific region, Computer Weekly looks at the impact of graph databases, Neo4j’s partnership with Deloitte, TigerGraph’s added security features and the different types of database management systems currently on the market.

Find more content like what you just read:

  • Why NoSQL for AI-powered apps: A guide for developers

    Modern NoSQL databases incorporate multiple data access methods and encompass a variety of models including key-value, document, column, time series, graph, text search, and AI vector search. This developer’s guide explains the many advantages that are making multipurpose NoSQL databases the developer’s choice for AI-powered adaptive applications.

    Download

  • Top 10 Azure mistakes and how to fix them

    Deploying, managing, and scaling Microsoft Azure Virtual Desktop can be a complex process for technicians at any level of experience. In this white paper, browse the top 10 most common mistakes IT professionals make in Microsoft Azure.

    Download

  • Why NoSQL for AI-powered applications: An architectural guide

    NoSQL databases are built to be flexible, scalable, and capable of rapidly responding to the data management demands of modern businesses, which means they can serve as the basis for AI applications that need ultimate adaptability now and into the future. Read this architectural guide now to learn more.

    Download

  • Inside the successful projects that rely on NoSQL database applications

    Check out this white paper for a look inside the modern challenges that NoSQL databases address, as well as when to choose NoSQL over relational and why.

    Download

  • A helpful way to map MITRE ATT&CK tactics to Azure actions

    Chasing down Microsoft Defender alerts and combing through Azure Monitor activity logs can be tough if you don’t know what to look for. To give you a jump start on investigations, this handy cheat sheet mapped the Azure services in which these tactics often originate, along with the actions attackers make to execute on these techniques.

    Download

  • 5 Steps to Ensure the Success of Your Cloud Data Migration

    How can organizations ensure they create tangible business value with a cloud data warehouse? It all starts with a plan. Business leaders need to map out a strategy and plan what to migrate, how to migrate it, and when to migrate it to maximize their investment in the cloud. Read on to learn 5 steps to leading a successful cloud migration.

    Download

  • A comparison of Azure, AWS, and Google cloud services

    AWS, Azure, and Google are all huge names in the cloud space, offering everything from big data in the cloud to serverless computing options and more. Read on for a vendor-neutral comparison of these three providers to determine which combination – if any – best fits your organization's infrastructure requirements.

    Download

  • Data integration to support modern BI and advanced analytics programmes

    In this e-guide we discuss why data integration and preparation are the unsung heroes of modern BI and advanced analytics. More so than ever, it would seem, due to the ever-increasing volume and variety of data.

    Download

  • Couchbase Data Access Patterns Guide: Building with Conduit Real World Implementation

    This guide used the Conduit Real World project to learn-by-example how to think about data access patterns with Couchbase. Conduit is a public spec of a medium.com clone, used for training, instruction, experimentation, proof-of-concept, etc.

    Download

  • Toughening up web and mobile application security

    In this e-guide, read more about the best practices for web application security, how to balance app innovation with app security, why API security needs to be part of your defence strategy, and what are the top tools to keep your applications safe, among other trends.

    Download

  • Empowering your application teams with database as a service (DBaaS)

    The shift to Database as a Service (DBaaS) marks a significant stride in cloud transformation, offering unmatched scalability, performance, and security for database workloads. Read on to learn how DBaaS can alleviate your in-house teams from the intricacies of database management, empowering them to focus on innovation and strategic initiatives.

    Download

  • A Computer Weekly buyer's guide to application modernisation

    In this 15-page buyer's guide, Computer Weekly investigates how organisations are approaching the modernisation, replatforming and migration of legacy applications. We look at the tools and technologies available, change management, and the use of APIs and containerisation to make legacy functionality to cloud-native applications.

    Download

  • Data modeling guide

    This document describes core elements you will use to model and handle data in Couchbase CapellaTM (or Couchbase Server). It describes the ways you can structure individual JSON documents for your application, how to store the documents with a Couchbase SDK, and different approaches you may take when you structure data in documents.

    Download

  • A Computer Weekly Buyer's Guide to Enterprise Open Source

    In this 13-page buyer's guide, Computer Weekly looks at open source technology. Discover more about why open source has become the infrastructure choice over commercial software; the due diligence required to reap the rewards of open source and how to choose the best fit for your needs.

    Download

  • Reduce cloud data protection TCO by up to 50%

    Download this product overview for a close look at how Dell Apex Backup Services for Hybrid Workloads can help your organization improve data visibility for your most complex information environments and reduce TCO with no hardware, no software and no complexity.

    Download

  • Provider shifts 254 servers to Azure, boosts uptime, cuts costs

    Anunta helped a business solutions provider support new clients using Azure Cloud. They migrated servers and VDI, ensuring secure access, cost optimization, disaster recovery, and compliance. Discover how they enhanced performance and agility in this Azure case study.

    Download

  • New wave BI and analytics: turning modern data stores to account

    This e-guide looks at how companies and other organisations are doing BI and analytics on the newer data stores.

    Download

  • Infographic: Comparing cloud database security

    More data than ever before is being put into cloud-based storage repositories. Leading cloud providers offer an array of storage options, yet databases remain the most common choice in today's enterprises. Because databases are updated so frequently, it's important to review their security controls regularly.

    Download

  • A Computer Weekly Buyer's Guide to Application Development and DevOps

    Harnessing the right developer tools offers new advantages for businesses. In this 14-page buyer's guide, Computer Weekly looks at the benefits and limitations of the DevOps approach, what Microsoft is doing with its developer platform and the rise of the holistic application.

    Download

  • Experience the Benefits of SaaS-Delivered Data Protection with Commvault Cloud

    In this white paper, take a close look at the security services Commvault Cloud can deliver for your organization, and find out how you can tailor your security solution to your cloud’s needs.

    Download

  • A clear SaaS vision for today’s CIOs: 5 building blocks to hybrid cloud success

    As companies are caught between the realities of cloud and on-premises, the data sprawl that ensues can create complexities that make it hard to mitigate the risk of ransomware. Download this e-book to learn about the 5 building blocks to hybrid cloud success and understand how SaaS-delivered solutions can bridge the resource gap.

    Download

  • Simplify your application modernization journey

    The longer you wait to upgrade your apps, the more difficult it becomes to execute. That’s why now is the time to figure out your modernization path so your organization can stay competitive. Read on to discover how you can leverage AI-assisted automation in your modernization efforts to reduce time to market, overall risk and total cost.

    Download

  • PKI as a service vs. legacy PKI: Understand the differences

    Along with exploring the hidden costs of legacy PKI, this infographic introduces an alternative approach to PKI management: PKI as a service. Continue on to discover six benefits of PKI as a service.

    Download

  • AWS Re:Invent 2019: What CIOs need to know from this year's show

    The Amazon Web Services (AWS) Re:Invent user conference saw 65,000 users, developers and business leaders convene in Las Vegas to hear news about the firm's innovation priorities. In this e-guide, we provide a round-up of all the big stories and announcements from this year's Re:Invent, and give readers some clues as to where AWS is heading next.

    Download

  • Developing the Intelligent Core with Windows Server 2019

    65% of European CEOs are under significant pressure to deliver on their digital transformation (DX) strategies. Creating a digital platform with an intelligent core is key to success. Learn more about digital platforms inside this resource.

    Download

  • Application security: More important than ever

    In this e-guide we look at why application security is more important than ever due to traditional software and cloud-based, web and mobile applications playing an increasingly important role in business.

    Download

  • Developer’s guide to secure coding

    This 31-page eBook provides a roadmap to secure coding in practice. Inside, find a deep dive into common software vulnerabilities, how hackers exploit them, what you need to know to prevent a breach, and more.

    Download

  • A Computer Weekly buyer's guide to secure and agile app development

    As apps become increasingly integral to business operations, the importance of keeping them secure can never be overstated. In this 15-page buyer's guide, Computer Weekly looks at how firms can protect apps from ransomware, why app creation needs to happen at pace, and how to get the right balance between security and coding

    Download

  • Web security: Important but often overlooked

    In this e-guide we take a look at the different approaches you can take in order to bolster your web security. We find out how to identify and address overlooked web security vulnerabilities, how security controls affect web security assessment results and why web opportunities must be met with appropriate security controls.

    Download

  • Application security: best practices and risks

    Security professionals need to anticipate vulnerabilities from all the right perspectives, and that means testing apps for flaws on a regular basis, whether that means monthly, quarterly or following updates. Check out this e-guide, which include application security best practices, threat identification and security testing tips.

    Download

  • Putting the SQL back in NoSQL

    Do you like the familiarity of SQL, but need the speed and flexibility of JSON data to build your modern applications? In this webcast, Couchbase shows you how to get the best of both worlds from a single NoSQL database that takes advantage of SQL++, the de facto standard for applying SQL to JSON data. Tune in now to learn more.

    Download

  • Mitigate these 3 risks to container & IaC security

    Along with highlighting 3 prevalent risks to container and IaC (infrastructure as code) security, this e-book instructs readers on how to mitigate those risks with a holistic approach to security. Continue on to unlock these insights.

    Download

  • An inside look at AstraZeneca’s IT

    In an industry where speed is everything, growing technology bottlenecks can hold you back. In this case study, learn how AstraZeneca adopted cloud automation technology, updated their provisioning, and improved compliance with the help of Morpheus Data. Read the study here.

    Download

  • Computer Weekly – 3 October 2017: Digitally preserving history

    In this week's Computer Weekly, we find out how cloud technologies are helping Gibraltar to digitally preserve historic documents and safeguard its cultural heritage. We examine progress on the roll-out of the new NHS national network. And our latest buyer's guide looks at cloud-based ERP software. Read the issue now.

    Download

  • Guinness World Records Goes "all in" on AWS to Manage Transformation Into Digital Media Company

    Watch this video clip to learn how Guinness World Records is leveraging their new cloud host to aid in their organization-wide digital transformation.

    Download

  • What Veeam Backup & Replication is delivering for public cloud providers

    Veeam Backup & Replication v11a is delivering many new capabilities for all of the major hyperscale public cloud providers: AWS, Azure and Google Cloud. Watch this webinar for an interactive technical discussion and live demos with cloud experts to learn about everything that is new for AWS, Azure and Google Cloud.

    Download

  • UK IT Priorities 2019

    The results of our 2019 IT Priorities survey are in, and they show the good news that IT budgets are rising faster than they have for many years. Cloud remains the top spending priority for this year, but IT automation is growing fast as a major investment area.

    Download

  • UK IT Priorities 2019

    The results of our 2019 IT Priorities survey are in, and they show the good news that IT budgets are rising faster than they have for many years. Cloud remains the top spending priority for this year, but IT automation is growing fast as a major investment area.

    Download

  • How Dell & Microsoft combine to deliver SQL server efficiency

    Between multi-cloud, on-premises and edge environments, the complex modern IT landscape is a breeding ground for challenges. Read this blog to learn how Dell’s as-a-service approach to Microsoft SQL Server modernization blends Kubernetes automation, elastic scaling, and enhanced data storage to accelerate digital transformation initiatives.

    Download

  • With InterSystems Financial Services Suite, data silos are a past relic

    Consider the challenges and barriers (such as silos and time-intensive data validation processes) to effective financial services data management in this InContext Paper by Bloor. You’ll also understand how InterSystems Financial Services Solution Suite resolves these issues with a 360-degree view of enterprise and customer data.

    Download

  • Reducing carbon footprint and Azure costs with Nerdio

    In this case study, discover how a global leader in recycled metal products made the switch to Nerdio to improve user management and deployment efficiency, while shaving more than $3,000 each month off its Azure bill.

    Download

  • Activate real-time insights

    This white paper discusses the challenges of creating value from data at the edge and how HPE can help you take action to accelerate data insights, results, and value. Access the paper to learn how to supercharge applications so you can act in real-time and analyze data from all your sources using a data fabric to unify analytics.

    Download

  • How to choose a database for your mobile apps

    Consumers rely on mobile applications, even when there is no internet connection. To help you provide the always-on experience customers demand, database solutions like Couchbase Mobile have added synchronization and offline capabilities to their mobile database offerings. This white paper helps you choose the best mobile database for your needs.

    Download

  • A Computer Weekly buyer's guide to Asset Management for Hybrid IT

    Hybrid IT opens up a range of new considerations for businesses. In this 14-page buyer's guide, Computer Weekly looks at how to manage its infrastructure, the importance of cost management and the main considerations to make when addressing cloud management issues.

    Download

  • What data security looks like in 2024

    These days, your sensitive data likely exists in multiple places, both outside of and within your company. How can you ensure that your data is safe in all its locations? Check out this overview to learn how a data security posture management solution can help.

    Download

  • CW APAC, February 2021: Buyer’s guide to data management

    In this handbook, focused on data management in the Asia-Pacific region, Computer Weekly looks at best practices, Alibaba’s use of databases, the role of artificial intelligence in handling information and data trends to look out for

    Download

  • A Computer Weekly buyer's guide to big data

    Companies are switching on to the advantages of big data. In this 13-pagebuyer's guide, Computer Weekly looks at data analytics, how to get value out it and the benefits of process mining.

    Download