Shovel: Database Utilities for SQL Server

June 25, 2020
Cover Image

I'd like to introduce some utilities that I wrote to help SQL Server developers that I'm calling "Shovel". You can install it by going to the Microsoft Store or by downloading a ZIP.

In version 1, there are two collections of features: Database Schema Search and Data Export. I've created a couple of videos to give you a tour of the features.

  • Search Schema Search Features (video tour)
    • Find Text Anywhere
    • Search by Table Name
    • Search by Column Name
    • Search by Stored Procedure Name
    • Search by Stored Procedure Parameter Name
    • Search by Stored Procedure Code
    • View Table Description
    • View Stored Procedure Code
  • Data Export Features (video tour)
    • Export Query Results as INSERT script
    • Export Query Results as IDENTITY INSERT script
    • Export Query as MERGE INTO script (aka. UPDATE script)
  • Search by Table Name

  • Search by Column Name

  • Find Stored Procedures by Source Code

  • Find Text Anywhere in the Database

  • Export Data using a SQL Query

  • Administer Database Connections

I hope you like it and find it useful. If you have suggestions for new features or run into problems with Shovel, please let me know.

-Ben

-- Looking for help with your database applications? Need some software architecture guidance for your .NET Core apps? Running into problems with Scrum, Azure DevOps, and/or remote software teams? We can help. Drop us a line at info@benday.com.

Tags: database sql-server