Group items tagged

"Hopefully if you're reading this you've noticed that I've started a series of Tips recently. The tips will mostly apply to Entity Framework or Data Services. Seeing as I expect to have a lots of tips, it probably makes sense to have some sort of index. That is what this is post is, as I add a new tip I will add it to this page too. If you have any suggested topics for tips please let me know by leaving a comment or emailing me directly at Microsoft (Alexj is my alias at Microsoft, and emails at Microsoft are in the form alias@microsoft.com) Without further ado here are what I have so far:"

"Microsoft SQL Server performs dynamic memory management based on the memory requirements of the current load and activities on the system. On a Windows Server 2003 or a Windows XP or later version system, SQL Server can use the memory notification mechanisms that are provided by the QueryMemoryResourceNotification Windows API. On a Microsoft Windows 2000 Server-based system, SQL Server periodically calculates the free physical memory on the system by using the native Windows API. Based on this information from the QueryMemoryResourceNotification Windows API or from the memory calculation, SQL Server responds to the current memory situation on a specific system. This provides the following benefits:"

"DPack is a FREE collection of Microsoft Visual Studio 2012 tools. DPack is designed to greatly increase developer's productivity, automate repetitive processes and expand upon some of Microsoft Visual Studio features. DPack includes various browser tools that allow the developer to quickly find solution files, types, particular type members, methods or properties for instance, or quickly find and reference standard .NET framework types. DPack includes greatly enhanced numbered bookmarks feature, various code navigation tools as well as streamlined surround with feature, and much more. See screenshots and learn more about individual features using Features menu. Major features included: Code Browser File Browser Solution Browser Framework Browser Numbered Bookmarks Surround With Code Navigation Solution Statistics Solution Backup All features support C#, VB, C++ and Ruby In Steel based projects."

"A new release of Microsoft All-In-One Code Framework is available on Feb 6th. We expect that its 8 new code samples covering typical programming scenarios in Windows Azure, Directory Services, Hyper-V, TFS, WDK, and Windows SDK would ease your development work."

"The Microsoft Ajax Content Delivery Network (CDN) enables you to easily add popular JavaScript libraries such as jQuery to your Web applications. For example, you can start using jQuery simply by adding a

"The Crimson Consulting Group has just published a white paper worth reading: Comparing the Business Value of Microsoft SQL Server 2008 R2 and Oracle Database 11g, Perceptions vs. reality in the RDBMS marketplace (April, 2011). The traditional user-friendliness of a mid-tier product has matured in terms of scalability. Today, you will find SQL Server 2008R2 installations running on 256 core machines -- scalability is no longer an issue. Unfortunately, the traditional scalability product has not grown significantly friendlier to developers and users; this leaves SQL Server 2008R2 the clear value winner for both lowest development expense and total cost of ownership for operations."

All the Microsoft event videos you could ever want

"As a result of writing the post: Edit Test Case properties directly from the test runner of Microsoft Test Manager I asked one the ALM MVPs, Terje Sandstrom, to also look at one of the most requested Visual Studio Update 1 features - but an area I didn't have a post on yet: Grouping in the new Unit Test Explorer. He takes a look and by morning sends me this post and indicates he wants to do three more in this series! "

"Its our pleasure to share best resources/tools for developers and designe for every technologies as HTML5, jQuery, Javascript, PHP, etc. Every programming technologies/techniques provides the number of tools that helps developers and designers a lot in. Today we are going to presents the best development tools for .Net developers. These are the development tools that helps developers for their next project. Most of them are freeware and open source tools."

"Resource Governor is a new feature and one of the most anticipated management features in SQL Server 2008. It bolsters SQL Server performance by allowing DBAs to establish resource limits and priorities on processor and memory-related workloads and resource pools. By defining resource limits on resource consumption, it is possible to prioritize multiple workloads in order to ensure consistent performance and maximize the experience of the end users and the efficiency of the applications without degradation."

"This is a question that I get very frequently, and I always tried to dodged the bullet, but I get it so much that I feel that I have to provide an answer. Obviously, I am (not so) slightly biased toward NHibernate, so while you read it, please keep it in mind. EF 4.0 has done a lot to handle the issues that were raised with the previous version of EF. Thinks like transparent lazy loading, POCO classes, code only, etc. EF 4.0 is a much nicer than EF 1.0. The problem is that it is still a very young product, and the changes that were added only touched the surface. I already talked about some of my problems with the POCO model in EF, so I won't repeat that, or my reservations with the Code Only model. But basically, the major problem that I have with those two is that there seems to be a wall between what experience of the community and what Microsoft is doing. Both of those features shows much of the same issues that we have run into with NHibernate and Fluent NHibernate. Issues that were addressed and resolved, but show up in the EF implementations."

"In SQL Server 2008 Microsoft has introduced a number of new date and time data types. One of these is the datetimeoffset data type. This data type includes an offset from UTC time as well as the datetime value and ensures that the datetime can be retrieved in UTC or a particular timezone based on this offset. There are also new functions to allow for conversions between different time zones using the new function SWITCHOFFSET(). "

"Column-Based Query Accelerator will help dramatically increase query performance ~10x and reduce performance tuning through interactive experiences with data for near instant response times and streamlined setup which removes the need to build summary aggregates."

"To say I like SP_WhoIsActive is an understatement. This is probably the most useful and effective stored procedure I've ever encountered for activity monitoring. The purpose of the SP_WhoIsActive stored procedure is to give DBAs and developers as much performance and workload data about SQL Server's internal workings as possible, while retaining both flexibility and security. It was written by Boston-area consultant and writer Adam Machanic, who is also a long-time SQL Server MVP, a founder of SQLBlog.com, and one of the most elite individuals who are qualified to teach the Microsoft Certified Master classes."

"Returns information from, or expressions based on, each row affected by an INSERT, UPDATE, DELETE, or MERGE statement. These results can be returned to the processing application for use in such things as confirmation messages, archiving, and other such application requirements. The results can also be inserted into a table or table variable. Additionally, you can capture the results of an OUTPUT clause in a nested INSERT, UPDATE, DELETE, or MERGE statement, and insert those results into a target table or view."

"The 32-bit and 64-bit development story on Windows seemingly never stops causing problems for developers. It's been a decade since 64-bit processors have started popping up in the Windows consumer environment, but we just can't get it right. If you forget some of the gory details, here are a couple of reminders:"

(Better than the official TopShelf documentation) "I am creating windows services using Topshelf for a while and I forget how "hard" (not that hard but harder) it was to create a windows service without Topshelf."

The Model-View-Controller (MVC) architectural pattern separates an application into three main components: the model, the view, and the controller. The ASP.NET MVC framework provides an alternative to the ASP.NET Web Forms pattern for creating MVC-based Web applications.

The Model-View-Controller (MVC) architectural pattern separates an application into three main components: the model, the view, and the controller. The ASP.NET MVC framework provides an alternative to the ASP.NET Web Forms pattern for creating MVC-based Web applications.

When it comes to .NET growth, a designer could develop programs by using easy command-line and written text manager resources within the structure.