ToString() formatting of Guid.NewGuid()











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)


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

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


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

How Many King James Bibles Can You Store In SQL Server 2008

1GB = 1073741824

Bible in Characters: 3228076

Hard Disk Size 500G: 536870912000

SQL Server Hard Disk Space 3.6G: 3865470565

Sophos Anti Virus 500 MB: 536870912
Sophos Firewall 100 MB: 107374182
Windows XP 1.5GB: 1610612736

Windows XP Service Pack 3 1230 MB: 1320702443

Bytes Remaining: 529429881162

Bible Count: 164007