Database & SQL Articles
SQL Server scripts and tips from our engineers: audit trails, copying objects between databases and querying across them.
How to implement audit trail using triggers in SQL
A custom approach to store audit trail using Triggers and JSON format in SQL Server database.
T-SQL Tips and Tricks: Copying Stored Procedure or Function from one database to multiple target databases
A script to copy stored procedure or function from one DB to another DB or to multiple target databases
T-SQL Tips and Tricks: Efficiently Querying Audit Entries created by Entity Framework in MS SQL
An easy way to query audit entries created by Entity Framework. This can be used by Microsoft .Net Developers in reports and UI to display history of changes to certain tables by users.
T-SQL Tips and Tricks: Copying Views from one database to multiple target databases
A script to copy T-SQL view from one MS SQL database to another or multiple target databases
T-SQL Tips and Tricks: Executing a Query in multiple databases
A script to Execute T-SQL Queries in multiple databases
Top 10 Most Common MongoDB Commands
Top 10 Most Common MongoDB Commands. Are you new to MongoDB? Then this cheat sheet with the top 10 most common MongoDB commands can be very useful to you.
SQL Server identity values jump by 1000 when it is restarted
SQL Server identity values jump by 1000 when it is restarted
Have a SQL Server database that needs work?
Talk to an engineer at our Troy, Michigan office about your database.
Get new articles by email
One email when we publish. No other mail.