Using plain ‘ol PL/SQL scripts But What’s the Big Deal? Doing Oracle schema compare is not like playing Spot the Difference. That fun classic game gives you two almost identical images and you need to ...

Generates a schema-only, read-only copy of a database using DBCC CLONEDATABASE to investigate performance issues related to the query optimizer. Learn more.

In this post I'll show you 5 free alternatives to Microsoft SQL Management Studio. While SQL server Management studio is built-in utility for managing SQL Express, it's tricky to install, and I've ...

You can create a Full Backup to restore database in SQL Server using the SQL Server Management Studio (SSMS). For this, open SSMS, right-click the database, and select Tasks > Back Up.

It's not hard to create and run a shell script in Linux distros like Ubuntu, but there are a few non-obvious pitfalls you need to avoid. Here's a quick example of how to execute a script in Linux.

Last week at work I was given a folder of 1,500 scripts – can you imagine having to open each file in Management Studio to be able to execute it?

In November, Microsoft released version 18.4 for the SQL Server Management Studio (SSMS), introducing some key features such as support for materialized view scripts in SQL Data Warehouse.

Microsoft has clarified the more confusing elements of SQL Server licensing and extended major benefits to customers. The catch is that Software Assurance is required to take advantage of them.