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

  • 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.

Find more content like what you just read:

  • CW APAC: Trend Watch: Database technology

    In this handbook, focused on database technology in the Asia-Pacific region, Computer Weekly looks at the impact of graph databases and the different types of database management systems currently on the market.

    Download

  • 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

  • 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

  • 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

  • Evaluate AWS and SourceFuse for running your Microsoft workloads in the cloud

    In this e-book, you’ll find answers to the top 10 questions customers have when running Microsoft workloads on AWS—ranging from the key benefits AWS offers, to the licensing, migration, and optimization options for your Windows Server, SQL Server, and .NET workloads.

    Download

  • Top 10 reasons customers migrate Microsoft workloads with SourceFuse

    This paper provides answers to the top 10 questions customers have when running Microsoft workloads on AWS—ranging from the key benefits AWS offers, to the licensing, migration, and optimization options for your Windows Server, SQL Server, and .NET workloads.

    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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • How to analyze your ever-growing datasets

    How can organizations analyze their ever-growing datasets? This white paper details one approach: using cloud instances powered by 4th Gen AMD EPYC processors. Keep reading to access a twelve-page guide to the strategy.

    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

  • 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

  • NoSQL operational database solution

    In this product overview, you’ll discover a multi-model real-time NoSQL database powered by a unified storage engine format that is designed to give architects, developers, and DevOps the tools they need to make faster, more informed decisions. Read on to gain a deeper understanding of its features and capabilities.

    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

  • The optimal path for migrating your Windows systems to AWS

    Read this paper to learn how working with an AWS Premier Tier Services Partner can help your organization reduce risk, lower or eliminate your Windows licensing costs and fully optimize your business on AWS.

    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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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 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

  • 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

  • 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