SQL Server Copy Table Options
Learn about different ways to copy a table and its data from one SQL Server instance to another SQL Server instance.
Garry Bargsley is a SQL Server Database Administrator with over 20 years experience in the technology field. His interests and specializations are SQL, Azure, PowerShell and Automation. Based in Dallas/Fort Worth, Texas, he is a member of the North Texas SQL Server User Group Board and an active participant in the SQL Community, occasionally speaking at SQL Saturday and online events. Garry even has a blog in which he outlines common SQL issues and gives step-by-step instruction on troubleshooting weekly. When Garry isn't chasing his 4 year old son around, he enjoys contributing frequently to the Open Source PowerShell project dbatools. You can find his website and blog at GarryBargsley.com or follow him on Twitter at Twitter.com/gbargsley.
- MSSQLTips Awards: Rookie of the Year Contender - 2020
Edition Upgrade and Downgrade in SQL Server
In this article we walk through the steps to upgrade or downgrade the edition of SQL Server for existing installation.
SQL REPLACE Overview and Examples
In this article we look at the SQL Server REPLACE function and show several examples of how this can be used to replace text values in strings.
Install SSRS ReportServer Databases on Azure SQL Managed Instance
In this article we look at how we can use an Azure SQL managed instance to host Reporting Services report server databases.
Visual Studio 2019 Install and Configure for the SQL Server DBA
In this article we cover how to install and configure Visual Studio to be used to manage components for SSIS, SSRS and SSAS.