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

Sharing database data throughout a company is crucial to the daily operations of most businesses. To facilitate this, the data doesn't reside on one person's desktop PC; instead, a database server ...

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

With SQL Server 2016, you can store JSON objects in your rows. Here’s how to work with JSON objects, including how to update them once you’ve found them.

Object-oriented databases play nicely with object-oriented programming languages. This post is one of a series that introduces the fundamentals of NOSQL databases, and their role in Big Data ...