Chris Pietschmann

husband, father, hacker, entrepreneur, futurist, innovator, autodidact


Milwaukee Azure Bootcamp - Apr 16, 2016

It's time for the 4th annual Global Azure Bootcamp, and this year it's coming to Milwaukee, WI on April 16, 2016. Whether you're already using Microsoft Azure, or are looking to learn and get started, then you'll likely be interested in this Free training event. It's a fully immersive, single day filled with presentations and hands on labs. Tables and Wifi will be provided, so do not forget to bring your laptops! Sign up to attend here This is a community events with local speakers presenting th... [More]

Announcing new Azure blog:

While studying for the MCSD: Azure Solutions Architect certification I decided to blog a lot more on all things Azure. Also, instead of posting those posts here, I decided to create a completely new blog site dedicated just to "all things Azure" This new site is I have also created the @BuildAzure twitter account associated with the new blog. I will still blog here, as I have for over 10 years so far. However, my posts relating to Microsoft Azure technologies and features will mo... [More]

Why I got the MCSD: Azure Solutions Architect Certification

Over the last few months I spent a ton of time studying for and passing the 3 exams required to earn the Microsoft Certified Solutions Developer (MCSD) Azure Solutions Architect certification. Microsoft has really built out an incredible, cloud platform that is Azure! And, this is fitting since it's the future of Microsoft's Enterprise business. This is the root of the reason why I decided to pursue and obtain the MCSD: Azure Solutions Architect certification. Azure Solutions Architect is a uniq... [More]

How I passed the 70-532 Developing Microsoft Azure Solutions certification exam

I've been taking on some Microsoft certifications recently, and my latest success is passing the 70-532 Developing Microsoft Azure Solutions exam; earning me the Microsoft Specialist: Developing Microsoft Azure Solutions Certification. As with all Microsoft certification exams, this exam covers a huge amount of information and content. As a result of this, a variety of materials and sources need to be studied in order to get the level understanding and memorization necessary to pass the exa... [More]

SQL Azure: Calculate Database Usage Percentage of Max Size

Some times it can be useful to programmatically monitor your SQL Azure database usage statistics. Luckily, there is some short SQL code that can be run on the database to check how much disk space is currently used and what the currently allotted max database size is. The following script does just that. DECLARE @dbName nvarchar(255) = '{database_name}'; DECLARE @Max BIGINT = CONVERT(BIGINT, (SELECT DATABASEPROPERTYEX(@dbName , 'MaxSizeInBytes'))); DECLARE @Used BIGINT = ( SELECT ... [More]

SQL Azure: REBUILD All Indexes in Database – Alternative to DBCC DBREINDEX

Unfortunately there are some differences between SQL Server and SQL Azure. One of these differences is that SQL Azure does not support the “DBCC DBREINDEX” command. Thankfully there is an alternative you can use to rebuild the indexes within your SQL Azure databases. The alternative is to use “ALTER INDEX” instead. ALTER INDEX ALL ON TableName REBUILD Here’s an example that loops through all the tables in a database and rebuilds all their indexes: DECLARE @TableName... [More]

What's the Minimum Hosting Cost for Windows Azure?

NOTE: Azure pricing and functionality has changes alot since this post was written making the details below out of date. Microsoft has announced the initial pricing for Windows Azure, SQL Azure and .NET Services. My question is still "What is the Minimum it will cost to host a small website/application on Azure?"If your application is racking up "Compute" time when ever it is "live", then that equals a total of approximately 720 hours of "compute" time for a total of $86.40 per month.If you stor... [More]

Live Framework: Connecting to the Local Live Operating Environment (LOE) for Offline Applications

One of the things the Live Framework has to offer is a Local Live Operating Environment you can connect to so that you can Offline Enable your Live Framework Enabled Desktop Applications. I found the process of getting it to work a little tricky (especially since I was running Win7 Beta; I'll explain down further) so I've decided to write up a summary of my experience to help anyone else interested. This was written using the Live Framework CTP. Connecting to the Live Operating Environment Th... [More]