Wow!! This the word I exclaimed when I first saw Visual Studio Online. This is combination of collaboration, planning, version control tools and over cloud. Exciting??!! Actually this is not something new, Microsoft has renamed their existing Team Foundation Service as Visual Studio One.
As soon as I installed Visual Studio 2013, it asked me to create http://___.visualstudio.com profile. That’s it!!! I am now ready with all above said combination of tools to start.
You can choose among TFS and Git as your version control system and this gets integrated with your Visual Studio IDE. So as you create the project, you can start collaborating with your team members. Also there are various out of box agile/scrum templates to manage your epic, stories and iterations. In addition to these, VSO (Visual Studio Online) has quality related tools integrated. You can do code reviews, build, test plans, test case execution etc.
Advanced VSO even provide lighter version of Visual Studio to edit code, automated builds, load tests, etc. With Visual Studio Online, Microsoft is offering broad range of tools and services that support the different kinds of development code named “Monaco” specifically designed for building and maintaining Windows Azure Websites.
Here we have a new version of Microsoft Visual Studio, Visual Studio 2012.
This new version is coming out at the time of diversification of computing technology and platform. So this new version is loaded with new capabilities for Windows 8, the web, SharePoint, mobile, and cloud development.
This new version has brought a lot of new and interesting features. Out of which today I was more exited with feature “Paste XML as Classes”.
Paste XML as Classes
Say you have a well formed XML file and need to deserialize it to a fully qualified .Net type objects. Building this manually is a very dull and monotonous job. Visual Studio 2012 has a new feature “Paste XML as Classes”.
Below is one sample well-formed XML.
Copy the XML content and open a new class file. From the menu select select Edit | Paste Special | Paste XML as Classes as shown below.
Visual Studio will automatically generate the code as shown below.
My daily work involves connecting to several number of database servers and this involves me to remember server name or IP, port number, User Id and Passwords of those servers. Number of servers I connect is more than 20 and due to this huge number I tend to forget the IP address, password etc. I can use the option of remember password, which will remember and list all the required server details with user id and password.
But the problem starts once you need to connect to a particular database server using more than one User Id. Once you use 2nd user id, SQL Server Management Studio fails to remember any of the passwords for that server.
So what is the solution?
SQL Server Management Studio has an option to manage server details, i.e. Registered Servers. By registering the server connection in the Registered Servers component of SQL Server Management Studio you can save the connection information for servers that are accessed frequently.
This option can be found under View menu.
A separate window will appear on the left hand side of the SSMS along with Object explorer. On right-clicking on Local Server Groups, option to register new server or to create new server group will appear. Creating Server group is optional but it will help in managing large number of server connections by logical grouping.
When Server Registration is opted, below window will appear. Opt for remember password option to remember the server connection.
In the above window you will find another tab which can be used to customize the connection further.
- Default database can be set here, so that every time you connect to a particular server from the registered server option, it will by default connect to the default database.
- Choose custom color for each server connections, so that one can easily differentiate between each connection.
I had 32 bit version of Windows 7 running in my PC with 4 GB of RAM. To improve my machine performance my organization gave another 4 GB of RAM. I added these new RAM to machine but my machine did not recognize newly added extra RAM. Bing on this issue revealed the fact that Windows 7 or Vista can support only up to 3.6 GB of main memory.
This required me to upgrade my OS to Windows 7 64 bit. Than I had to download few dev softwares form MSDN. As usual logged into MSDN page and tried to download. I could not download any software instead each try I was getting below pop-up message.
VBScript: Microsoft File Transfer Manager
There was an error launching File Transfer Manager.
If you are running Windows XP with Service Pack 2 or Windows Server 2003 with Service Pack 1, this installation may have been blocked. If the gold IE Information Bar is Present above, please click the bar and select the option to “Install ActiveX”.
For additional assistance, please visit the web site https://transfer.ds.microsoft.com, or contact your help provider.
So I had no clue why this is appearing. So did a Bing again and found that this issue caused because I was using 64bit version of Internet Explorer. So than I used IE 32 bit version and able to download softwares from MSDN.
Since I have 64 bit version of OS thought of installing all 64 bit version software available. So I downloaded Office 2010 64 bit version and installed. Now the new trouble started. None of your old Office add-ins worked with new Office. My Office communicator could not find any mail client installed and every time I open either Office communicator or Outlook I started getting below message box.
So again did some Bing. But for my bad luck there is no solution available for my problem yet. Answer to the problem is none of my old Office add-ins will work in the 64-bit world. They have to be rewritten and recompiled specifically for 64-bit Office 2010. In some cases, programming controls commonly used in the 32-bit world aren’t even available in 64-bit. And moreover only benefit of 64 bit version of office is ability to handle spread-sheet size larger than 2 GB which in any near future I will not need. So the recommendation is avoid installing 64 bit version of Office 2010.
I came across a scenario where I had to optimize the stored procedure which was lengthy and using multiple locks to do the required operation. Objective of the stored procedure is to allocate slots based on some conditions. Operations involved:
- Select few top rows based on slot status and some other conditions.
- Update its status as allocated.
- Return allocated slot ids to the user.
Below is the dress downed version of actual lengthy code.
SELECT TOP 3 * INTO #tempslot FROM dbo.ExamSlot IES WITH (NOLOCK)
WHERE IES.slot_status = 0
ORDER BY 1 DESC
SET slot_status = 1
FROM dbo.ExamSlot ES WITH (ROWLOCK)
INNER JOIN #tempslot TS ON ES.slot_id = TS.slot_id
SELECT ES.slot_id FROM dbo.ExamSlot ES WITH (ROWLOCK)
INNER JOIN #tempslot TS ON ES.slot_id = TS.slot_id
Below is the single statement to achieve above objective.
SET SLT.slot_status =0
FROM (SELECT TOP 3 * FROM dbo.ExamSlot IES WITH (HOLDLOCK)
WHERE IES.slot_status = 1
ORDER BY 1 DESC) AS SLT