|
|
-
|
|
One of the question that pops up in the head of first-time SQL Azure user is “What is Master Database doing in my server”. They try to delete/drop it. That does not happen. Fun fact: I tried dropping Master database when I had got my hand on SQ...
|
|
-
|
|
One of the common question that’s asked in the Azure MSDN forums is how to change the Live ID associated with Service Administrator. And as you may know, Service administrator is the one that manage services and deployments.
Now if you wish to change...
|
|
-
|
|
I downloaded an Excel file (It had the PowerPivot Model) from Internet on my Windows Server Dev Machine. When I tried opening that file on my machine it got stuck in the “Opening in protected View” stage:
I was able to solve the issue and I wo...
|
|
-
|
|
Did you knew that we can change the location the “Desktop” folder. Yes! The default location where files/folders are stored is “c:\users\\desktop” and you can change this.
But why do you want to do this?
1.FUN!
2. It’s a good ...
|
|
-
|
|
Step 1
Get the Binaries: SQL Server 2012 RTM, Windows Server 2008 R2, Sharepoint 2010 SP1 x64
Setup a VM: Check the System Requirements and configure the VM. And then Install Windows Server 2008 R2 x64 SP1 (and updates)
Step 2
Add Server Roles: Applic...
|
|
-
|
|
One of the task while building a PowerPivot Model is to create/Edit/Delete Relationships between tables. With SQL Server 2012 release of PowerPivot for Excel, we now have a Diagram view and this makes our task of defining relationships easier! Great additi...
|
|
-
|
|
Before we begin, Please note that:
1) it’s applicable for your Demo Machine only. Or your Dev Machine. The reason I am documenting it that I do not want to change the password of Windows Server on which I have my Sharepoint BI dev environment Setup. ...
|
|
-
|
|
This is a Guest Post by Dhwaneet Bhatt. He’s one awesome programmer and technologist with an innate ability to master any technical topic very quickly. Here’s his twitter profile: https://twitter.com/#!/dhwaneetbhatt for you to able to connect with him.
If...
|
|
-
|
|
Here are screenshots of reports hosted on SQL Azure reporting preview accessed via Windows Phone, iPhone and Android Smartphone. I knew one can access reports using browser and so just wanted to test them on Windows Phone, iPhone and Android.
Note: Report ...
|
|
-
|
|
Do not get intimidated by the long title – it’s not as complex as it sounds! So what am i talking about? Recently, I was developing SQL Server 2012 analysis services Tabular Model (referred to as ‘model’ from now on) and during deve...
|
|