|
|
-
|
|
Recently at SQLRally, Rushabh Mehta sir pointed me to a great BigData resource. It was a great read and thought it could help you too. So, If you want to get started on the world of BigData, then there’s a resource that could be of help:
Oreilly̵...
|
|
-
|
|
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 ...
|
|
-
|
|
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...
|
|
-
|
|
In this blog-post, I am going to create a stored procedure that accepts a parameter with SQL Azure.
So I have a table that lists firstname, lastname of the customer along with location details. Here’s what it looks like:
And just note that I running...
|
|
-
|
|
I got a chance to play with power-view which seems like great feature of SQL Server 2012! And I liked it that we can create Hans Rosling styled BI dashboard’s with Powerview. For those who do not know about Hans Rosling presentations, check these col...
|
|
-
|
|
Added couple of new ideas to the mygreatwindowsazureidea.com site and so If you liked these ideas, Go vote! And also add your ideas on the site and let me know!
just a quick summary of few ideas I have submitted on http://www.mygreatwindowsazureidea.com
...
|
|
-
|
|
Answer: No.
Though SQL Azure does need that a table has a clustered index. So to this end, Let’s write some TSQL code and cement this concept in our brain. So as a part of the test, we would create a table with no primary key – However we would...
|
|
-
|
|
SlideDeck: Introducing SQL Server Data Services
Video: Introducing SQL server Data services:Here’s the Announcement: Announcing SQL Server Data Services
It’s interesting to me how SQL Azure has been evolving at an amazing pace! And we forget...
|
|
-
|
|
I recently learned that information design has two golden rules:
1. Show the Data
2. Show Comparisons
Two golden rules of information design: 1. Show the Data 2.show comparisons. Source: goo.gl/zlAhc
— Paras Doshi (@paras_doshi) February 16, 2012
So I th...
|
|