An AJI Software Community
BLOGGER LIST

(1693, 5/10/2012)  
(1487, 5/17/2012)  
(1350, 5/04/2012)  
(765, 12/22/2011)
(733, 4/04/2012)
(684, 4/25/2012)
(650, 5/17/2012)
(603, 2/24/2012)  
(489, 4/30/2012)  
(468, 5/15/2012)
(460, 1/15/2012)  
(367, 4/21/2012)
(334, 4/12/2012)
(298, 5/09/2012)
(294, 4/18/2012)  
(284, 3/21/2012)  
(278, 4/26/2012)
(276, 4/28/2012)
(274, 5/16/2012)  
(273, 3/30/2012)
(263, 5/11/2012)
(253, 3/26/2012)  
(248, 3/10/2012)  
(218, 5/07/2012)
(210, 3/14/2012)  
(201, 3/30/2012)  
(194, 11/19/2011)  
(193, 3/12/2012)
(190, 3/18/2012)  
(187, 5/08/2012)  
(187, 11/18/2011)
(186, 3/29/2012)  
(181, 3/21/2012)
(177, 5/15/2012)  
(168, 5/09/2012)
(153, 4/19/2012)
(148, 12/19/2011)
(147, 4/10/2012)
(144, 3/20/2012)
(142, 5/13/2012)
(134, 3/09/2012)  
(133, 5/16/2012)
(133, 12/11/2011)  
(132, 12/17/2011)  
(130, 4/30/2012)  
(128, 5/03/2012)
(123, 5/11/2012)  
(119, 4/28/2012)
(116, 4/02/2012)
(114, 12/12/2011)
(111, 5/07/2012)  
(111, 3/13/2012)
(111, 5/01/2012)
(108, 5/17/2012)  
(107, 5/02/2012)
(106, 4/09/2012)
(102, 11/29/2011)
(100, 12/04/2011)
(97, 5/16/2012)
(96, 5/03/2012)
(95, 2/29/2012)
(90, 5/14/2012)  
(86, 4/27/2012)
(82, 1/17/2012)
(82, 5/06/2012)  
(82, 5/15/2012)
(81, 4/20/2012)
(77, 4/26/2012)
(77, 5/16/2012)
(74, 3/11/2012)
(73, 11/29/2011)
(73, 5/09/2012)
(71, 4/09/2012)
(68, 3/26/2012)  
(68, 2/21/2012)
(67, 12/16/2011)
(65, 12/27/2011)
(64, 11/24/2011)
(62, 4/25/2012)
(61, 5/11/2012)
(61, 2/06/2012)
(60, 2/06/2012)
(59, 3/20/2012)
(59, 11/29/2011)
(58, 4/17/2012)
(57, 5/16/2012)  
(56, 5/18/2012)  
(54, 4/13/2012)
(54, 3/10/2012)
(54, 2/26/2012)
(53, 3/24/2012)
(50, 1/18/2012)
(50, 1/27/2012)
(49, 2/29/2012)  
(49, 5/11/2012)
(49, 5/08/2012)
(48, 3/13/2012)
(48, 3/04/2012)
(48, 4/05/2012)
(47, 1/29/2012)
(47, 4/11/2012)
(45, 3/05/2012)
(45, 4/25/2012)  
(44, 4/07/2012)  
(43, 5/17/2012)
(43, 4/17/2012)
(41, 4/25/2012)
(41, 5/13/2012)  
(41, 5/14/2012)
(40, 2/10/2012)
(40, 2/09/2012)
(40, 4/16/2012)
(39, 5/02/2012)
(38, 3/07/2012)
(38, 4/07/2012)
(37, 1/29/2012)
(37, 5/05/2012)
(36, 12/19/2011)
(36, 4/16/2012)
(36, 1/03/2012)
(36, 5/16/2012)
(35, 12/27/2011)
(35, 1/17/2012)
(35, 12/02/2011)  
(35, 4/12/2012)
(33, 2/24/2012)  
(33, 5/01/2012)
(32, 4/12/2012)
(32, 12/30/2011)
(31, 2/21/2012)
(30, 4/25/2012)
(30, 1/05/2012)  
(29, 5/06/2012)
(28, 5/05/2012)
(27, 4/17/2012)  
(27, 4/02/2012)
(27, 4/26/2012)
(26, 4/27/2012)
(26, 3/29/2012)
(25, 5/16/2012)
(25, 4/26/2012)
(25, 1/24/2012)
(24, 4/18/2012)
(24, 5/04/2012)
(24, 11/21/2011)
(24, 12/27/2011)
(24, 5/02/2012)
(24, 4/16/2012)
(23, 1/25/2012)
(22, 5/15/2012)
(22, 3/13/2012)
(21, 3/15/2012)
(21, 4/27/2012)
(20, 12/12/2011)
(20, 1/13/2012)
(19, 5/17/2012)
(19, 1/30/2012)
(19, 5/06/2012)
(19, 5/14/2012)
(19, 5/02/2012)
(18, 2/15/2012)
(18, 12/27/2011)
(18, 4/04/2012)
(18, 2/17/2012)
(18, 11/23/2011)
(18, 2/23/2012)
(17, 3/07/2012)
(17, 1/09/2012)
(17, 1/04/2012)
(17, 3/28/2012)
(17, 3/07/2012)
(17, 4/20/2012)
(17, 2/07/2012)
(16, 1/14/2012)
(16, 4/03/2012)
(16, 3/09/2012)
(16, 3/10/2012)
(16, 5/06/2012)
(15, 2/13/2012)
(15, 3/21/2012)
(15, 3/28/2012)
(15, 2/05/2012)
(14, 2/04/2012)
(14, 1/06/2012)
(14, 11/29/2011)
(14, 2/17/2012)
(13, 3/13/2012)
(13, 4/29/2012)
(13, 5/13/2012)
(12, 4/02/2012)
(12, 3/17/2012)
(12, 3/11/2012)
(12, 1/10/2012)
(12, 1/25/2012)
(12, 1/31/2012)
(12, 2/02/2012)
(12, 4/26/2012)
(11, 4/17/2012)
(11, 1/05/2012)
(11, 12/19/2011)
(11, 2/14/2012)
(11, 4/14/2012)
(11, 3/12/2012)
(11, 5/03/2012)
(11, 1/13/2012)
(11, 4/25/2012)
(11, 5/17/2012)
(11, 4/27/2012)
(10, 3/15/2012)
(10, 2/09/2012)
(10, 3/28/2012)
(10, 3/28/2012)
(10, 4/11/2012)
(10, 12/22/2011)
(10, 4/08/2012)
(10, 5/09/2012)
(9, 2/08/2012)
(9, 4/24/2012)
(9, 5/16/2012)
(9, 2/29/2012)
(8, 5/03/2012)
(8, 12/16/2011)
(8, 4/24/2012)
(8, 11/29/2011)
(8, 5/04/2012)
(7, 4/17/2012)
(7, 1/22/2012)
(7, 3/08/2012)
(6, 5/15/2012)
(6, 5/14/2012)
(6, 4/06/2012)
(6, 3/28/2012)
(6, 4/13/2012)
(5, 5/16/2012)
(5, 3/30/2012)
(5, 4/22/2012)
(5, 3/12/2012)
(5, 4/08/2012)
(5, 4/30/2012)
(5, 3/15/2012)
(5, 4/23/2012)
(5, 3/26/2012)
(5, 5/03/2012)
(5, 3/27/2012)
(5, 4/27/2012)
(4, 3/01/2012)
(4, 3/04/2012)
(4, 12/12/2011)
(4, 3/01/2012)
(4, 4/12/2012)
(4, 4/26/2012)
(4, 1/23/2012)
(4, 11/23/2011)
(4, 4/14/2012)
(4, 3/07/2012)
(4, 2/22/2012)
(4, 3/11/2012)
(4, 2/28/2012)
(4, 4/24/2012)
(4, 5/17/2012)
(3, 11/21/2011)
(3, 12/27/2011)
(3, 11/23/2011)
(3, 12/01/2011)
(3, 12/10/2011)
(3, 4/06/2012)
(3, 4/02/2012)
(3, 1/08/2012)
(3, 2/12/2012)
(3, 5/13/2012)
(3, 3/29/2012)
(3, 5/12/2012)
(2, 4/10/2012)
(2, 12/23/2011)
(2, 2/05/2012)
(2, 2/20/2012)
(2, 11/24/2011)
(2, 2/07/2012)
(2, 2/20/2012)
(2, 2/18/2012)
(2, 11/24/2011)
(2, 12/07/2011)
(2, 12/27/2011)
(2, 2/26/2012)
(2, 1/19/2012)
(2, 4/07/2012)
(2, 5/17/2012)
(2, 4/04/2012)
(1, 5/08/2012)
(1, 1/08/2012)
(1, 2/24/2012)
(1, 3/19/2012)
(1, 2/15/2012)
(1, 3/21/2012)
(1, 1/03/2012)
(1, 1/15/2012)
(1, 12/31/2011)
(1, 11/24/2011)
(1, 11/22/2011)
(1, 11/21/2011)
(1, 12/05/2011)
(1, 12/06/2011)
(1, 12/08/2011)
(1, 12/31/2011)
(1, 2/07/2012)
(1, 2/08/2012)
(1, 3/01/2012)
(1, 3/12/2012)
(1, 3/14/2012)
(1, 3/30/2012)
(1, 5/13/2012)
(1, 5/11/2012)
MOST POPULAR TOPIC
Joe Mayo | 5/11/2012 | 0 Comments
Over the last several months, I’ve been modifying LINQ to Twitter to support multiple platforms. Originally, I had targeted full profile .NET, ASP.NET Web Forms, and ASP.NET MVC apps. An easy stop along the way was Mono compatibility, but that was simple
POSTSTWITTERCOMMUNITY NEWSFEATURED BLOGGERS
SharePoint 2010 provides a number of templates for creating new sites. Most organizations will decide for you which SharePoint templates you're going to use; it’s usually either a Team Site template or a Publishing Site template. The other templates are specialized. Product Available Site Templates Typical Usage Scenarios SharePoint Foundation 2010 Team Site, Meeting Workspace, Blog More people contribute content than read it; also when you want basic layouts SharePoint Server 2010, Standard license;...
If you did not pay attention to the last step before publishing an InfoPath 2010 form to a SharePoint server and you are facing a lot of problems because the publish created duplicate columns. Look no further, this post will make your life easier.A lot of us use InfoPath and have to deal with its annoying bugs day in and day out. But we just have to be more careful and aware to avoid any situations where there's no second option.Today, I was working with an InfoPath form, and was converting a regular...
Once again, in this series of posts I look at the parts of the .NET Framework that may seem trivial, but can help improve your code by making it easier to write and maintain. The index of all my past little wonders posts can be found here. We’ve talked about the Select() and Where() LINQ extension methods before. The Select() method lets you project from the source type to a new type, and the Where() method lets you filter the list of items to the ones you are interested in. Most people know of these...
 
This might not be news to you but for me this was a discovery i made only this week, yes how did i not know this before! So I discovered how to pin any folder to the Windows Explorer jump list on the Windows 7 task bar. Any entries in the 'Frequent' menu can be pinned using its context menu, but a folder that does not appear in the 'Frequent' menu can still be pinned just by dragging its path from the address bar in the Explorer window onto the task bar icon. The pinned folders can then be accessed...
 
I've used this enum helper from time to time to get an enum value from attributes such as Description and XmlEnumAttribute. Maybe you can find it useful? public static class EnumEx { public static T GetXmlEnumValue<T>(st... name) { var type = CheckEnum<T>(); var val = (from f in type.GetFields() let attribute = f.GetCustomAttributes(typeo... true).FirstOrDefault() as System.Xml.Serialization.Xm... where attribute != null &&...
 
Get ready for a cool event on June 7th. Register to watch live (starting at 1PM PDT): here – The event will be presented by Scott Guthrie. To keep updated on this event follow the twitter conversations @WindowsAzure, #MEETAzure, #WindowsAzure. You can also register for the social meetup on Twitter event, organized by MVP Magnus Martensson. I assure you; you don’t want to miss this event… MEET Windows Azure Blog Relay: Roger Jennings (@rogerjenn): Social meet up on Twitter for Meet Windows Azure on...
We’re having a shindig at my work today, Online Business Systems, to celebrate making the “Best Workplaces in Canada” list for the 6th consecutive year. This is a big deal for us, as we put a lot of work and effort into ensuring that our workplace is attractive to top talent, offers fantastic professional development opportunities, and provides challenging & meaningful work. I’ve worked at a lot of technology consulting companies in Winnipeg, and I can honestly say that Online is hands down the...
 
I was setting up a search service application today and enabling search and crawling content sources.But i decided to test the "Web Analytics Web Part".But when i added it i got the error: There are no addresses available for this applicationCheck that you started the “Managed Metadata Web Service”. This can be found here: Central Admin > System Settings > Manage Services On ServerCheck that you started the “Managed Metadata Web Service”. Hope that helps...
Hi,The recording of the webinar we did with Forrester Research recently is now available. At this opportunity I would like to thank Jefferey Hammond of Forrester who did a great job in discussing the Open Web, Cloud computing and Mobility trends and presenting the new development challenges they bring and why organizations need to rethink their application development strategies. The 2nd part of the webinar is a presentation from Gizmox, discussing the Instant CloudMove assessment and transposition...
 
Stylecop 4.7.22.0 has been released at http://stylecop.codeplex.co... included a fix to a problem I reported at http://stylecop.codeplex.co... well done Andrew and team...
It’s a Friday evening and you have just checked in that last bit of code, you are waiting for the build to go all green so that you could call it a day. Just then the build summary page comes back red on the test results section. The build summary page tells you that 1 of the test namely HelloWorld.Tests.UnitTest1.... has failed… To know why the test has failed, you have no option but to click on View Test Results link which in turn downloads the trx file...
 
When installing SQL Server 2008 R2 (Developer, Standard, or Enterprise) within a Virtual PC you may suffer the following problem: “The following error has occurred: The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2337.” The error occurs in the following package: sql_engine_core_shared It turns out that this problem is with the DVD/ISO Mounting Feature in Windows Virtual PC. To workaround the problem you need...
 
Recently I had a need to write some tests making Web Api calls that would be deployable to the build server without any special configuration.What I did was utilize the Self Hosting feature in the Asp.NetWebApi. First, I created a simple Api controller . // GET /api/values public class ValuesController : ApiController { public SomeObjects GetByName(string firstName, string lastName) { var someObjects= new List<SomeObject>() { new SomeObject { FirstName = "Tom", LastName = "Jones", Id= 1213...
Visual Studio and Team Foundation Server (TFS) 2010 provided support for system testing. Test cases were added as a work item type. But test plans and suites are not work items and this greatly limits the visibility into the management of test artifacts. For example, there is no easy way out-of-the-box to find test cases that don’t belong to a test plan. Here’s the SQL that creates a list of test cases providing the test case: ID Title State Assigned To Area Path Iteration Path Plan and Suite Path...
 
Although it doesn’t have any specific tools to help responsive or mobile site design this is still possible in Expression Web and I’ve created a number of snippets to help the process. HTML5 and CSS3 are the key to responsive design, so the snippets cover the new HTML5 layout elements, form input types and microdata tags, and the CSS3 snippets cover box-radius, box-shadow, gradients etc. The mobile snippets include the CSS3 media queries, mobile meta tags and the responsd.js shim that enables older...
So as you know I am yet again involved in SPS NYC with my awesome teammates, Greg Hurlman, Jason Gallicchio, Tasha Scott, and Tom Daly. The speakers have finally been picked and a first draft schedule has been posted at http://www.sharepointsaturd... We are also still looking for sponsors if you guys are interested you can also click on the link to grab the form, sign it, and send it to sponsors@spsnyc.com. We are also looking for volunteers and you can fill out the form at the same place...
So as you can see this blog has not been the best in the world lately. Life changes and burn out are killing me lately. Don’t get me wrong I love my job. I love writing things in Visual Studio, in fact this week I got to work with MVC3 for the first time ever. I am completely hooked on MVC3 and will further explore that in the upcoming months. I have entertaining a completely different idea, because I think it would be fun and interesting. The downside is it involves me buying an Apple computer....
Microsoft had just released a new website http://www.meetwindowsazure... which announced an outstanding event named “MEET Windows Azure”. There will be some awesome new features and releases being published around the Windows Azure Platform, the cloud computing platform and cloud-based technologies Microsoft offers. From what I know, this might be the biggest innovation in Windows Azure till now. The event will be hosted at 1pm PDT, June 7th at the Madrone Studio in San Francisco with limited sites....
public static class QueryableExtensions { public static IQueryable<T> Filter<T>(this IQueryable<T> queryable, IEnumerable<KeyValuePair... string>> filters) where T : class { foreach (var filter in filters) { var propertyName = typeof(T).GetProperties().S... => x.Name).SingleOrDefault(x => x.ToLower() == filter.Key.ToLower()); if (propertyName.IsNullOrWhite... continue; var parameterExpression = Expression.Parameter(typeof... var propertyExpression...
I came across this the other day. Using SQL 2000 I could not get a Top statement to work with a variable. I had forgotten that only with SQL 2005 and higher could you do this trick. I found a good way around it, you can read about it here. Anyway this works on SQL 2000: declare @top intset @top = 5 BEGINset rowcount @top select Some_ID from tblStuffset rowcount 0END The code above would return the first five records from tblStuff. For any of the newer SQL Server version you can simply use the @top...
I know there are afew places where you can check out the differences between Sass or Less, but I thought it may be helpful for others to know why I chose one over the other.Here are some of my sources:http://sass-lang.co... my main decision was affected by my IDE I need to mention my development environment:Visual Studio...
There is some helpful information from Ewald Hofman on passing in parameters to the TFS SQL Server Analysis Services OLAP reports. But, the 2010 schema has changed. You can use the SQL Server Mgmgt Studio to access the metadata and query the tables to seee the new schema and record values. As an example of the Task Burndown report on the TFS 2010 Project Portal, here's the URL that worked in a browser: http://{your tfs server}/Reports/Pages/Repor...
My goal was to have the burndown chart on the team project portal main page display the current iteration. The default report displays the tasks for the entire team project starting 5 days before the current date and ending 25 days after the current date. FRUSTRATING, to say the least! I mean, what a useless report! Who's Agile book did they get that one from? What I wanted was to see the burndown for the current iteration. That is, tasks for that iteration only and that iteration starting on a fixed...
We don’t use the term “Bug,” rather we use “Software Action Request” or “SAR.” I renamed the Bug WI definition from Bug to SAR. I added a few custom fields to our SAR WI definition, but all the Microsoft fields are used and unchanged. What I want is for the MTLM client to be configured to open a SAR rather than a Bug. In other words, out-of-the-box when a user is manually executing a test case with the MTLM Test Runner client and one of the steps fail, the user clicks a button to create a Bug or...
When using TFS work items you may find that when you transition from one state to another that you selected the wrong reason code, or you found out shortly afterwards that the reason code you selected is incorrect. Well, you may be surprised to find that reason codes (System.Reason) cannot be updated within the same state. After some looking into, I came to understand the intent of reason code is to document the "reason" the state changed. As opposed to indicate within state changes. However, it...
Tomorrow I will be presenting “Building Scalable Apps in Windows Azure” at VS Live in New York City. I will be co-presenting with my colleague Vishwas Lele of Azure fame. Should be a great event...
I loved RIL Pro for iPad and used it every day, but about a month ago I was forced to upgrade to new version, named Pocket.The new version has so many problems, that it's almost unusable.The main issue is that iPad app doesn't show many of the saved links. I've posted my opinion that it would be better to have Pocket as a new separate application and recommend users to install it side by side with RIL Pro and try before replace at Pocket forum APR 20, 2012 http://help.getpocket.com/c...
 
Since the 2012 Transit of Venus is the last transit of Venus across the face of the Sun as viewed from Earth, for many years, being able to locate a web cam feed that will be in clear daylight for the whole of the transit period. So far I have only located one. This is at: http://www.transitofvenus.c... the transit of Venus was very important for determining the absolute size of the solar system, however high power radar has allowed direct measurement of distance at any time...
 
Stepping through IWindsorInstaller implementations in web services created using the WcfFacility[1] is not as immediately accessible compared to debugging the start up of a console application. Just pressing F5 with the web service set as a start up project causes the start up code to have already been run before the debugger attaches to the IIS worker process. Fortunately there is a simple way of causing the start up code to be re-run whilst remaining attached to the IIS worker process, so that...
 
I'm running Mahara in a Windows Server 2008 environment using Apache web server and just for fun I wanted to enable SSL :-). I setup SSL and tested the setup using a self-signed certificate, all good, SSL was working. I requested a server certificate from our corporate CA, which is an intermediate CA for GlobalSign, this was done using an online MS certificate server service. When the certificate was ready, I revisit the site, and the certificate is installed automagically into the current user certificate...
 
After configuring user profile you get the correlation id and in event logs you get The Forefront Identity Manager Service cannot connect to the SQL Database Server. The SQL Server could not be contacted. The connection failure may be due to a network failure, firewall configuration error, or other connection issue. Additionally, the SQL Server connection information could be configured incorrectly. Verify that the SQL Server is reachable from the Forefront Identity Manager Service computer. Ensure...
Everyone has done it, you know you have too. When someone asks you for a status update on a new feature you just finished coding, you say "That's Done!" Think about what you just said for a minute, is it really done? Can someone use that feature in production for its intended purpose? That's really what done means, right? To the end user, done means its up and running, in production, providing value. Code complete is just another stage in the pipeline getting us out to really done. You may say, that...
 
In answering this question it helps to look at the overall creation of a website and the processes involved.The term 'web design' still in common use, is something of a misnomer. 'Web creation' seems to be a better term and it involves three distinct processes.The design of the ‘look and feel’ of the site or the ‘UI’. This is often (and best) done by someone with artistic or graphic design skills, but with an appreciation of what is possible on the web. This is the real ‘design’ activity.The translation...
 
Stylecop 4.7.20.0 has been released at http://stylecop.codeplex.co... Notes Compatible with the Visual Studio 11 Preview.Install order should be : VS10VS11R#6.1.1 msi (for VS10)R#6.1.1 vsix (for VS11)StyleCop 4.7 This version is now compatible with R# 5.1 (5.1.3000.12), R# 6.0 (6.0.2202.688), R# 6.1 (6.1.37.86) and R# 6.1.1 (6.1.1000.82).Here are the bug details for fixed in 4.7 and closed in 4.7 issues (over 100 issues fixed since 4.6)Here are the bug details for all issues...
So I have decided to hold a community dinner the first week of June. I invited a bunch of MS community members who run user groups or contribute a lot in the NYC Metro area. If anyone is interested drop me comment on this blog with your email address. I won’t publish the comment with your email in case you don’t want everyone to see your address. I just figured that some people might see this blog that I missed via email. I am also going to spam the main community list for njny metro area. Hopefully,...
A few weeks ago, I had the privilege of being able to participate in Conestoga College’s Software Engineering Technology project demo day as a guest judge, along with 4 other members of the IT community. This event is held every year at the end of April, and provides graduating students the opportunity to present their group projects to those in attendance, discussing the business problem it solved, the challenges they faced, how they addressed those challenges, and the future direction they have...
 
Here's a short tutorial on how to use log4net in C#1. Get log4net from the apache website.2. Open your project with visual studio.3. Add the reference to your project: You find the reference in the zip that you just downloaded: \bin\net\xxx\release\log4ne... xxx is your .net version.4. Add the Appender section to your app.config. The following code uses a file for the logging: <configuration> <configSections> <section name="log4net" type="log4net.Config.Log4Ne...
Today is a day to celebrate mother’s everywhere. There will be breakfasts cooked, cards opened, gifts given, brunches and dinners shared. There will be church services where mothers are given flowers from their children and sermons will talk of the blessings mothers are. People who aren’t even related will wish others who are mothers a “Happy Mother’s Day”. And all of this will go on without any consideration or thought to the forgotten mothers in our midst. For many, mother’s day (and father’s day)...
 
Photo quality aside, it seems that Canon DSLRs are more popular than Nikon DSLRs right now based on Flickr stats.Below is a ranking of popularity based on daily users (taken from Flickr.com)Canon Camera (Average daily users)EOS 5D Mark II (4350) $2500EOS REBEL T2i / 550D (3908) $500-$600EOS 7D (3577) $1500-$1800EOS REBEL T1i / 500D (2507) $400-$500EOS 60D (2219) $800-$1300Nikon Camera (Average daily users)D90 (3985) $1000-$1200D7000 (2664) $1200-$1500D3100 (2173) $500-$700D700 (1912) $2200-$3000D5000...
HiIf you have good debugging skill then you can save lots of time. In visual studio lots of options are available for debugging. Here are some good URL for debugging. It will be really useful in our daily working project.http://www.codeproj...
One of my colleagues asked how to create SQL query to show results as columns of a row, that actually stored in multiple rows in the table. Other co-worker suggested to use cursor to manually generate required rows.I’ve found a few links about SQL PIVOT. It is easy to start withhttp://www.kodyaz.com/a... or http://programmingsolution.... More detailed are articles...
 
This week I was working with a customer and one of the interesting things in the organisation is that they have a fairly large investment in BizTalk but in general few people in the organisation are knowledgeable about how important a role it plays. I decided it might be interesting to do a small PR exercise; I would write a little post with 10 bits of information about their BizTalk investment that they might not be aware of. It was also interesting that I found out a few things that I didn't know...
 
Very simple, but a handy way of viewing nicely-formatted JSON in LINQPad: I use Json.NET as it does indented formatting, and represents JSON dates properly. To add as an extension, download Json.NET, add a reference to Newtonsoft.Json.dll to your “My Extensions” query and add the following code to your MyExtensions class: public static object DumpJson(this object value, string description = null) { return GetJsonDumpTarget(value).Du... } public static object DumpJson(this object value,...
Where’s Daddy? My wife, one year old daughter and I play a game that most other parents have played at some point; my wife will hold her and ask her "Where’s daddy?” and the response is invariably a wide-eyed scan of the room by my daughter, culminating in a big snotty slobbery smile when she locates me. This is a game and is fun for her but it is an important exercise for linking a name and role with a face for her and for enforcing the idea that when she looks for me, she will find me. So what...
Over the last several months, I’ve been modifying LINQ to Twitter to support multiple platforms. Originally, I had targeted full profile .NET, ASP.NET Web Forms, and ASP.NET MVC apps. An easy stop along the way was Mono compatibility, but that was simple because Mono is good about running any CLR app. The code-base was good until I started porting to Silverlight. Porting to Silverlight Silverlight requires a different type of class library, so right-away I couldn’t use the same libraries as the full...
TechEd 2012 Orlando Blogger Hub We are proud to announce today that Geekswithblogs.net will be at Microsoft TechEd 2012 in Orlando, hosting the Blogger Hub for the event. This area in the Expo Hall will be dedicated to blogging. If you need a spot to gather your thoughts, grab some power, and write a blog post, we will have it. If you need to talk with a veteran blogger to help you gather ideas for your blog, information on how to get started, or how to find your blog’s voice, swing by and we will...
 
Microsoft press are offering 50% off Access books at http://shop.oreilly.com/cat... Powerful Database Solutions with Access Save 50% on Related Ebooks – One Week Only Learn the secrets of this powerful database program so you can use your data in creative ways -- from creating product catalogs and publishing information online to producing invoices and reports."...
 
Today, O'Reilly are offering a free e-book "What is Dart?" at http://shop.oreilly.com/pro... ready to build modern web apps. This concise book covers the Dart language, libraries, and tools that help you develop structured, fast, and maintainable web apps that run in any modern browser. The Dart platform has been designed to scale from simple scripts to complex apps, running on both the client and the server. With this book, you can use Dart to architect and develop HTML5 apps...
 
Those nice people at Jetbrains have have just released DotPeek 1.0. The notice at http://blogs.jetbrains.com/... states:"Free .NET decompiler and assembly browser from JetBrains is now officially live! Please download dotPeek 1.0 and enjoy high-standard decompilation with ReSharper-inspired navigation and search!"There is even a video on that page describing using DotPeek...
 
Jetbrains at http://blogs.jetbrains.com/... have released the following:"ReSharper 7 EAP opened up just over a month ago providing early support for Visual Studio 11. We have now opened this up also to other editions of Visual Studio, specifically 2005, 2008 and 2010. As such, if you’re not yet working with VS11, you can install ReSharper 7 on previous versions. Get the latest editions from the EAP page. As new releases appear, new features...