All Visual Studio blogs in one place

AddThis Social Bookmark Button
One change you will notice when you install MVVM Light V4.3.31 is that I marked the DialogMessage class as Obsolete. The DialogMessage class is one of the built in message classes in the MVVM Light Messaging namespace. When sent by the Messenger to a view element (Window, Page, etc), it carries information that can be […]

AddThis Social Bookmark Button
Software A new search experience on the Gallery - Andrew Stanton-Nurse and the NuGet Team discuss their recently deployed improvements to the search experience witih the NuGet Gallery Information Open Source is a thankless job. We do it anyway - Scott Hanselman discusses the many difficulties of the open source community and the types of problems that are [...]

AddThis Social Bookmark Button
Database plays an irreplaceable role in the modern economy and is widely used in the business computing areas like Enterprise Resources Planning (ERP), Customer Relation Management (CRM), Supply Chain Management (SCM), and the Decision Support System (DSS).

Computation of structured data in the database mainly relies on SQL (Structured Query Language). SQL is the powerful, simple-to-use, and widely-applied database computing script. However, it has some native drawbacks: non-stepwise computation, incomplete set-lization, and no object reference available. Although almost all vendors have
introduced and launched some non-compatible solution, such as various stored procedure like PL-SQL, T-SQL. These improved alternatives cannot remedy the native SQL drawbacks.

esProc solves these drawbacks with more powerful computational capability, much lower technical requirement, and broader scope of application. It is a more convenient database computing scripts.
Case Description

A multinational retail enterprise needs to collect statistics on the newly opened retail store, including: How many new retail stores will open in this year? Of which how many companies...(Read whole news on source site)

AddThis Social Bookmark Button
  This blog post is about all the new nifty features I'm finding in the latest IE11 F12 developer tools.  I updated my Windows to 8.1 update 1, and IE11 was updated.  I started seeing a few cool new features, and went on Twitter to find the official documentation. Was supplied by @AdamTReineke   Rather than bore you with a list of features, which is on MSDN.  I want to just quickly share how I'm using some of them. Disclaimer - I had just watched
LEGO movie.  So EVERYTHING IS AWESOME!   DOM Explorer   1. CSS Changes   When you "touch up" CSS in SharePoint to get the exact look you want.  You often forget which rule you had applied. The DOM Explorer's "Changes" tab tracks all the individual changes, and you can revert an individual rule, or copy them all and paste to your CSS file. Copy All.  Awesome!   2. Pseudo Rules   You...(Read whole news on source site)

AddThis Social Bookmark Button
I have often seen a recommendation that using DISTINCT instead of GROUP BY is better from a performance perspective. DISTINCT is definitely a more readable alternative, but I wanted to test for myself as to what the truth was. To compare the performance of the two, I wrote the following simple queries. The query below helps in identifying the number of records that SQL Server will need to process. On my machine, when executed without the GROUP BY or the DISTINCT clause, the query generates records in excess of 380,000.USE AdventureWorks2012; GO SELECT COUNT(so1.object_id) FROM sys.objects AS so1
CROSS JOIN sys.objects AS so2 ; GO The queries below fetch the same information – one uses the GROUP BY whereas the other query uses a DISTINCT.USE AdventureWorks2012; GO --Clean the buffers and procedure cache DBCC DROPCLEANBUFFERS; DBCC FREEPROCCACHE; GO --Evaluate GROUP BY SELECT so1.object_id, FROM sys.objects AS so1 CROSS JOIN sys.objects AS so2 GROUP BY so1.object_id, ; GO --Clean the buffers and procedure cache DBCC DROPCLEANBUFFERS; DBCC FREEPROCCACHE; GO --Evaluate DISTINCT SELECT DISTINCT so1.object_id, FROM ...(Read whole news on source site)



Enter your email address:

Delivered by FeedBurner

Increase your website traffic with


Anti-spam: How many eyes has a typical person?

Follow us on FB