Anith Gopal

Visual Studio 2010 and .Net Framework 4.0 RTM is finally here! and is now available to students through DreamSpark, MSDN Academic Alliance (MSDN AA) For more Information visit the following Sites What’s New in the .NET Framework 4.0 What’s New in Visual Studio 2010 Quick Tour of the Integrated Development Environment MSDNAA MSDN AA Administrators can use the following steps to find VS 2010 in MSDN AA Go to http://msdnaa.net Sign in in the top right corner with your Windows Live ID Go to the ‘Downloads’ tab In the left-hand pane, expand Developer Tools Select Visual Studio 2010 Select the version you want and choose download including:  Visual Studio 2010 Professional, Visual Studio 2010 Ultimate, Visual Studio Team Foundation Server, Visual Studio Test Professional, etc Avail VS2010  to eligible students in your department Install  VS2010 in your labs for teaching and learning purposes DreamSpark: Visit  https://www.dreamspark.com/default.aspx   Sign In with your Windows LiveID , Get Verified and Download the tools If your University is not part of MSDNAA or DreamSpark ask your Lecturer / HOD or Head of IT Services to send an email to msap@microsoft.com for more information on how to be part of  MSDNAA or DreamSpark

Shawn posted a great writeup today talking about the changes to RenderTargets in GS4.

Navigating SQL Replication SubscriptionStreams setting Rishi Maini Microsoft SQL Escalation Services This blog posting discusses the new Distribution Agent SubscriptionStreams parameter.  This option reduces the latency when moving data from Distributor to Subscriber by using multiple parallel writer threads.  For more information on Replication “threads” see Transactional Replication Conversations blog posting. From SQL Books Online (good place to start) -SubscriptionStreams [0|1|2|...64] Is the number of connections allowed per Distribution Agent to apply batches of changes in parallel to a Subscriber, while maintaining many of the transactional characteristics present when using a single thread. For a SQL Server Publisher, a range of values from 1 to 64 is supported.

Note: Cross posted from Nothing geeky… .

To get the latest build of T4MVC: Go to T4MVC page on CodePlex   I just posted build 2.6.10.  There were also a few builds in between since I last blogged about 2.6, so this post describes some of those changes (full history here ).   Fluent route value API As you probably know, T4MVC uses a pattern where the route values are encapsulated using a pseudo-call to a controller action, e.g. Html.ActionLink("Delete Dinner", MVC.Dinners.Delete(Model.DinnerID)) This adds the controller, the action and the method parameters to the route values in a convenient way with no hard coded strings

Am starting 2010 by letting you know which tools I use to enhance my productivity and fun. Operating Systems Windows 7 [$] – I’m proud of what we accomplished with Windows 7.

James  wanned me to explain the set of steps I use to enable Convert-Media under a PowerShell remoting. First a disclaimer: running these steps will lower the security settings of your PC, use with caution.  Here there are: In your encoding server (mine is called tv-server): Enable-PSRemoting  -force # Enables remoting set-item WSMan:localhostClientTrustedHosts * -force # I am not running a domain controller, so my server needs to trust everybody set-item wsman:localhostShellMaxMemoryPerShellMB 1024 -force # The default allowed memory is very low, we need to bump it so that Convert-Media have room to work.

About a month ago, Sam Ng and I sat down with Charlie Calvert and his video camera to record an interview-style video about dynamic. Have a look! http://channel9.msdn.com/posts/CharlieCalvert/CSharp-4-Dynamic-with-Chris-Burrows-and-Sam-Ng/ If you view it, I hope you find it helpful and informative. Also, I clearly need to take some kind of instruction on what to do with oneself on video when the other person is talking.

Its been quite a while since I posted about MSF v2 CTP2. As promised in my earlier posts I will be doing a series of deep-dive of the new SyncServices features added in MSF V2 CTP2.

One of the nice features of Dynamics AX 2009 is the Export to Excel that is available throughout the product and allows to content of a Grid to be exported to Microsoft Office Excel for further analysis. Sometimes however the feature does not work as expected

We recently need to find all the data which was different in 300 SQL Replicated tables on a pair of database.  To find the differences, we were planning on using the TableDiff utility included with SQL 2005.  TableDiff Utility  http://msdn.microsoft.com/en-us/library/ms162843.aspx By default, the TableDiff creates a new *.SQL file for each table.  There is not a way to concatenate output from multiple commands.  Already you can see this wasn’t going to be easy.  We came up with a simple solution. –Build TableDiff commands for each Article then execute these commands select ‘”C:Program FilesMicrosoft SQL Server90COMtablediff.exe” -sourceserver [SKOR380] -sourcedatabase [TRANPUB] -sourcetable [' + name +'] -sourceschema [dbo] -sourcelocked [TABLOCK] -destinationserver [SKOR380] -destinationdatabase [TRANSUB] -destinationtable [' + name + '] -destinationschema [dbo] -destinationlocked [TABLOCK] -f c:tempTableDiff’ + cast(artid as varchar(100))+ ‘.sql’ from sysarticles Executing the SELECT statement we build a TEXT ouput of the unqiue TableDiff commands to execute in a CMD/DOS batch.  DOS, wow, now I’m dating myself! C:Program FilesMicrosoft SQL Server90COMtablediff.exe -sourceserver [SKOR380] -sourcedatabase [TRANPUB] -sourcetable [Order Details] -sourceschema [dbo] -sourcelocked [TABLOCK] -destinationserver [SKOR380] -destinationdatabase [TRANSUB] -destinationtable [Order Details] -destinationschema [dbo] -destinationlocked [TABLOCK] -f c:temp1.sql C:Program FilesMicrosoft SQL Server90COMtablediff.exe -sourceserver [SKOR380] -sourcedatabase [TRANPUB] -sourcetable [Orders] -sourceschema [dbo] -sourcelocked [TABLOCK] -destinationserver [SKOR380] -destinationdatabase [TRANSUB] -destinationtable [Orders] -destinationschema [dbo] -destinationlocked [TABLOCK] -f c:temp2.sql C:Program FilesMicrosoft SQL Server90COMtablediff.exe -sourceserver [SKOR380] -sourcedatabase [TRANPUB] -sourcetable [Shippers] -sourceschema [dbo] -sourcelocked [TABLOCK] -destinationserver [SKOR380] -destinationdatabase [TRANSUB] -destinationtable [Shippers] -destinationschema [dbo] -destinationlocked [TABLOCK] -f c:temp3.sql Executing these commands along with the COPY command builds on SQL file with all the necessary changes to bring the 2 servers in-sync.

  Bulk inserting using LINQ to SQL, why is it so slow? Well, the short answer is that it is not designed to do bulk inserts.   But out of curiosity, why is it slow?