May 2011 Entries

Backup Tool for SQL Azure

For those that attended TechEd NA 2011 last week in Atlanta it should be no surprise that more and more companies are betting on the Azure platform, whether it is Windows Azure or SQL Azure. There have been developments, changes and improvements for every aspect of the Windows Azure platform in general. And with that tools from 3rd parties to enhance or extend the experience. That is the case when we look at SQL Azure Backup from Redgate. A way to simplify and sync your SQL Azure data to local SQL ......

TechEd NA 2011 Study Hall: The Missing Guide

You have heard, an read about TechEd North America 2011. If you are at TechEd 2011 then you have received some additional information about sessions, the number of miles between buildings (joking) and really the building layout and room numbers. Anyway, somehow the room where the Study Hall is, has been labeled Certification Testing Center. And while there is a Certification Testing Center, that is in room B-316 only. Now, on to the reason behind the post ... room B-315 is the Study Hall. This means ......

The road to getting the MCPD:Windows Azure credential. Exam 70-583 (Intro Material) Part 4 of 4

Let’s focus on Exam 70-583 this time. This exam is PRO: Designing and Developing Windows Azure Applications. This guide itself will be a different approach to preparing for the exam itself. Instead of just taking the individual topics, let’s review the topic in as much information as we can. Here is a set of resources to get started. This is the topic I will be presenting at TechEd North America 2011, so expect more information after 5/18/2011. Here is the link to the session: http://northamerica.msteche... ......

Unofficial Prep guide for PRO: Microsoft Lync Server 2010, Administrator (70-665) Part 2 of 2

Designing a Topology for Lync Server 2010 Design address book http://technet.microsoft.co... http://technet.microsoft.co... Design central and branch office topology http://technet.microsoft.co... http://technet.microsoft.co... http://technet.microsoft.co... http://technet.microsoft.co... http://technet.microsoft.co... ......

Unofficial Prep guide for PRO: Microsoft Lync Server 2010, Administrator (70-665) Part 1 of 2

With the recent demand to technologies that allow us to communicate better inside and outside our organization’s walls, comes the need to implement solutions like Microsoft Lync. Individuals are looking at expanding their skillset and therefore looking at training and certifications. Here are some resources that will help you prepare for the PRO: Microsoft Lync Server 2010, Administrator (70-665) Exam. Information for the Links in the Prep Guide come from TechNet Library and the info can be found ......

Cool Resources: Windows Azure Edition

The very first thing that needs to happen is the need for a Windows Azure account. Try it free! http://www.microsoft.com/wi... The Learning Plan http://learning.microsoft.c... The Training Kit http://www.microsoft.com/do... The General Toolset Assessment and Planning ......

Cool Resources: SharePoint Edition

One thing that has become clear over the last couple of years is the inclusion of helpful tools and resources in every Administrator’s Toolbox. Gary Lapointe created a PowerShell Cheat Sheet (a one pager quick hit) http://bit.ly/kJVnGd PowerGUI PowerShell Quick Reference Card for SharePoint. http://www.powergui.org/ent... SharePoint Software Factory 2010 http://bit.ly/eC7efh SharePoint 2010 Operations Guides http://bit.ly/hq9UZy Marcy Kellar’s Branding and Customization ......

The road to getting the MCPD:Windows Azure credential. Exam 70-516 Part 3 of 4

Let’s focus on Exam 70-516 this time. This exam is TS: Accessing Data with Microsoft .NET Framework 4. Additional Resources: http://msdn.microsoft.com/e... The exam objectives are: Modeling Data Map entities and relationships by using the Entity Data Model http://msdn.microsoft.com/e... http://msdn.microsoft.com/e... http://msdn.microsoft.com/e... Map entities and relationships by using LINQ to SQL http://msdn.microsoft.com/e... ......

The road to getting the MCPD:Windows Azure credential. Exam 70-513 Part 2 of 4

Let’s focus on Exam 70-513 this time. This exam is TS: Windows Communication Foundation Development with Microsoft .NET Framework 4. Additional Resources: http://msdn.microsoft.com/e... http://msdn.microsoft.com/e... The exam objectives are: Creating Services Create service and operation contracts http://msdn.microsoft.com/e... http://msdn.microsoft.com/e... http://msdn.microsoft.com/e... ......

Great Finds: FILESTREAM with SharePoint 2010

This has been an interesting topic to have discussions around planning storage and storage requirements organizations need to consider. FILESTREAM provides a means to consider storage of unstructured data on the File system (specifically NTFS). As we know SharePoint lends itself to allow storage of large binary data, considering FILESTREAM gives us an option of using commodity storage for binary form unstructured data. Again, another way in which SQL Server and SharePoint work together. The SharePoint ......

The road to getting the MCPD:Windows Azure credential. Part 1 of 4

I have mentioned I will be speaking on a Cram 4 exam session at the upcoming TechEd North America 2011 in Atlanta. The topic is the prep for exam 70-583: Designing and Developing Windows Azure Applications. This is a PRO Level exam. There are two other exams needed to get the MCPD Azure credential, those exams are TS level exams. Those exams are: EXAM 70-513 TS: Windows Communication Foundation Development with Microsoft .NET Framework 4 EXAM 70-516 TS: Accessing Data with Microsoft .NET Framework ......

Great Find: Database Maintenance Guidance Document for SharePoint 2010 Products

Over the last couple of weeks I have been discussing with clients and peers the proper way of managing the database side of a SharePoint deployment.

Yesterday, Microsoft released the official version of that guidance.

You can get that here

What do you use for Database Source Control?

I have found myself using more and more of the tools Red Gate software makes. They have proven (to me) to be effective and to the point. This time I am talking about SQL Source Control. Simple to use, simple to add a database to be under Change Control, which really is the goal. Don’t take me wrong, Visual Studio is a great tool, yet it is a developer’s tool. As a DBA or Database Developer (referring to an individual who codes T-SQL) we want to launch SQL Server Management Studio and be able to control ......

April is gone, May is here

April was maybe the busiest month I have seen. Projects are closing but many are going strong. Many lessons came with it. A deeper and stronger involvement with Windows Azure. Specially around System Center Operations Manager and Windows Azure. Also, that brings me to the next chapter in the Windows Azure adventure. I will be presenting a Cram 4 Exam session at TechEd North America 2011. More details to come on this soon. May, then, looks exciting and with many lessons to learn. For those going to ......