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

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.

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.

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...

Red Gate Software has released a new tool called SQL Object Level Recovery Native that enables individual database objects to be recovered from native ...

With SQL Server, you need to grant access to three areas: SQL Server, the database, and the objects in the database such as tables and views.

What are the advantages of using Access as the front end to a SQL Server database? For starters, it's likely that your client's users will be more familiar with it, and it's relatively easy to put ...

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

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