SQLAuthority News – Download – Microsoft SQL Server Compact 4.0

Microsoft SQL Server Compact 4.0 is a free, embedded database that software developers can use for building ASP.NET websites and Windows desktop applications. SQL Server Compact 4.0 has a small footprint and supports private deployment of its binaries within the application folder, easy application development in Visual Studio and WebMatrix,…
Read More
All Articles expressor_artifact-336x400

SQL SERVER – Sharing your ETL Resources Across Applications with Ease

Frequently an organization will find that the same resources are used in multiple ETL applications, for example, the same database, general purpose processing logic, or file system locations. Creating an easy way to reuse these resources across multiple applications would increase efficiency and reduce errors. Moreover, not every ETL developer has the same skill set, and it is likely that one developer will be more adept at writing code while another is more comfortable configuring database connections. Real productivity gains will come when these developers are able to work independently while still making their work available to others assigned to the same project. These are the benefits of a centralized version control system.

Read More
All Articles FastTrackDw-600x400

SQLAuthority News – Fast Track Data Warehouse 3.0 Reference Guide

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/gg605238(v=msdn.10)?redirectedfrom=MSDN I am very excited that Fast Track Data Warehouse 3.0 reference guide has been announced. As a consultant, I have always enjoyed working with Fast Track Data Warehouse project as it truly expresses the potential of the SQL Server Engine. Here are a few details of the enhancement of the Fast Track Data Warehouse 3.0 reference architecture.

Read More