Find a String in SQL Server Tables, Stored Procedures and Functions
Learn how to build and use a simple app to search for a string in SQL Server tables, stored procedures, and user defined functions.
Mircea Dragan is a Senior Computer Scientist with strong mathematical background, and extensive industrial and academic experience in domains including data security, fraud detection, anomaly detection, big data, event processing in streaming applications, database management, database migration and real time processing. Mircea has 18 years of hands-on programming experience in large international projects, as individual contributor, team member and team leader. He is also an experienced speaker, especially for academic audiences.
- MSSQLTips Awards: Rookie of the Year Contender - 2020
Auto Create SQL RESTORE DATABASE Command from Database Backup File
In this article, we look at a script that can automatically generate a restore database command from a SQL Server backup.
Find String in a Table in SQL Server
Check out this article that includes a C# project to find all matching strings in a SQL Server database table and extracts the data to an Excel file.
Import Excel Data into SQL Server
This article shows how to load multiple Excel sheets into multiple SQL Server database tables using C# code along with code samples.
Export Data from SQL Server to Excel and Simulate COMPUTE BY Clause
Learn how to mimic the SQL Server COMPUTE BY clause when exporting data from SQL Server to Excel.
Export SQL Server Data to Excel and Add New Columns with C#
Learn how to export data from SQL Server into Excel and programmatically add new columns to the spreadsheet using C#.
How to Make a Chart in Excel from a SQL Server Database
In this article we look at how to build charts in Excel using data from a SQL Server database.
Export SQL Server Data to Multiple Excel Worksheets
In this article we look at how to export data from different SQL Server tables or queries into multiple Excel sheets in the same file.
SQL Server Export Table to Excel with C#
In this article we look at how you can export data from SQL Server to Excel worksheets using C#.
Using SQL Server ROLL UP to Get Similar Results of COMPUTE BY
In this article we take a look at how to get similar result sets when using ROLLUP versus COMPUTE BY in SQL Server queries.
How to Sync Two SQL Server Databases – Part 3
In this article we cover some code that we can use to make database schemas match by comparing the objects in the databases.
Compare SQL Server Databases – Part 2
I need to programmatically compare SQL Server tables, columns, indexes and constraints between databases to determine what is the same, differences and additions. How can this be accomplished?
How to Compare Database Schema in SQL Server – Part 1
In this article we look at a way to compare database schemas between two different databases using C# and JSON.
Convert MS Access to SQL Server with Always Encrypted Database
In this article we cover code that allows you to migrate your database from MS Access to SQL Server and also use Always Encrypted columns.
Save SQL Server Database Structure as Json
In this article we look at various T-SQL scripts that can be used to generate SQL Server object structures in JSON format.