Click to Set Next Statement

Many of you may know about the context menu item Set Next Statement (Ctrl+Shift+F10) that moves the yellow arrow (the instruction pointer) to the target line of code. You may also know that you grab and drag the yellow arrow up and down in the gutter to move it. What you probably didn’t know is that as of Visual Studio 2017 version 15,3 Preview there is an even easier way to target a line and Set Next Statement.

1. Hover over the line of code where you want to move the yellow arrow.

2. Hold the CTRL key and notice the Run to Click (Run execution to here) glyph changes into the Set Next Statement glyph.

3. Click on that glyph and the yellow arrow will move to that line.

SetNextStatement

4. This line will be the next statement to execute when taking a step or pressing Continue (F5).

[Source](https://blogs.msdn.microsoft.com/visualstudio/2017/06/26/7-lesser-known-hacks-for-debugging-in-visual-studio/)

ToString() formatting of Guid.NewGuid()


Console.WriteLine(Guid.NewGuid().ToString("n"));

e2fa63581f7642af83321e592e443f20


Console.WriteLine(Guid.NewGuid().ToString("d"));

a307cc65-413e-4d07-ab95-349ce6c313f6


Console.WriteLine(Guid.NewGuid().ToString("p"));

(e27f9b1f-f335-49e6-9ef8-ff7fdfccda3a)


Console.WriteLine(Guid.NewGuid().ToString("b"));

{8786c68f-cf57-4ea2-a956-8c48fc681da6}


Console.WriteLine(Guid.NewGuid().ToString("x"));

{0x6d0df007,0x5e83,0x4293,{0xb3,0x28,0xf1,0x6a,0xa8,0x5b,0xa6,0x61}}

A Note on Cloud Application Architecture

When dealing with a Cloud Architecture the ability to scale out becomes available by adding computational resources to process job queues. The application’s work load is divided across a number of servers who each process a job or set of jobs retrieved from a queue.

What you lose in the power earned from Classic Architecture you gain in power though parallelism and cost saving through flexibility in Cloud Architecture. In Cloud Architecture, when more resources are needed more servers are added and when demand has been met and those resources are no longer needed they are removed.

This type of resource management is powerfully meaningful from a cost perspective when the process of scaling out and back is automated.

A Note on Classic Application Architecture

Classic Applications are usually comprised of three core components. The Web Application, a Document Storage System, and a Database System. In the Classic Application Architecture model these components are distributed across one or more servers.

When resources become maxed out on these servers new hardware must be added to meet the demand. This is called Scaling up because you scale up your hardware’s specification to meet the demands of your application’s requirements and will probably lead to big servers, slow servers, or high maintenance costs, so it’s not very flexible or efficient from a resource management perspective.

But this is fine actually because this resource management model is perfectly well suited to clients who can accurately predict their usage of an application and have adequate resources to hand.

SQL Server reporting services (SSRS)

SQL Server reporting services (SSRS) is a suite of tools made available by Microsoft as an alternative to Crystal Reports and as an optional component of SQL server. Reports are created using a Visual Studio component or other Client Report Definition (RDLC) designer such as Report Builder. Reports are published to a central store to be viewed, manipulated and exported to a variety of formats. SSRS needs to be enabled and configured before reports can be published to its report hosting web application.

 

The following resources should give a good overview and starting point for anyone planning on building RDLC Reports

SQL Server Reporting Services Overview (4:57)

http://www.youtube.com/watch?v=gN3G094fJt0

 

SQL 2012 Report Builder -> for designing and publishing reports -> uses the familiar MS Office interface.

http://www.microsoft.com/en-ie/download/details.aspx?id=29072

SQL 2012 Report Builder Tutorial -> (11:59)

http://www.youtube.com/watch?v=00SX1XX3fl4

 

There is also an addin available for Excel called “Power Query” that allows for the easy aggregation of basic data from SQL, a user can then use the Excel components that they are already familiar with to create reports.

Power Query > Excel Addin for creating Excel reports

http://www.microsoft.com/en-us/download/details.aspx?id=39379