Earlier this year, Power View was released with SQL Server 2012, a remarkable step forward in data visualization and then enhanced version of Power View within Excel as part of Office 2013. It wasn't all bad news that Power View only worked with the new tabular semantic models and PowerPivot worksheets...

Planning for TechEd Australia 2012! is well underway, and this year I have the opportunity to assist Database & BI track along with my colleagues Marcy Larsen, Shashank Pawar, Ron Dunn and Simon Brown. TechED wouldn't be a success without great content from the field, and as such it presents an...

Introducing Microsoft® SQL Server® 2012 explores the exciting enhancements and new capabilities engineered into SQL Server, ranging from improvements in operation to those in reporting and management. This book is for anyone who has an interest in SQL Server 2012 and wants to understand its capabilities...

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 the columns returned as you need them for your...

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 that you can use to learn SQL Server 2012...

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 soon. Denali is a cloud-ready information platform...

If you have logged in to different domain (Domain XYZ) than the SSAS Server (Domain ABC) belong to (For Ex. SSAS server is member of Domain ABC and user normally log in to Domain XYZ, there is no trust exist between these domains) connecting to SSAS from the work station using various presentation tools...

We are pleased to announce the release of the SQL Server Code Name “Denali” Community Technology Preview 3 (CTP3) Product Guide v1. This is a single download that organizes the CTP3 content for easier viewing. It is available for download at http://go.microsoft.com/fwlink/?LinkID=225814 ...

The SQLServer Samples Readme TechNet Wiki is the portal for Denali CTP 3 samples. It ties it all together and provides step-by-step installation instructions and links to related resources. All downloads include redirects to this readme wiki. We will keep the wiki up to date with the latest information...