Implementing Database Mirroring with Microsoft SQL Server 2005
By: DellEMC and Intel® View more from DellEMC and Intel® >>
Download this next:
Power Up Your Databases: The MS SQL Server Workout
By:
Type: Replay
Welcome to: Power Up Your Databases: The MS SQL Server Workout Become a database powerhouse without the heavy lifting SQL Server database administrators face a long list of challenges: improving database performance, hardening security, lowering costs, increasing availability, preparing for disaster recovery – the list goes on and on. And DBAs need to address these challenges while staying on top of time-consuming every-day tasks such as migration and copy data management for test and development. Even with evenings and weekends thrown in, it can feel like there aren’t enough hours to get it all done. The good news is that these tasks can be dramatically simplified and streamlined! Join database experts from Nutanix to learn how using a consolidated, cloud-agnostic virtualization platform and modern database management solution can dramatically reduce the time spent on repetitive manual tasks to support SQL Server, giving the DBAs back the time, they need to focus on more valuable work. They’ll cover how easy it is to deploy standardized and hardened versions of SQL Server, migrate from end of support versions like SQL Server 2008 R2, automate database copy and refresh operations for your developers and more. If you want to learn how to free up the evening and weekend time taken up by SQL Server support, this is the webinar for you! Featuring: Mike McGhee, Director, Technical Marketing Engineering, Nutanix David Teague, Technical Marketing Engineer, Nutanix
These are also closely related to: "Implementing Database Mirroring with Microsoft SQL Server 2005"
-
Databridge Customer Briefing
By:
Type: Video
Micro Focus Databridge enables organizations to leverage and integrate the value of their DMSII data with other information systems for business analytics and operational purposes. Databridge is an out of-the-box extract, transform, load (ETL) solution that securely mirrors DMSII and non-DMSII data with secondary working databases while keeping data updated in real time. Databridge fits seamlessly into your existing infrastructure with support for Oracle, Microsoft SQL Server, and flat file target clients, running on a range of operating environments including Windows Server, UNIX, AIX, SUSE Linux, and Red Hat Linux.
-
Your Personal Database Time Machine: The SQL
By:
Type: Video
What’s New with MS SQL Server & Pure Storage? This month, host Andrew Miller will invite SQL DBA and Microsoft MVP Anthony Nocentino to the virtual break room to discuss all things SQL Server landscape, SQL Server 2022, and Pure Storage. Our 45-minute chat will cover: -Anthony’s history as an independent SQL consultant, conference organizer, Pluralsight course author, & why he’s now at Pure. -The SQL Server Landscape & new storage-related features in SQL Server 2022 -How to use storage-based snapshots to restore a database, copy a database, and seed an Availability Group replica, all nearly instantaneously. -S3 & SQL Server - yes, they can go together and why you’d want to do so. -How Pure Storage makes SQL Server environments better Join us for a great conversation whether you’re a DBA or just someone who wants to learn more about what the DBA’s in your life care about.
Find more content like what you just read:
-
Unleashing the Power of SQL Server
By:
Type: Replay
Imagine simplifying and automating the time-consuming activity of SQL Server management with automated provisioning or patching, where one-click simplicity allows you to clone/copy SQL server databases that are TBs in size in just a few minutes. Leveraging snapshot technology, Era captures all database states for any given service-level agreement (SLA) and allows DBAs to not only create fully functional database clones but also refresh existing ones using one-click operations. Nutanix Era is revolutionizing the database experience for lifecycle operations with provisioning, patching, and managing databases from day 0 to day n. Attend this session to learn how to deliver and take advantage of database as a service (DBaaS).
-
Unleashing the Power of SQL Server
By:
Type: Replay
Imagine simplifying and automating the time-consuming activity of SQL Server management with automated provisioning or patching, where one-click simplicity allows you to clone/copy SQL server databases that are TBs in size in just a few minutes. Leveraging snapshot technology, Nutanix Era captures all database states for any given service-level agreement (SLA) and allows DBAs to not only create fully functional database clones but also refresh existing ones using one-click operations. Nutanix Era is revolutionizing the database experience for lifecycle operations with provisioning, patching, and managing databases from day 0 to day n. Attend this session to learn how to deliver and take advantage of database as a service (DBaaS).
-
FortanixDatabase Encryption: Simplifying Security Across Global Databases
By:
Type: Video
In this webinar, we will be covering the following topics: -How to manage encryption and keys across multiple databases. -Setup and configuration of TDE for Oracle Database 19c. -Encrypting cells, rows and the entire database using Microsoft SQL Server. -Securing NoSQL databases with TDE, demonstrated with MongoDB.
-
Supercharging & Protecting Databases with FlashBlade & Object Engine
By:
Type: Video
As enterprises evolve and modernize their database platforms, the need for resiliency and recoverability becomes ever more critical. Join us as we turbo-charge critical database architectures such as Microsoft SQL Server, Oracle Database, and MySQL with the unprecedented throughput and test/dev capabilities of Pure Storage FlashBlade.
-
Lower Database Costs and Innovate Faster with Cloud SQL
By: Google
Type: Video
Migrating apps to the cloud presents a unique opportunity to enhance security, reduce costs, and simplify operations for your business. Whether your apps are built on open source or commercial databases, our managed database service, Cloud SQL, is designed to accelerate your ability to innovate and streamline your migration to the cloud. Join our webinar to hear directly from Google Cloud Databases Product Manager Isabella Lubin on how to migrate and modernize your apps with Cloud SQL. You’ll discover: How Cloud SQL enables innovation with your choice of MySQL, PostgreSQL, and SQL Server database engines The ways Cloud SQL reduces risk with industry-leading observability, data protection, and governance made easy How real customers have increased availability and cost efficiency since making the move
-
Lower Database Costs and Innovate Faster with Cloud SQL
By: Google
Type: Replay
Migrating apps to the cloud presents a unique opportunity to enhance security, reduce costs, and simplify operations for your business. Whether your apps are built on open source or commercial databases, our managed database service, Cloud SQL, is designed to accelerate your ability to innovate and streamline your migration to the cloud. Join our webinar to hear directly from Google Cloud Databases Product Manager Isabella Lubin on how to migrate and modernize your apps with Cloud SQL. You’ll discover: - How Cloud SQL enables innovation with your choice of MySQL, PostgreSQL, and SQL Server database engines - The ways Cloud SQL reduces risk with industry-leading observability, data protection, and governance made easy - How real customers have increased availability and cost efficiency since making the move
-
Database Encryption for Government- High Assurance and Compliance
By:
Type: Video
Thales and Microsoft will discuss high assurance database encryption for Government Microsoft SQL Server users. Learn how to: • Enhance the security of your Microsoft SQL database using built-in TDE and the extensible key management feature • Achieve operational ease with centralized key management in a scalable manner across multiple databases • Simplify regulatory compliance by protecting critical master keys in certified hardware with advanced separation of duties capabilities
-
Exploring DBaaS Options for Microsoft SQL Server
By:
Type: Talk
In this webinar, we will use an example database environment setup to evaluate the DBaaS options from Silk, Microsoft Azure, Google Cloud, and Amazon Web Services. The example database setup will be a Microsoft SQL Server environment that we would like to move from on-premises to the cloud in a managed capacity. Using this example environment, we will compare features like flexibility, data management, DBA support, and cost efficiency. This webinar is Part 2 in a series on DBaaS. Other topics in this series include a checklist of considerations for adopting DBaaS for databases like Microsoft SQL Server and Oracle, and exploring the Total Cost of Ownership (TCO) of DBaaS with Silk.
-
Enterprise application platform modernization with commercial Linux
By:
Type: Replay
Applications are at the heart of modern enterprises and organizations must constantly evolve their application strategy to be successful in expanding their competitive differentiation. Their applications portfolio must be constantly infused with new generation applications that run in cloud environments, are delivered as microservices, use open source technologies, and are increasingly platform (infrastructure) independent. For applications to be scalable and highly available, they need an underlying database management system like Microsoft SQL Server and a versatile operating system (OS) environment such as Linux®—as an ideal platform for consolidating applications and their respective data management stacks. Leaders focused on their IT business have a lot of concerns, but starting with a solid foundation is the right start for a sound infrastructure. IDC and Red Hat partner up in this session to discuss industry insights and information that will demonstrate why Linux is the adopted choice for hosting Microsoft SQL Server. Is your Microsoft SQL Server database running on an OS that allows you to modernize with a strong security presence? Join us as IDC and Red Hat take a more comprehensive look at the different values organizations see by running their Microsoft SQL Server database on Linux, specifically Red Hat® Enterprise Linux.
-
Backups, Snapshots, Microsoft SQL Server, and FlashArray
By:
Type: Video
Backing up systems is not optional for any environment. For those using Microsoft SQL Server, that also means considering databases to ensure you meet recovery point objectives (RPOs). In this TechTalk, we will discuss traditional SQL Server backups and their strategies versus snapshots in FlashArray as well as address common questions and concerns when using snapshots including, but not limited to: How are snapshots both different as well as similar to a traditional SQL Server backup? What are the use cases for both? When should you combine for a more robust disaster strategy? Whether you are a DBA, storage admin, or just someone responsible for SQL Server on FlashArray, attend this TechTalk to not only take advantage of what FlashArray offers, but also ensure you have the right backup and recovery/restore strategy for your SQL Server deployments.
-
Backups, Snapshots, Microsoft SQL Server, and FlashArray
By:
Type: Replay
Backing up systems is not optional for any environment. For those using Microsoft SQL Server, that also means considering databases to ensure you meet recovery point objectives (RPOs). In this TechTalk, we will discuss traditional SQL Server backups and their strategies versus snapshots in FlashArray as well as address common questions and concerns when using snapshots including, but not limited to: How are snapshots both different as well as similar to a traditional SQL Server backup? What are the use cases for both? When should you combine for a more robust disaster strategy? Whether you are a DBA, storage admin, or just someone responsible for SQL Server on FlashArray, attend this TechTalk to not only take advantage of what FlashArray offers, but also ensure you have the right backup and recovery/restore strategy for your SQL Server deployments.
-
Delivering cloud flexibility with Microsoft SQL Server on AWS
By:
Type: Replay
A recent survey, Linux Becomes a Player in the SQL Server World: PASS 2021 Survey on Microsoft SQL Server Platform Trends, by Unisphere Research, states that nearly one-third of SQL Server Database Administrators (DBAs) are running Microsoft SQL Server on Linux®, with the most popular distribution being Red Hat® Enterprise Linux. The same survey shows that we can expect the amount of SQL Server maintained in the cloud to double over the next two years. In this webinar, Amazon Web Services (AWS) and Red Hat will demonstrate how you can transition to SQL Server on Red Hat Enterprise Linux on AWS and benefit from increased flexibility, performance, and availability of a modern cloud platform. In this webinar, we will cover how to: Reduce costs by deploying SQL Server on Red Hat Enterprise Linux on AWS Use Red Hat Enterprise Linux to deliver SQL Server performance and availability on AWS Select the appropriate Amazon Elastic Compute Cloud (Amazon EC2) instances and options for your SQL Server workloads
-
Bring Untouchable SQL Workloads into Azure
By:
Type: Video
While many companies are adopting the cloud, there are some workloads that are considered too large, too complex, and require too much performance to make the jump. These workloads – which are often databases like Microsoft SQL Server or Oracle Database – are considered “untouchable” and are often the only thing keeping a company on-premises. In this webinar, we talk about bringing these “untouchable” SQL workloads successfully to Azure while getting fast performance they need and de-risking the cloud migration process. This webinar discusses: What characterizes untouchable SQL workloads What this means for the cloud providers Examples of customers who have successfully adopted the cloud for SQL workloads How Silk can help your organization get these workloads into Azure
-
It’s the Database. Or Is It? Put an End to Finger Pointing!
By:
Type: Replay
As a DBA, it can be frustrating to get assigned a ticket suggesting something is wrong with the database, and after you spend the time you don't have, it becomes clear it wasn't the database at all. It was the underlying infrastructure, network, etc. In this video, we show how SolarWinds® Server & Application Monitor (SAM) can enable your IT team to monitor the health and availability of your Microsoft® SQL Server and other database instances. SAM in the hands of your IT support and monitoring teams provides broad visibility across the stack. It can make it easy for the team to identify the underlying cause for database availability and performance problems. SAM gives you visibility to the underlying elements with an impact on database availability and performance. It also looks up at the applications the databases are supporting, helping eliminate wasted time and resources, finger-pointing, slow time to repair, and unhappy customers.
-
Simplify Database Management and Make Open-Source Database Adoption a Reality
By:
Type: Video
Your developers want to use open-source databases to support the modern applications they are building. But your DBAs are having a hard enough time manually administering your growing commercial database fleet. How do you provide developers with the open-source databases they need while not overwhelming your DBA team? Better yet, how do you do so while lightening the administrative burden on your DBAs so they can not only manage all the databases under their charge – commercial and open source - but actually free up time so they can focus on higher value activities? The answer is Nutanix Database Service (NDB). NDB is the only Database-as-a-Service that simplifies and automates database lifecycle management across on-premises and public clouds for Microsoft SQL Server, Oracle Database, PostgreSQL, MySQL, and MongoDB databases. With NDB, simplify database management while delivering secure, consistent database operations, free up DBA time to focus on higher value activities, and make databases – both commercial and open source – a seamless part of software development. In this webinar for development and platform leaders, you will learn … ● How NDB provides a single, seamless user experience for provisioning and managing Microsoft SQL Server, Oracle, PostgreSQL, MySQL, and MongoDB databases across on-premises, public clouds, and co-location facilities. ● How NDB automates database lifecycle management - including provisioning, scaling, patching, and cloning databases - to ensure operational and security best practices are applied across your entire database fleet. ● How NDB enables you to provide developers with a menu of secure, approved database options - including open source databases like PostgreSQL and MongoDB - and lets developers self-service provision databases in minutes to speed software development.
-
Securing your global databases with Transparent Database Encryption
By:
Type: Video
Join John Wyss (VP, Product, Fortanix) and Joe Davenport (Sales Engineering, Fortanix) will demonstrate how Fortanix Data Security Manager is helping companies to implement database encryption more broadly at the cell, column, row, table, and entire database levels, in response to the proliferation of data privacy regulations, the increasing risk of a data breach, and the migration of databases to public cloud - across common types of an enterprise database. This webinar will give you insights into: How to manage encryption and keys across multiple databases. Setup and configuration of TDE for Oracle Databases. Encrypting cells, rows, and the entire database using Microsoft SQL Server. NewSecuring NoSQL databases with TDE, demonstrated with MongoDB.
-
Mastering SQL Server: The Art of Smart Automation
By:
Type: Replay
The adoption of containerization and orchestration platforms, such as Kubernetes, has grown quickly as DevOps teams look to build scalable and resilient applications. Container environments consist of many moving parts. For example, in a busy application environment, hundreds of pods, the smallest execution unit in Kubernetes, are continuously being launched and decommissioned. In this complex and dynamic environment, monitoring the health of your application infrastructure and troubleshooting issues can quickly become challenging. Between resource allocation issues that can cause pod eviction events, an unexpected termination scenario due to a spot instance availability, or CrashLoopBackOff errors arising from missing dependency that results in repeated failed launches; the sheer scale and complexity of a Kubernetes-back application requires more than standard monitoring and alerting to ensure optimal performance and health. However, automation done well is more than just setting a SQL Agent task to take nightly database backups. Smart automation incorporates aspects of monitoring enabling your automations to respond dynamically and flexibly to the situation at hand. You have a lot of choices in how you automate your workflows in SQL Server. There are tools to help you write your automation code, products to set-it-and-forget-it, and everything in between. Join Database Evangelist Kevin Kline to discuss where monitoring ends and automation begins. In this session, you’ll learn: • How database automation and better monitoring can support trouble-free operations • Which tasks should you consider automating, on which servers, and in which order? • The difference between PowerShell/korn/bash scripting, Microsoft CoPilot for SQL Server, Power Automate, DIY scripting, and an enterprise product • Resources available to you to continue to learn about SQL Server automation Join us to learn more about the world of SQL Server automation from experts in the field.
-
Better together! Red Hat Solutions and Microsoft SQL Server on Linux in Azure
By:
Type: Talk
Back in 2017, Microsoft generated a lot of industry excitement by making SQL Server available on Linux. Today, Red Hat Enterprise Linux, Red Hat OpenShift, Red Hat Smart Management, Red Hat Ansible Automation, and Red Application Services all integrate with Microsoft SQL Server resulting in the world’s most popular commercial database on the most popular enterprise Linux and container platforms. Join us to learn how Microsoft and Red Hat developments can help you accelerate delivery of your next generation, cloud-based applications with Red Hat Solutions and Microsoft SQL Server on Linux in Azure. Join us and listen to this panel discussion.
-
MS SQL Server Simplified: Performance, Security & Availability DBaaS
By:
Type: Replay
Between patching, provisioning, copy data management, and data protection, MS SQL Server admins are busier than ever. Add in the challenge of managing these tasks across clouds, and admins find themselves working nights and weekends to keep databases up and running. The good news is that these tasks can be dramatically simplified and streamlined! In this short webinar, you’ll learn how using a consolidated, cloud-agnostic platform and modern DBaaS solution can dramatically reduce the time spent on error-prone, repetitive manual tasks to support SQL Server. We'll also show you how to improve security, performance and availability leaving your evenings and weekend time free from providing SQL Server support.
-
MS SQL Server Simplified: Performance, Security & Availability DBaaS
By:
Type: Replay
Between patching, provisioning, copy data management, and data protection, MS SQL Server admins are busier than ever. Add in the challenge of managing these tasks across clouds, and admins find themselves working nights and weekends to keep databases up and running. The good news is that these tasks can be dramatically simplified and streamlined! In this short webinar, you’ll learn: - How using a consolidated, cloud-agnostic platform and modern DBaaS solution can dramatically reduce the time spent on error-prone - How to reduce repetitive manual tasks to support SQL Server - How to improve security, performance and availability, leaving your evenings and weekend time free from providing SQL Server support
-
Preparing for Database as a Service (DBaaS): Considerations to Make it a Success
By:
Type: Talk
This webinar will walk through the main factors that you need to consider when adopting a Database as a Service (DBaaS) solution for your databases. The checklist includes: Your cloud goals, application development model, workload requirements, resiliency requirements, data usage architecture, and future plans for innovation. This webinar is Part 1 in a series of webinars on DBaaS. Other topics covered in this series include exploring your DBaaS provider options for databases like Microsoft SQL Server and Oracle, calculating the Total Cost of Ownership (TCO) of DBaaS with Silk, and more.
-
What DBAs Need to Know About Snapshots
By:
Type: Video
You're a DBA responsible for making sure SQL Server databases are online, backed up, corruption-free, and fast. Your databases have gradually grown in size over time, and you're starting to hit new size issues you haven't encountered before. Nightly maintenance windows are getting smaller, you're not able to refresh your development environments quickly enough, and you're not able to run DBCC CHECKDB as often as you'd like. You're starting to wonder - how do people with multiple terabytes of databases handle it? In this session, Brent Ozar will explain how he came to love storage snapshots. He'll discuss how they work, why they're safe to rely on, and how to tell when they're a good fit for your workloads.
-
How to: Improve DevOps with Database Integrated Monitoring
By:
Type: Video
DevOps is a widespread and popular set of practices, tools, and philosophies used to improve and accelerate the system's development life cycle. DevOps automates and integrates the processes between software development teams (“Dev”) and IT administration teams (“Ops”). While DevOps is popular for full-stack software development, it is also excellent for database development and can help reduce or eliminate many database performance issues before they ever deploy to production. Unfortunately, this practice isn’t widespread. But it should be! In this two-part webcast, you will learn how developers using Visual Studio “quality gates” can integrate with SolarWinds DPA and SQL Sentry to make that happen. Without this integration, undetected performance problems can lead to lost productivity and even lost data, as well as significant time spent by developers and database administrators (DBAs) chasing down performance problems. Packed with demos in Visual Studio and both DPA and SQL Sentry, you will see how to identify SQL Server performance problems in the development cycle, before the changes hit production. PREREQUISITES: Basic proficiency with core SQL statements, like CREATE, ALTER, DROP, GRANT, SELECT, INSERT, UPDATE, and DELETE
-
Lower SQL Server Costs with Red Hat Enterprise Linux
By:
Type: Video
A solid data platform can help your business quickly process large volumes of data and meet growing operational and analytical workloads. Microsoft SQL Server on Red Hat® Enterprise Linux® offers you additional flexibility, superior performance, enhanced security, and ultra-high availability. This combination provides a scalable foundation with a consistent application experience, whether deployed across bare-metal, virtual machine, container, or cloud environments. Please join Dell and Red Hat and find out How can you deliver the database platform your database administrators and developers have loved for years with the modern IT environment you need today? SQL Server on Red Hat® Enterprise Linux® provides a fast, reliable, and security-focused operating environment. No matter how you choose to deploy, on-premise or in the cloud, Red Hat Enterprise Linux delivers a consistent environment designed for flexibility and performance. · Achieve 3 times faster transaction response. · Reduce resource use by 30% per server. · Reduce administrator support and maintenance time by 60%.
-
Go beyond cloud-native backup: Protecting Azure VMs and SQL
By:
Type: Video
Businesses are increasingly relying on Microsoft Azure for their virtual machines (VMs) and SQL databases. With cyber attacks becoming more frequent and sophisticated, organizations struggle with the inflexible coverage and often cost prohibitive options from their cloud provider, particularly as it relates to long term data storage. In this demo of Cohesity DataProtect, you will: * Learn how to enhance your existing data protection for Microsoft Azure virtual machines and SQL databases. * Explore flexible options for how and when to backup your data. * See how fast and easy it is to restore Microsoft Azure virtual machines and SQL databases.
-
Modernizing Your Database Architecture with AWS
By:
Type: Replay
Many organizations are looking to modernize their workloads to benefit from the increased scalability and flexibility that the cloud provides. As companies look to transform into more modern architectures, they often start with a key fundamental foundation – migrating databases. Customers with an on-premises database face challenges of scale, performance, flexibility, and cost, yet the path to addressing these challenges is often not clear. If you are looking to move your commercial databases, like Oracle or SQL Server, to a managed cloud environment or “break free”, look no further. Join us for our webinar to learn more about how organizations have successfully embarked on database modernization with AWS to grow their business. What We’ll Cover: - The business challenges of self- managing commercial databases - Explain the difference between self-managed and fully managed databases (Amazon EC2 v/s RDS v/s Aurora) - Use cases for Re-hosting v/s modernization: the ideal path for your workloads - How migrating off of an on-premises system can improve your costs and your productivity
-
Modernizing Your Database Architecture with AWS
By:
Type: Replay
Many organizations are looking to modernize their workloads to benefit from the increased scalability and flexibility that the cloud provides. As companies look to transform into more modern architectures, they often start with a key fundamental foundation – migrating databases. Customers with an on-premises database face challenges of scale, performance, flexibility, and cost, yet the path to addressing these challenges is often not clear. If you are looking to move your commercial databases , like Oracle or SQL Server, to a managed cloud environment or “break free”, look no further. Join us for our webinar to learn more about how organizations have successfully embarked on database modernization with AWS to grow their business. What We’ll Cover: - The business challenges of self- managing commercial databases - Explain the difference between self-managed and fully managed databases (Amazon EC2 v/s RDS v/s Aurora) - Use cases for Re-hosting v/s modernization: the ideal path for your workloads - How migrating off of an on-premises system can improve your costs and your productivity
-
Reduce support & maintenance w/Microsoft SQL-Server '22 on Red Hat Enterp. Linux
By:
Type: Video
Reduce administrator support and maintenance time with Microsoft SQL Server 2022 on Red Hat Enterprise Linux Organizations are transforming and running business-critical workloads across cloud and hybrid environments. To be successful, the need to secure workloads and data is imperative. Microsoft SQL Server 2022 on Red Hat® Enterprise Linux® allows you to run business-critical workloads anywhere-for modernization, improved performance, and reduced costs-to stay ahead of emerging security threats. Join us to learn more about the value of Microsoft SQL Server 2022 on Red Hat Enterprise Linux-based platforms. This demo-driven session will leave you with actionable next steps and links to reference architecture. Join this webinar to: Hear how Microsoft SQL Server 2022 delivers advanced multilayer security with hybrid capabilities in Microsoft Azure, working together with Red Hat Enterprise Linux 9 to offer a flexible platform to modernize applications and containers Watch as our Microsoft SQL Server experts demonstrate exciting new features that benefit both database administrators and developers who tackle everyday problems and organizational concerns Find out how optimal coverage starts with advanced multilayer security, to build and deploy diverse applications with a flexible application platform Learn about using Ansible scripts to automate and deploy Microsoft SQL Server on Red Hat Enterprise Linux based on best practices, and see how user-friendly it is to configure Always On availability groups over Pacemaker clusters Hear about new features for backups, authentication, container deployment, and more Presenters Louis Imershein Principal Product Manager, Red Hat Amit Khandelwal - Senior Program Manager, Data Platform - SQL Server, Microsoft
-
Using PostgreSQL to power your AI applications
By:
Type: Talk
What can PostgreSQL do for AI application? PostgreSQL is capable of efficiently storing and retrieving large amounts of data, such as training data for your models. Its wide support of the SQL standard, including SQL/MED, makes inspecting and querying that data a breeze. Moreover, PostgreSQL comes with similarity search capabilities, providing convenient index structures (GIST, GIN...) and built-in extensions (fuzzystrmatch, pg_trgm...). Yet, there is more to PostgreSQL's ecosystem than the database server. There are more than 1000 extensions for PostgreSQL, many of which can be useful for AI developers and users, for example pgvector and PostgresML. The Role of PostgreSQL in MLOps MLOps projects such as Kubeflow rely on relational databases for storing different artefacts, and choosing which relational database to use for MLOps is a common dilemma. We approached a similar topic in our recent webinar “PostgreSQL vs MySQL”, where we explored how, despite looking similar on the surface, the two databases are actually very different. The significant structural differences between databases can have a tremendous influence on the performance of any ML project, so understanding the possible impact is critical for both the enterprises who use these platforms and the engineers who develop them. So how do we use PostgreSQL for machine learning? Join the live discussion to learn more about using PostgreSQL for AI projects. The webinar will cover: - An overview of the PostgreSQL ecosystem for AI projects - Benefits of PostgreSQL for AI projects - Use cases where PostgreSQL should be used for AI projects
-
Using PostgreSQL to power your AI applications
By:
Type: Replay
What can PostgreSQL do for AI application? PostgreSQL is capable of efficiently storing and retrieving large amounts of data, such as training data for your models. Its wide support of the SQL standard, including SQL/MED, makes inspecting and querying that data a breeze. Moreover, PostgreSQL comes with similarity search capabilities, providing convenient index structures (GIST, GIN...) and built-in extensions (fuzzystrmatch, pg_trgm...). Yet, there is more to PostgreSQL's ecosystem than the database server. There are more than 1000 extensions for PostgreSQL, many of which can be useful for AI developers and users, for example pgvector and PostgresML. The Role of PostgreSQL in MLOps MLOps projects such as Kubeflow rely on relational databases for storing different artefacts, and choosing which relational database to use for MLOps is a common dilemma. We approached a similar topic in our recent webinar “PostgreSQL vs MySQL”, where we explored how, despite looking similar on the surface, the two databases are actually very different. The significant structural differences between databases can have a tremendous influence on the performance of any ML project, so understanding the possible impact is critical for both the enterprises who use these platforms and the engineers who develop them. So how do we use PostgreSQL for machine learning? Join the live discussion to learn more about using PostgreSQL for AI projects. The webinar will cover: - An overview of the PostgreSQL ecosystem for AI projects - Benefits of PostgreSQL for AI projects - Use cases where PostgreSQL should be used for AI projects
-
The Most Rapid Data Restores
By:
Type: Video
We believe that backing up and restoring your data should be fast and simple. Get the hard facts about how Pure Storage addresses best practices for data backup, restore, and long term data archiving. We'll address how FlashBlade helps reduce the time for both backup and restore operations. We'll also dive into test results about FlashBlade in SQL server environments, as an archival tier for Rubrik and for granular recovery for Oracle databases, with Commvault® IntelliSnap® technology.
-
Reduce administrator support and maintenance time with Microsoft SQL Server 2022
By:
Type: Replay
Organizations are transforming and running business-critical workloads across cloud and hybrid environments. To be successful, the need to secure workloads and data is imperative. Microsoft SQL Server 2022 on Red Hat® Enterprise Linux® allows you to run business-critical workloads anywhere-for modernization, improved performance, and reduced costs-to stay ahead of emerging security threats. Join us to learn more about the value of Microsoft SQL Server 2022 on Red Hat Enterprise Linux-based platforms. This demo-driven session will leave you with actionable next steps and links to reference architecture. Join this webinar to: • Hear how Microsoft SQL Server 2022 delivers advanced multilayer security with hybrid capabilities in Microsoft Azure, working together with Red Hat Enterprise Linux 9 to offer a flexible platform to modernize applications and containers • Watch as our Microsoft SQL Server experts demonstrate exciting new features that benefit both database administrators and developers who tackle everyday problems and organizational concerns • Find out how optimal coverage starts with advanced multilayer security, to build and deploy diverse applications with a flexible application platform • Learn about using Ansible scripts to automate and deploy Microsoft SQL Server on Red Hat Enterprise Linux based on best practices, and see how user-friendly it is to configure Always On availability groups over Pacemaker clusters • Hear about new features for backups, authentication, container deployment, and more
-
Jargon buster guide to database management
By: TechTarget ComputerWeekly.com
Type: eGuide
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.
-
Databases Roadmap 2024: Innovations for the gen AI era
By:
Type: Replay
The first step to building all-new customer experiences is to select the operational database that will power your application and, in essence, run your business. Google Cloud databases help you transform the customer experience and unlock the full potential of generative AI, setting the stage for your AI-powered applications. Join our product management leadership for this exclusive live session to learn about the latest innovations, strategy and plans for Google Cloud databases, such as how we are infusing generative AI into databases and Gemini in Databases. Hear directly from the experts who are shaping the future of AlloyDB, Cloud SQL, Spanner, Bigtable, Firestore, Memorystore, Database Migration Service (DMS) and Datastream.
-
SQL Server on Kubernetes, the next frontier
By:
Type: Talk
Data professionals were caught by surprise when IT shops started to introduce VMs for SQL Server workloads 15 years ago. As it usually happens with new technologies, there was some hesitation at the beginning; however, it was a quick turnaround until they become the standard today. So, you may ask yourself today, are containers going down the same road? Do I have to be prepared for this containers / Kubernetes thing? The answer is yes! Containers are not necessarily a replacement to VMs or whatsoever. In reality, they will make an excellent addition to your technology stack that could help you to solve software problems. This session will provide you best practices, methods, and practical solutions to help you manage your SQL Server workloads on Kubernetes hosted in Ubuntu whether on-premises using MicroK8s or cloud services like AKS. You will be able to use Kubernetes to perform near to zero downtime version upgrades, set up high availability, and accomplish agile database deployments at the end of this session.
-
What’s New in SQL Sentry
By:
Type: Replay
Discover the Latest Enhancements in SQL Sentry Since the acquisition of SentryOne by SolarWinds, a lot of development work has gone into SQL Sentry. With each release, we aim to continue empowering Microsoft Data Professionals to achieve breakthrough performance across physical, virtual, and cloud environments. In this webcast, we’ll discuss some of the newest features added to SQL Sentry over the last few releases. During the webcast, we’ll be discussing the following: • The new Enhanced Environment Health Overview dashboard built to help surface the most important information about your database environment • The addition of SQL Server Wait Stat as part of our Top SQL monitoring to help provide users with troubleshooting and performance tuning • Monitoring of Azure Synapse as a target, providing detailed visibility into the queries, loads, backups, and restores of all your data • A whole host of enhancements we’ve added to our SQL Sentry Portal web client and how it’s modernized the product During this webcast, the product leadership team of SQL Sentry will join to discuss the product roadmap and their vision for the product. If you are an existing user of SQL Sentry or considering it as a monitoring tool for your environment, this webcast is not to be missed.
-
Automation and Orchestration of Windows with Red Hat’s Ansible
By:
Type: Video
Dell | Red Hat Customer Webinar: Accelerate Your Company’s Infrastructure with the Automation and Orchestration of Windows with Red Hat’s Ansible A solid data platform can help your business quickly process large volumes of data and meet growing operational and analytical workloads. Microsoft SQL Server on Red Hat® Enterprise Linux® offers you additional flexibility, superior performance, enhanced security, and ultra-high availability. This combination provides a scalable foundation with a consistent application experience, whether deployed across bare-metal, virtual machine, container, or cloud environments. Please join Dell and Red Hat and find out How can you deliver the database platform your database administrators and developers have loved for years with the modern IT environment you need today? SQL Server on Red Hat® Enterprise Linux® provides a fast, reliable, and security-focused operating environment. No matter how you choose to deploy, on-premise or in the cloud, Red Hat Enterprise Linux delivers a consistent environment designed for flexibility and performance. · Achieve 3 times faster transaction response. · Reduce resource use by 30% per server. · Reduce administrator support and maintenance time by 60%. Speaker Information: Lance Abla labla@redhat.com; John Ringhof jringhof@redhat.com; Gienty, Keith Keith_Gienty@DELL.com
-
Optimize your Microsoft SQL Server with cloud and hybrid solutions
By: Red Hat
Type: White Paper
Optimize your Microsoft SQL Server deployment with the right cloud provider, operating system, and support. Streamline infrastructure, reduce costs, and improve performance. Download this white paper to learn more.
-
The SQL Revolution is Here
By:
Type: Video
With the release of SQL 2019, Microsoft has shattered SQLs image as a simple relational database management system catapulting itself into the realm of AI/ML. Unleash the power of SQL with a revolutionary storage platform: Dell PowerStore, a modern automation platform delivering flexibility and scalability for all your applications and workloads types.
-
Cost-effective migration strategies for SQL Server on CentOS Linux users
By:
Type: Replay
If you’re running Microsoft SQL Server on CentOS Linux® 7 today, migrating to SQL Server 2022 on Red Hat Enterprise Linux is the logical choice. Support for CentOS Linux ends June 2024, and mainstream support for Microsoft SQL Server 2017 has already ended. If you are among the many software consumers who use CentOS Linux to host SQL Server 2017, you need to make a plan. Join us to learn about how you can migrate your SQL Server on CentOS Linux deployments to SQL Server 2022 on Red Hat Enterprise Linux—for a security-focused environment that offers improved performance and increased supportability at an affordable price.
-
Microsoft SQL Server 2019 on Red Hat Enterprise Linux and OpenShift Container
By:
Type: Video
Unlocking the full potential of data is critical to success of any organization, and Microsoft SQL Server running on top of Red Hat Enterprise Linux helps your organization do just that. Red Hat Enterprise Linux is core to the foundation of building a unified data platform on Microsoft SQL Server. This workshop is for DBA’s, engineers and anyone with questions and concerns about running SQL Server 2019 on Red Hat Enterprise Linux. It includes demonstrations and discussions about how to: 1. Install SQL Server 2019 on Red Hat Enterprise Linux 2. Run SQL Server 2019 on a container 3. Manage SQL Server 2019 containers with Red Hat OpenShift Container Platform 4. Use scripts and best practices to accelerate your organization’s adoption of SQL Server on Linux
-
Balance the Power with Intel Optane Persistent Memory
By:
Type: Video
Organization’s rely on their most critical business workloads to differentiate their business and drive desired outcomes. As such, we understand there are many paths towards modernizing the data estate, and data management is not a one size fits all strategy. Listen in as experts discuss the latest features of Dell Technologies PowerEdge Server capabilities to bring faster insights, improve TCO, operate more nimbly, and improve system performance. Learn how to take advantage of Intel Optane Persistent Memory to: Save More – More Cost Effective Than Traditional Memory, Do More – Support More VMs, VDI Sessions or Databases Per Server, and Go Faster – Eliminate Memory and Storage Performance Bottlenecks. In addition, hear a high-level overview of why a storage platform makes the most sense for Optane-accelerated workloads - SAP HANA on PowerMax, Splunk on PowerScale and SQL Server on PowerStore.
-
HA and data safety in messaging: quorum queues in RabbitMQ
By:
Type: Talk
In this webinar, Jack Vanlightly will explain quorum queues, a new replicated queue type in RabbitMQ, the most popular open-source message broker. Quorum queues were introduced in RabbitMQ 3.8 in order to achieve high availability and data safety. Jack will cover and contrast the design of quorum and mirrored queues. After this webinar, you'll understand: - Why quorum queues offer better data safety than mirrored queues - How and why server resource usage changes when switching to quorum queues from mirrored queues - Some best practices when using quorum queues
-
Introducing SQL Server on Ubuntu Pro for Azure Part 2
By:
Type: Talk
In this talk, Rob Gibbon, Product Manager for Data Platform at Canonical, and Amit Khandelwal, Senior Program Manager SQL Server at Microsoft will deep dive on SQL Server on Ubuntu Pro for Azure with industry-leading SQL Server experts Argenis Fernandez and Anthony Nocentino. You will learn: - Anatomy of the performance features of SQL Server on Ubuntu Pro - How to set up Active Directory integration for the SQL Server on Ubuntu Pro solution - Deep dive on running SQL Server on Ubuntu Pro with new persistent memory (PMEM) Azure instances to turbocharge your SQL Server deployments Check out Part 1: https://ubuntu.com/engage/SQLServerWebinarPart1 Check out our marketplace offering for SQL Server: https://azuremarketplace.microsoft.com/en-us/marketplace/apps/microsoftsqlserver.sql2019-ubuntupro2004?tab=Overview Check out our marketplace offering for Ubuntu Pro: https://azuremarketplace.microsoft.com/en-us/marketplace/apps/canonical.0001-com-ubuntu-pro-focal?tab=Overview
-
How to Think Like the Engine: Bigger Data Edition
By:
Type: Video
When you pass in a query, how does SQL Server build the results? Let’s say Brent Ozar is an end user sending queries, and you'll act as the SQL Server engine. Using simple spreadsheets as your tables, you'll learn how SQL Server builds execution plans, uses indexes, reads data from storage, and caches it in memory. This session is for DBAs and developers who are comfortable writing queries, but not as comfortable when it comes to explaining nonclustered indexes, PAGEIOLATCH waits, and physical reads. We’ill also cover the role of storage in optimizing SQL Server operations. In this TechTalk, you’ll: Learn how SQL Server builds execution plans, which are critical for understanding how a query will be executed. Gain clarity on indexes and how SQL Server reads data from storage and caches it in memory. Explore the importance of storage in optimizing SQL Server operations, highlighting the impact of storage on query performance
-
How to Think Like the Engine: Bigger Data Edition
By:
Type: Video
When you pass in a query, how does SQL Server build the results? Let’s say Brent Ozar is an end user sending queries, and you'll act as the SQL Server engine. Using simple spreadsheets as your tables, you'll learn how SQL Server builds execution plans, uses indexes, reads data from storage, and caches it in memory. This session is for DBAs and developers who are comfortable writing queries, but not as comfortable when it comes to explaining nonclustered indexes, PAGEIOLATCH waits, and physical reads. We’ill also cover the role of storage in optimizing SQL Server operations. In this TechTalk, you’ll: Learn how SQL Server builds execution plans, which are critical for understanding how a query will be executed. Gain clarity on indexes and how SQL Server reads data from storage and caches it in memory. Explore the importance of storage in optimizing SQL Server operations, highlighting the impact of storage on query performance
-
How to Create a Vertica Analytical Database on AWS in Minutes
By:
Type: Talk
You have priorities, and we realize that one of them might not be experimenting with a new database to find better performance, value, and lower cost. However, there is an easy way to create a Vertica database on AWS in a few minutes with our Database as a Service (DBaaS) offering. Vertica Accelerator is Vertica-as-a-Service (SaaS), and it delivers great SQL analytics. However, it also offers so much more with high-performance advanced analytics and machine learning. See how the deployment, administration, and management of Vertica running in your own AWS cloud account is streamlined in Vertica Accelerator. Keep your data in Vertica to perform machine learning, geospatial and time-series analytics.