I've been playing with the new SQL Server Data Tools, and I'm impressed by the way Microsoft has gotten the product out for review and is ... It comes free with the new SQL Server 2012 and ...

An open source project gives DBAs the ability to channel PowerShell for automating and scaling complex SQL Server tasks, starting with the most basic: database backups.

Can I Install Sql Server Data Tools Without Visual Studio? Installing Analysis Services, Integration Services, and Reporting Services with SQL Server Data Tools can be done with the SSDT standalone ...

The VDT designers were hosted in the Visual InterDev shell and introduced a new database project type that served as a container for Transact SQL (T-SQL) scripts generated by the tools. Before VDT, ...

To query any SQL database from PowerShell, you need to have the SQLPS module installed along with a few supporting packages. I am going to be focusing on the SQL Server 2012 packages in this article.

One of the most useful features in Microsoft System Center Operations Manager is its reporting engine. Installing it can get a little tricky, though. Here's a step-by-step guide.

Installing the Power Tools resulted in a new "Projects" node in SSDT's new SQL Server Object Explorer, or SSOX, (with SSMS-like functionality), where you can see the schema of your database and add, ...