|
|
-
|
|
Up until April 2012, the only way to run SQL server on cloud was “SQL Azure”. But recently AWS announced SQL Server on Cloud. Good news? Probably. it’s always good to have more than one option. So for those who are new to world of AWS, he...
|
|
-
|
|
I was at SQL Rally recently (10-11 may 2012) where I happened to have a nice talk about SQL Azure with a fellow attendee. They were considering porting their database (that supports one of their apps) to Microsoft’s cloud service. One of the concern ...
|
|
-
|
|
I just researched few business operation challenges that are faced by SaaS (software as a service) provider & cloud provider, I am sharing what I found here:
SaaS and cloud computing companies have wafer thin margins (a.k.a lower margin businesses). A...
|
|
-
|
|
Making sense of Search engine terms that drive web-traffic is hard, Visualizing it via Word-Cloud/Text-Cloud/Tag-Cloud makes it easy..It’s so amazing how you can take lines and lines of search queries and figure out which search term is more prominen...
|
|
-
|
|
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...
|
|