During the last few articles, we have covered the basics of working with SQL server using the Server Management Objects (SMO) and PowerShell. We have covered things such as viewing the state of ...

If you want to take a copy of one table and make a copy of it in another schema (under another username), you can use the SQL*Plus COPY command, or a simple <code>"create table foo as select * from ...

How to Create a MySQL 8 Database User With Remote Access Your email has been sent At some point, you're going to need to connect to a MySQL 8 database remotely to manage your databases. Here's how to ...

There are lots of ways to create MSSQL databases via PowerShell. We could invoke a T-SQL query using the CREATE DATABASE term, we could write some code to use the [Create() method with SMO] or, if ...

Oracle has announced the general availability of Oracle SQL Developer Release 1.2 that features new capabilities to ease the migration and consolidation of third-party databases onto Oracle Database ...

Early discussions on SQL Server 2008 seemed to suggest that it would really only be a point release, quite unlike what occurred with SQL Server 2005. Anyone looking at the new and upgraded features in ...