SQL Server 2008 R2 gave us data-tier applications ("DACs") and yet another Visual Studio project type All these database project types can get pretty confusing. And the funny part is that you're still ...

Fresh on the heels of SQL Server 2014 being released to manufacturing, the SQL Server Data Tools (SSDT) team yesterday announced support for the new version, along with numerous other enhancements.

Online analytical processing (OLAP) cube example Hybrid Distributed Data example As you will see in this chapter, companies use SQL Server for many types of applications and on most tiers now.

How to import or export diagrams with SQL Server? Information about the diagrams is stored in the dtproperties table. Basically to import or export a diagram, you simply need to import or export the ...