Date Table for PowerPivot, without a valid table on the Source (On the Fly Generation)

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…

0

Learn SQL Server 2012 Development Now!

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 or to deliver your own training…

1

Denali – Feature Update Event @ Adelaide – SA

      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…

0

Connecting to SQL Server Analysis Services using a Different Domain Account that the user currently log on (SSAS on Different Domain and the user logon to another Domain)

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 (Ex….

0

SQL Server Code Name “Denali” CTP3 Product Guide

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 SQL Server Code Name “Denali” CTP3 Product Guide includes useful resources…

0

New Cascading Filters content for SharePoint SP1

Ever since the release of SharePoint Server 2010, customers have been asking for cascading filter capabilities in PerformancePoint Services. Now, with the release of Service Pack 1, that functionality is available and we have an article on TechNet to provide guidance on setting up and getting the most out of cascading filters. http://technet.microsoft.com/en-us/library/hh272541.aspx,

0

TechNet Wiki – Denali CTP3 Samples

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. Please tweet this link.   Microsoft…

1

Reporting Services Log Viewer

Ever wondered How to analyse the Logs that are gathered in SQL Server Reporting Services?. There is a “Reporting Services Log Viewer” Which enables you to analyse, trouble shoot and understand what’s happening inside the SSRS and who and what reports are executed, time consumed for execution, Amount of Data being processed. The sample demonstrates…

0

3 Billion Readings/day recorded on SQL Server – Helping make the planet Greener

With the current trend of every untility company rolling out AMI (Advanced Metering Infrastructure), I felt, its worth sharing Itron’s solution and SQL Server’s Scalability and Performance achievements. Such stunning performance is achieved with Itron’s Meter Data Management Solution powered by SQL Server. More info can be found at http://blogs.technet.com/b/sql_server_isv/archive/2011/04/27/itron-3-billion-readings-day-recorded-on-sql-server-helping-make-the-planet-greener.aspx  The load going through SQL Server…

1

SQL Server 2008 R2 Update for Developers Training Kit

Ever wanted to get trained on SQL Server and Microsoft BI technologies and do not know where to start with?. Here is a great tool worth exploring:- This training kit is a great resource for developers, trainers, consultants and evangelists who need to understand SQL Server 2008 and SQL Server 2008 R2 improvements from a…

0