Scott Stephens creates a package that allows you to clone most database objects with dynamic SQL.

The tool provides a variety of impressive database-management features, including SQL scripting, query building, object management, project management and version control in live databases.

Don’t look now, but object stores – those vast repositories of data sitting behind an S3 API – are beginning to resemble databases. They’re obviously still separate categories today, but as the ...

The evolving landscape of NoSQL databases and NoSQL database management systems (NoSQL DBMS) has everything to do with Big Data analytics.

Optimizing the performance of operational databases and the applications that access them is a constant battle for DBAs. Of course, writing efficient SQL is the most important aspect of ensuring ...

A business object written with an SQL pass-through has the database server do more record processing. With a pass-through, the server does the subtotals and sends fewer records back to the object.

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 ...

SQL Server database corruption is troublesome for DBAs, particularly if the situation arrives suddenly and there is no backup. This situation can lead to prolonged downtime and permanent data loss in ...

This is a special software designed to repair corrupt SQL Server database files. It can rebuild the database, including the log file. This software repairs the database based on the SQL Server data ...

PostgreSQL implementation of document-oriented NoSQL datastore adopted under permissive MIT license The Linux Foundation on Monday welcomed Microsoft's DocumentDB into its stable of open source ...