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

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

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

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

In addition to the deployment benefits from SQL projects, Microsoft.Build.Sql projects represent each database object as an individual SQL script. Your database is now a human-readable definition in ...

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.

Data manipulation language SQL (SELECT, INSERT, UPDATE, MERGE, DELETE) statements use the system catalog to ensure that the statements accurately reference existing database objects (such as column ...