Just found one great help from Aaron’s blog
http://blogs.msdn.com/b/astebner/archive/2012/02/29/10274694.aspx
Posted by Subhendu De on October 26, 2012
Just found one great help from Aaron’s blog
http://blogs.msdn.com/b/astebner/archive/2012/02/29/10274694.aspx
Posted in WP 7 | Tagged: XNA | Leave a Comment »
Posted by Subhendu De on October 17, 2012
Posted in Uncategorized | 1 Comment »
Posted by Subhendu De on August 21, 2012
– Disable all table constraints
ALTER TABLE MyTable NOCHECK CONSTRAINT ALL
– Enable all table constraints
ALTER TABLE MyTable CHECK CONSTRAINT ALL
– Disable single constraint
ALTER TABLE MyTable NOCHECK CONSTRAINT MyConstraint
– Enable single constraint
ALTER TABLE MyTable CHECK CONSTRAINT MyConstraint
Posted in T-SQL | Leave a Comment »
Posted by Subhendu De on August 1, 2012
Posted in ASP.NET | Leave a Comment »
Posted by Subhendu De on February 11, 2012
Posted in ASP.NET | Leave a Comment »
Posted by Subhendu De on January 11, 2012
Posted in Uncategorized | Leave a Comment »
Posted by Subhendu De on November 24, 2011
When I first started to host my website using Windows Azure SDK, I found errors related to initialization of SQLEXPRESS instance. A good and helpful link is available
http://blog.nimbo.com/error-failed-to-initialize-windows-azure-storage-emulator/
Posted in Uncategorized | Leave a Comment »
Posted by Subhendu De on July 23, 2011
Posted in Uncategorized | Leave a Comment »
Posted by Subhendu De on January 15, 2011
Posted in Azure | Leave a Comment »
Posted by Subhendu De on January 13, 2011
I was having some leisure time to dig into the much hyped Azure. We set up one sandbox to start learning and developing applications in Windows Azure, SQL Azure and Windows Azure AppFabric. In order to setup my account to access SQL Azure database, I found that the created database for SQL Azure was not able to connect by SSMS. I further asked my colleague to help me and found SQL Azure database can only be opened through SSMS 2008 R2 only.
One workaround if you are not using SSMS 2008 R2, you need to cancel the connect dialog, then open “New Query” and select “Options” and “Connect to Database” selection box, click on “<Browse servers …>”. In this box, your server is visible and you can easily locate your database. But in Login pane, please provide the server name and credentials. One disadvantage is you cannot see the database objects in your object explorer.
Today, I found one catchy application codename Houston…. Really it’s a very cool application to have everything just like SSMS online version. Try it guys…. https://manage-hkn.cloudapp.net/
Will update you, if I find more……
Posted in Azure | Tagged: Codename Houston, SQl Azure | Leave a Comment »