Visual studio feeds

All Visual Studio blogs in one place

Subscribe

Enter your email address:

Delivered by FeedBurner

Increase your website traffic with Attracta.com

Google+

Contact

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

Follow us on FB

Search

Numbers in ORDER BY Clause

AddThis Social Bookmark Button
You can use numbers in ORDER BY Clause so that it will sort the result set based on the ordinal position of the column. But when numbers are used in a CASE Expression, they do not refer the ordinal position of the columns but they behave like ordering based on derived column with as expression.

Let us consider the following data

create table #test(mobile_no int, model_name varchar(100)) truncate table #test insert into #test(mobile_no,model_name) select 1,'Samsung Galaxy' union all select 2,'Nokia Lumia' union all select 3,'Apple 5s' union all select 4,'Micromax Canvas' union all select 5,'Moto X' 1 Numbers in ORDER BY Clause

select * from #test order by 2 The result
is mobile_no model_name ----------- -------------------- 3 iPhone 5s 4 Micromax Canvas 5 Moto X 2 Nokia Lumia 1 Samsung Galaxy As you see the results are ordered by Name because it is a second column
   
2 Expression in ORDER BY Clause

select * from #test order by case when model_name='Nokia Lumia' then 1 else 2 end The result...(Read whole news on source site)

ASP.NET MVC 6: New structure of solutions and projects

AddThis Social Bookmark Button
ASP.NET MVC 6 solutions have a little bit different solution and project structure. Changes are needed because of new minimalistic tooling and cross-platform requirements. This posting gives you overview of new solution structure and explains how solutions will be organized in future. The post ASP.NET MVC 6: New structure of solutions and projects appeared first on Gunnar Peipman - Programming Blog.

Azure: Announcing New Real-time Data Streaming and Data Factory Services

AddThis Social Bookmark Button
The last three weeks have been busy ones for Azure.  Two weeks ago we announced a partnership with Docker to enable great container-based development experiences on Linux, Windows Server and Microsoft Azure. Last week we held our Cloud Day event and announced our new G-Series of Virtual Machines as well as Premium Storage offering.  The G-Series VMs provide the largest VM sizes available in the public cloud today (nearly 2x more memory than the largest AWS offering, and 4x more memory than the largest Google offering).  The new Premium Storage offering (which will
work with both our D-series and G-series of VMs) will support up to 32TB of storage per VM, >50,000 IOPS of disk IO per VM, and enable sub-1ms read latency.  Combined they provide an enormous amount of power that enables you to run even bigger and better solutions in the cloud. Earlier this week, we officially opened our new Azure Australia regions – which are our 18th and 19th Azure regions open for business around the world.  Then at TechEd Europe we announced another round of new features – including the launch of the new...(Read whole news on source site)

Parsing Nokia Composer Ringtones With FParsec

AddThis Social Bookmark Button
The classic Nokia 3310, and similar Nokia phones featured a capability to define custom ringtones using a tool called ‘Composer’. Parser uses a text based format to define the sequence of tones that makes up the ringtone. A tone is typically specified in the form: 8e2 Where the 8 indicates that the tone should last for eighth of a bar (half of a beat), the e is the musical note describing the pitch of the tone and the 2 indicates the octave that note comes from (valid options are 1, 2 and 3). I want to be able to read the string
that defines a composer tune and interpret it in a precise way that can be used for computations (like playing the tune). The full syntax, as a regular expression, is something like: (\d+\.?#?[abcdefg][123])|(\d+\.?\-) A tune is specified by a sequence of tokens, separated by spaces. Each token is either a tone or a rest. A rest is specified by a duration and an optional extension followed by a hyphen (e.g. 4.-). A tone is specified by a duration and an optional extension followed by a note (which may be preceded by a # to indicate sharp), followed by an octave (e.g....(Read whole news on source site)

TypeScript Demos from My TechEd Europe Session

AddThis Social Bookmark Button
I had the pleasure of delivering a TypeScript session today in TechEd Europe.In the session, I introduced the TypeScript language and talked about language features and how to use them.Later on, I wrote a simple end-to-end web application using TypeScript in the server (with Node.js and Express) and in the front-end (mainly with jQuery).I want […]

Yet Another Podcast #135 – Miguel de Icaza on Xamarin

AddThis Social Bookmark Button
Miguel de Icaza is one of the most respected technologists in the industry, known  for starting the Gnome and Mono projects.  He is the CTO and co-founder of Xamarin and a genuinely nice person.  Today we talk about Xamarin, Xamarin.Forms and mobile programming. … Continue reading → For the complete article and hyperlinks, please visit my blog at http://JesseLiberty.com

SpecsFor.Mvc 4.0 Coming Soon!

AddThis Social Bookmark Button
Hot off the NuGet press, it’s the first preview release of SpecsFor.Mvc 4.0!   This release introduces more configurability, exposes more state for your tests to examine, and (hopefully) greatly improves the initial setup experience by removing a lot of frustration. Here’s a quick rundown on what’s change.  FluentField now supports asserting off its value fluently: SUT.FindFormFor() .Field(m => m.UserName).ValueShouldEqual(" This e-mail address is being protected from spambots. You need JavaScript enabled to view it ") .Field(m => m.Password).ValueShouldEqual(string.Empty); The temporary directory that your application is published to can now be overridden.  This makes it possible to spin up multiple integration hosts
with multiple websites for more advanced testing scenarios. var site1Config = new SpecsForMvcConfig(); site1Config.UseIISExpress() .With(Project.Named("Website1")) .WithTemporaryDirectoryName("Website1TempDir"); var site1Host = new SpecsForIntegrationHost(site1Config); var site2Config = new SpecsForMvcConfig(); site2Config.UseIISExpress() .With(Project.Named("Website2")) .WithTemporaryDirectoryName("Website2TempDir"); var site2Host = new SpecsForIntegrationHost(site2Config); site1Host.Start(); site2Host.Start(); You cannot directly utilize MVC 5.1’s attribute routing from a test project due to some nasty infrastructure in that stack, but that’s ok, because SpecsFor.Mvc now has a workaround.  Just call the BuildRoutesUsingAttributeRouting… helper method, and point it at your web project: site1Config.BuildRoutesUsingAttributeRoutingFromAssemblyContaining(); Similar to SpecsFor, SpecsFor.Mvc now has a friendly post-install page to help you get started: There are...(Read whole news on source site)

Start Your Digital Vision by Reenvisioning Your Customer Experience

AddThis Social Bookmark Button
You probably hear a lot about the Mega-Trends (Cloud, Mobile, Social, and Big Data), or the Nexus of Forces (the convergence of social, mobility, cloud and data insights patterns that drive new business scenarios), or the Mega-Trend of Mega-Trends (Internet of Things). And you are probably hearing a lot about digital transformation and maybe even about the rise of the CDO (Chief Digital Officer.) All of this digital transformation is about creating business change, driving business outcomes, and driving better business results. But how do you create your digital vision and strategy?   And, where
do you start? In the book, Leading Digital: Turning Technology into Business Transformation, George Westerman, Didier Bonnet, and Andrew McAfee, share some of their lessons learned from companies that are digital masters that created their digital visions and are driving business change. 3 Perspectives of Digital Vision When it comes to creating your digital vision, you can focus on reenvisioning the customer experience, the operational processes, or your business model. Via Leading Digital: “Where should you focus your digital vision? Digital visions usually take one of three perspectives: reenvisioning...(Read whole news on source site)

Home