Backup SQL Server on Linux Databases using SQL Server Agent on Windows
In this tip, we're going to look at the steps to backup SQL Server on Linux databases using SQL Server Agent on a Windows server.
Pablo Echeverria has worked for more than 10 years as a software programmer and analyst, during which time I studied parallel programming and became a senior programmer specialist. Afterward, he switched to a DBA position implementing new processes and creating better monitoring tools, while growing his data scientist skills to improve my customer's businesses. Check out Pablo's most recent book, "Hands-on Data Virtualization with Polybase". This book brings exciting coverage on establishing and managing data virtualization using Polybase. It teaches how to configure Polybase on almost all relational and nonrelational databases, to setup a test environment for any tool or software instantly without any hassle, and to rapidly design and build high performing data warehousing solutions.
- MSSQLTips Awards: Rising Star (50+ tips) - 2024 | Author Contender - 2018, 2022, 2023 | Rookie Contender - 2017
Power BI vs Tableau Reporting Comparison with SQL Server Data
Learn about Power BI vs Tableau reporting comparison with SQL Server data to see the query differences when retrieving data.
File Watcher Notification for SQL Server vs. Oracle
In this article, we look at how to setup a file watcher process for SQL Server or Oracle to alert you when new files arrive in a folder.
Historical Query Performance Statistics in SQL Server vs Oracle
In this article, we look at how to get historical performance stats for queries for both SQL Server and Oracle.
Automatically Refresh Cached Web Page Data from SQL Server or Oracle
Learn how to automatically refresh cached web page data from a database based on data updates in either Oracle or SQL Server.
SQL Server and Oracle Cached Query Statistics and Execution Plans
Learn how to query cached query statistics and execution plans for Oracle or SQL Server to identify code that can be optimized to improve performance.
SQL Server and Oracle Locking Scripts
Learn how to query lock information for both Oracle and SQL Server along with sample scripts and descriptions of each query element.
Troubleshoot Active Sessions in SQL Server vs. Oracle
SQL scripts for both SQL Server and Oracle that you can use to troubleshoot active sessions for both of these database platforms.
How to Cache SQL Server Data for a Web Application
One of the slowest parts of any application is data retrieval and in this article, we look at how to cache SQL Server data for a web application.
Visual Studio 2019 ASP.NET Core Web Application – SQL Server vs Oracle
Learn how to use SQL Server or Oracle as the backend database for a simple .Net Core Web Application.
ETL Tools Comparison – SSIS vs Oracle ODI
This article is a comparison of how to perform ETL tasks in an Oracle environment using ODI versus a SQL Server environment using SSIS.
How to Script Database Objects with SSMS and SQL Developer
Learn how to script database objects and data from Oracle using SQL Developer and SQL Server using SQL Server Management Studio.
Install SSIS vs Oracle Data Integrator from the Command Line
This article covers how to install SQL Server Integration Services and Oracle Data Integrator from the command line.
SQL Server and Oracle Performance Improvement with Multiple Data Files
In this tip, we will run several tests using different numbers of data files for SQL Server and Oracle databases to see if more files improves the per
Automatically Handle Scheduled Jobs that hang in SQL Server and Oracle
In this article, we look at how to automatically handle scheduled jobs that hang in both SQL Server and Oracle.
Transparent Data Encryption Comparison between SQL Server and Oracle
In this article, we look at how to set up Transparent Data Encryption for SQL Server and Oracle along with the differences and similarities.
Machine Learning in SQL Server vs Oracle for Sentiment Analysis
Learn how to set up Machine Learning for SQL Server and Oracle as well as perform sentiment analysis using R in both database platforms.
Data Masking in SQL Server vs Oracle
In this article, we look at how to mask/hide data for users using Dynamic Data Masking in SQL Server and Data Redaction in Oracle.
Semantic Search Capabilities in SQL Server and Oracle
Learn about semantic search capabilities in SQL Server and Oracle as well as how to configure databases to use semantic search.
SQL Server Full Text Search vs Oracle Text Search
In this article we look at SQL Server Full Text Search and Oracle Text Search to compare the similarities and differences of how they work.
Setup Encrypted Connections to SQL Server and Oracle using TLS
In this article we look at how to setup encrypted connections to SQL Server and to Oracle using TLS 1.2 along with the step by step process.
Compare SQL Server BCP and Oracle SQL*Loader
Learn how to bulk load data into SQL Server and Oracle using Bulk Copy Program (BCP) and SQL*Loader (SQLLDR).
Create Table SQL Server vs Oracle
In this article we look at a comparison of different things you can specify when creating tables in SQL Server and in Oracle.
SQL CREATE DATABASE vs Oracle CREATE DATABASE
In this article we look at some of the similarities and differences between creating a new database for Oracle versus SQL Server.