Ever wondered on how to get a table with dates for various needs in PowerPivot where the source does not contain any such table?. Here is a short T-SQL Code to generate the Table with Dates. Since it's a standard T-SQL code, you should be able to modify...

If you want to learn how to develop database and business intelligence solutions that fully exploit SQL Server 2012 improvements, this resource is for you! The SQL Server 2012 Developer Training Kit includes technical content like labs, demos and presentations...

The Next Major Release of SQL Server is Coming – Are You Ready? SQL Server Codename "Denali" is the next major release of SQL Server following SQL 2008 R2. It is currently in pre-release (CTP 3) and the release date is expected to be announced...