I was recently asked by a client to architect a data and reporting environment. Part of the business requirements was separation of the production database server and the reporting services server. Another part of the business requirements stated that the reports were to leverage a shared data source and Windows Authentication. While none of the [...]
More…
SQL SQL WHERE Clause Optimization – Query optimization can make or break an application. Understanding how a WHERE clause can affect a query is very important. This article helps shed light on that. Creating Dynamic Output in SSIS – SQL Integration Services is one of SQL Servers most powerful features. This article will demonstrate how [...]
More…