Install SQL Server and Oracle on Windows Containers
In this article we look at how to install SQL Server and Oracle using PowerShell to create development environments using Windows Containers.
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
SQL Server PolyBase Scale-out Group Using Amazon Web Services
In this article we look at how to create a scale-out SQL Server PolyBase solution on AWS.
Copy Table from Oracle to SQL Server on Linux
In this tip we look at how to import data from Oracle to SQL Server when working in a Linux environment.
Find Embedded SQL Server Logins in Jobs, Linked Servers or SSISDB
In this tip we look at a script you can use to see if a login and password is embedded somewhere with in your Linked Servers, SQL Server Agent Jobs or SSISDB information.
List SQL Server Permissions for Read and Write Access All Databases
In this tip we look a script to find SQL Server logins and database users that have read or write access to any database in the instance.
Data Analysis of SQL Server Tables using T-SQL for Machine Learning
In this tip we look at a script that you can use to get better insight on your database tables to help you make some decisions about the data and also the structure of the table.
How to Copy a Table in SQL Server to Another Database
Learn about options to copy a table from one SQL Server database to another including Linked Servers, PowerShell, Integration Services, backup and restore along with the associated performance metrics and completion time.
T-SQL Script to Correct SQL Server Full Text Indexes Not Updating
In this tip we look at a way to determine if your SQL Server full text indexes are up to date and are indexed properly.
SQL Server Agent Job Step History Error Messages for SSIS Package
In this tip we look at a script you can use to find detailed error and warning messages for an SSIS package run as a scheduled job using SQL Server Agent.
Script out SQL Server Credentials and Proxies
Learn how to script out all SQL Server Credentials and Proxies.
SQL Server Parallelism Overview
In this tip we look at an overview of SQL Server parallelism and how this can improve performance of your queries.
Script for SQL Server Database Growth Since Last Backup
In this tip we look at a script that can be used to show how much a SQL Server database has changed from the last backup.
Monitor Performance Counters with PowerShell in SQL Server Agent Job
In this tip, we look at how to capture performance counter data when there are performance issues with SQL Server using PowerShell.
Increase PowerShell available commands in a SQL Server Agent Job step
In this tip we take a look at how you can use all PowerShell commands when using SQL Server Agent versus the limited set available with SQLPS.
Comprehensive SQL Server Monitoring Report via Email
In this tip we look at a way to get multiple result sets for monitoring different aspects of SQL Server in a nicely formatted email.
Script to Distribute Existing SQL Server Full Text Indexes Across Multiple Catalogs
In this tip we look at a script that can distribute existing full text indexes into multiple catalogs instead of having all indexes in one catalog.
Script for SQL Server Agent Job Issues Across All Instances
In this tip we look at a script you can use to get information for all of your SQL Agent Jobs across all instances in your environment.
Migrate a database from SQL Server 2008 to 2016 and use new features
Learn the step by step process to migrate a SQL Server database from 2008 to 2016 including compatibility levels, query store, new filegroups, heap tables, blob tables and more.
Check current patch levels for all SQL Servers in environment
Check out this tip and PowerShell script to help you identify the current patch level for all of your SQL Servers and whether the server needs to be updated.
Find all stopped SQL Server services for all instances
In this tip we look at how to find any stopped SQL Server service for any instance in your environment for quick reporting and troubleshooting.
Scripts to check SQL Server instant file initialization and lock pages in memory for all servers
Learn how to check SQL Server instant file initialization and lock pages in memory for all servers and versions with C# and PowerShell.
Purge SQL Server MSDB Database History Tables with Partitioning
Learn how to efficiently purge the SQL Server MSDB database without causing blocking or filling up the transaction log.
Graph SQL Server Database Growth Using R and PowerShell
In this tip we look at how we can use R and PowerShell to create database growth charts.
Find Drives with Low Disk Space for all SQL Instances using PowerShell
Check out this PowerShell script to get a list of problem drives across your entire SQL Server environment.