Posts
245
Trackbacks
0
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 Server databases.

Go ahead and check it out here: http://www.red-gate.com/products/dba/sql-azure-backup/

Also a good step by step from Grant Fritchey … http://www.simple-talk.com/community/blogs/scary/archive/2011/04/19/101314.aspx

Posted On Tuesday, May 24, 2011 11:14 AM | Comments (0)
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 a room used to Study and Prep for the Certification Exams.  It has MeasureUp and Transcender exams ready for you to use and get ready for the real deal.

Come on over and get ready in a quiet place and there are some of us MCTs hanging out and ready to help out with explaining the Certification Roadmaps and such.

Come on then, visit us at the Study Hall and say hi, prep for your exam ... but do comer over.

Posted On Monday, May 16, 2011 5:28 PM | Comments (1)
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.msteched.com/topic/details/C4E262?fbid=LDYU5Auug-t#showdetails

What is involved to plan, design, develop and deploy for the Windows Azure Platform?  There are several areas to consider.  See the graphic below (graphic from MSDN documentation).

IC494794

Additional Resources:

Resources from msdev.

http://www.msdev.com/Directory/SeriesDescription.aspx?CourseId=153

Most of the information covered here is addressed through the Windows Azure Platform Training Course available on MSDN.

http://msdn.microsoft.com/en-us/WAZPlatformTrainingCourse

There is a set of learning snacks and a learning plan

http://learning.microsoft.com/manager/LearningPlanV2.aspx?resourceId=30f78dea-f126-4b01-82eb-52cbc908e4ec&clang=en-US&cats=d4e8e42c-3d5a-4a6e-915d-d99556a49bd7

Moving Applications to Windows Azure

http://msdn.microsoft.com/en-us/library/ff728592.aspx

Also, the Windows Azure Architecture Guide, part 1

http://waag.blob.core.windows.net/partone/index.html

Information for some of the topics is found here:

http://msdn.microsoft.com/en-us/library/gg433040.aspx
http://msdn.microsoft.com/en-us/library/ee924681.aspx
http://msdn.microsoft.com/en-us/library/ee336230.aspx
http://msdn.microsoft.com/en-us/library/ee730904.aspx
http://msdn.microsoft.com/en-us/library/ff728592.aspx

The exam objectives are:

Designing Data Storage Architecture

When we talk about Data Storage for Windows Azure, we need to consider the two sides the story has: Windows Azure Storage and SQL Azure Storage.

Under Windows Azure Storage, we need to consider Blob, Drives, Tables and Queues.  Then SQL Azure is a relational database focused on transaction based activities.
The topics addressed through the exam are as follows:

  • Choose the appropriate data storage model based on technical requirements
  • Design a synchronization strategy
  • Plan a cost-effective data architecture based on business requirements
  • Design a database migration plan from SQL Server to SQL Azure
  • Plan for media storage and accessibility

Optimizing Data Access and Messaging

How we work with the surrounding technologies that will help us access data and exchange information across is essential to a successful story in the Windows Azure Platform.

  • Optimize a data access strategy
  • Design a reliable data access layer to access SQL Azure
  • Design an efficient strategy to avoid data access throttling
  • Design a queue strategy that guarantees idempotency
  • Design communication strategies using queues

Designing the Application Architecture

  • Choose appropriate role types for compute instances
  • Optimize worker roles design for efficient resource usage
  • Identify performance vs. cost trade-offs
  • Choose appropriate ways to respond to Azure Fabric Controller events
  • Develop a plan to migrate existing applications and services

Preparing for Application and Service Deployment

  • Choose and appropriate upgrade strategy
  • Choose the appropriate virtual machine size
  • Plan a deployment for the entire application life cycle
  • Define a resource-efficient environment for application development and testing
  • Choose a naming scheme for resources

Investigating and Analyzing Applications

  • Plan, collect, and interpret diagnostics and instrumentation data
  • Identify SQL Azure performance and storage capacity with dynamic management views
  • Identify and mitigate deployment and runtime issues for Windows Azure

Designing Integrated Solutions

  • Design hybrid solutions
  • Identify and mitigate connectivity issues in hybrid solutions
  • Plan for appropriate access control schemes based on security requirements
Posted On Monday, May 9, 2011 9:50 PM | Comments (0)
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.com/en-us/library/gg398771.aspx
http://technet.microsoft.com/en-us/library/gg429711.aspx
Design central and branch office topology http://technet.microsoft.com/en-us/library/gg398076.aspx
http://technet.microsoft.com/en-us/library/gg398536.aspx
http://technet.microsoft.com/en-us/library/gg398855.aspx
http://technet.microsoft.com/en-us/library/gg398840.aspx
http://technet.microsoft.com/en-us/library/gg425826.aspx
Design Mediation topology http://technet.microsoft.com/en-us/library/gg412780.aspx
http://technet.microsoft.com/en-us/library/gg398703.aspx
http://technet.microsoft.com/en-us/library/gg398399.aspx
Design archiving and Quality of Experience (QoE) monitoring topology http://technet.microsoft.com/en-us/library/gg398687.aspx
Design Edge topology http://technet.microsoft.com/en-us/library/gg398918.aspx
http://technet.microsoft.com/en-us/library/gg425919.aspx
Design Call Admission Control (CAC) http://technet.microsoft.com/en-us/library/gg398842.aspx
Calculate bandwidth http://technet.microsoft.com/en-us/library/gg398439.aspx

 

Designing a Conferencing and Enterprise Voice Infrastructure

Design a dial plan http://technet.microsoft.com/en-us/library/gg413082.aspx
Design for voice routing http://technet.microsoft.com/en-us/library/gg412757.aspx
Define voice policies http://technet.microsoft.com/en-us/library/gg412891.aspx
Define conference policies http://technet.microsoft.com/en-us/library/gg398454.aspx
http://technet.microsoft.com/en-us/library/gg398600.aspx
Design for Response Group Services (RGS) http://technet.microsoft.com/en-us/library/gg398584.aspx
http://technet.microsoft.com/en-us/library/gg398617.aspx
Design for emergency services implementation http://technet.microsoft.com/en-us/library/gg398154.aspx
Plan for devices http://technet.microsoft.com/en-us/library/gg398583.aspx

 

Planning for External Dependencies and Migration

Plan for DNS implementation http://technet.microsoft.com/en-us/library/gg398386.aspx
Plan for PKI requirements http://technet.microsoft.com/en-us/library/gg398066.aspx
Plan for Exchange Unified Messaging (UM) http://technet.microsoft.com/en-us/library/gg425807.aspx
http://technet.microsoft.com/en-us/library/gg399031.aspx
http://technet.microsoft.com/en-us/library/gg413027.aspx
Plan for migration http://technet.microsoft.com/en-us/library/gg425746.aspx

 

Planning High Availability and Business Continuity

Plan for high availability http://technet.microsoft.com/en-us/library/gg413081.aspx
Plan for load balancing http://technet.microsoft.com/en-us/library/gg615011.aspx
Plan for backup and restore http://technet.microsoft.com/en-us/library/gg412771.aspx
Plan for disaster recovery http://technet.microsoft.com/en-us/library/gg412985.aspx
http://technet.microsoft.com/en-us/library/gg412771.aspx
http://technet.microsoft.com/en-us/library/gg413081.aspx
Plan for system monitoring http://technet.microsoft.com/en-us/library/gg412952.aspx
http://technet.microsoft.com/en-us/library/gg520950.aspx
Plan for site resiliency http://technet.microsoft.com/en-us/library/gg670905.aspx
http://technet.microsoft.com/en-us/library/gg398840.aspx
Posted On Monday, May 9, 2011 9:03 PM | Comments (0)
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 on the Planning Guide documentation.

Lync Server 2010 PowerShell
http://blogs.technet.com/b/csps/

Getting Started Guide http://www.microsoft.com/downloads/en/details.aspx?FamilyID=E33765BC-9C5D-49B2-BB4F-EC8D42CCC1C7

Standard Edition Deployment Guide http://www.microsoft.com/downloads/en/details.aspx?FamilyID=787D6B9F-CBB3-4D6D-B292-34FE43E9AFC3

Enterprise Edition Deployment Guide http://www.microsoft.com/downloads/en/details.aspx?FamilyID=4CF4BED4-2F76-4B99-ADCB-60653521CC70

Lync Server 2010 AD Guide http://www.microsoft.com/downloads/en/details.aspx?FamilyID=513C46DB-ADC3-4D62-8ACC-5F0EE27F1F9C

Lync Server 2010 Planning Tool and Readme http://www.microsoft.com/downloads/en/details.aspx?FamilyID=BCD64040-40C4-4714-9E68-C649785CC43A 

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=C8BA3275-270F-4C0B-90BB-EDC1D1216C2D

Lync Server 2010 Best Practices Analyzer http://www.microsoft.com/downloads/en/details.aspx?FamilyID=030548DF-0DC7-4F86-B8A9-2F5EC8DE8BA5

Lync Server 2010 Resource Kit Tools http://www.microsoft.com/downloads/en/details.aspx?FamilyID=80CC5CE7-970D-4FD2-8731-D5D7D0829266

Lync Server 2010 Planning Guide http://www.microsoft.com/downloads/en/details.aspx?FamilyID=2da9fa26-e032-4dcf-b487-da916ddc508f

Posted On Monday, May 9, 2011 7:54 PM | Comments (0)
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/windowsazure/free-trial/

The Learning Plan

http://learning.microsoft.com/manager/LearningPlanV2.aspx?resourceId=30f78dea-f126-4b01-82eb-52cbc908e4ec&clang=en-US&cats=d4e8e42c-3d5a-4a6e-915d-d99556a49bd7

The Training Kit

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=413E88F8-5966-4A83-B309-53B7B77EDF78&displaylang=en

The General Toolset

Assessment and Planning Tools  http://www.microsoft.com/windowsazure/tools/#tcoCompare-LB

Windows Azure SDK and Tools   http://www.microsoft.com/windowsazure/sdk/

Application Development Tools http://www.microsoft.com/windowsazure/tools/#applicationdevelopment

Deployment and Management Tools http://www.microsoft.com/windowsazure/tools/#deploymentstorage

SCOM and Windows Azure http://bit.ly/8Z5TB7

Posted On Sunday, May 8, 2011 9:32 AM | Comments (0)
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/entry.jspa?externalID=2812&categoryID=354

SharePoint Software Factory 2010  http://bit.ly/eC7efh

SharePoint 2010 Operations Guides  http://bit.ly/hq9UZy

Marcy Kellar’s Branding and Customization Resources http://bit.ly/dyQJRX

Visual Studio 2010 SharePoint Power Tools  http://bit.ly/jdeGVF

Silverlight SharePoint Web Parts http://bit.ly/icXDKb

CKS – Development Tools Edition – Server  http://bit.ly/eLft1J

CKS – Development Tools Edition – Foundation http://bit.ly/fjtRbi

SharePoint Content Deployment Wizard http://spdeploymentwizard.codeplex.com/

Posted On Sunday, May 8, 2011 9:11 AM | Comments (0)
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/en-us/data/cc300162.aspx#entity

The exam objectives are:

Modeling Data

Map entities and relationships by using the Entity Data Model http://msdn.microsoft.com/en-us/library/ee382825.aspx
http://msdn.microsoft.com/en-us/library/cc716685.aspx
http://msdn.microsoft.com/en-us/library/bb399596.aspx
Map entities and relationships by using LINQ to SQL http://msdn.microsoft.com/en-us/library/bb386976.aspx
Create and customize entity objects http://msdn.microsoft.com/en-us/library/bb738695.aspx
Connect a POCO model to the Entity Framework http://msdn.microsoft.com/en-us/library/dd456853.aspx
Create the database from the Entity Framework model http://msdn.microsoft.com/en-us/library/dd456817.aspx
http://msdn.microsoft.com/en-us/library/dd456821.aspx
http://msdn.microsoft.com/en-us/library/bb399785.aspx
Create model-defined functions http://msdn.microsoft.com/en-us/library/bb896279.aspx

 

Managing Connections and Context

Configure connection strings and providers http://msdn.microsoft.com/en-us/library/ms254978.aspx
http://msdn.microsoft.com/en-us/library/a6cd7c08.aspx
Create and manage a data connection http://msdn.microsoft.com/en-us/library/32c5dh3b.aspx
Secure a connection http://msdn.microsoft.com/en-us/library/ecb3hak0.aspx
Manage the DataContext and ObjectContext http://msdn.microsoft.com/en-us/library/cc668193.aspx
http://msdn.microsoft.com/en-us/library/bb738465.aspx
Implement eager loading http://msdn.microsoft.com/en-us/library/bb896272.aspx
http://msdn.microsoft.com/en-us/library/dd456846.aspx

http://bit.ly/a8rIJv
Cache data http://bit.ly/iIq5ie
http://bit.ly/dEaEgH
Configure ADO.NET Data Services http://msdn.microsoft.com/en-us/library/ee358710.aspx
http://bit.ly/lEpfnk

 

Querying Data

Executing a SQL query http://msdn.microsoft.com/en-us/library/bb738694.aspx
Create a LINQ query http://msdn.microsoft.com/en-us/library/bb397942.aspx
http://msdn.microsoft.com/en-us/library/bb397919.aspx
http://msdn.microsoft.com/en-us/library/bb387098.aspx
http://msdn.microsoft.com/en-us/library/bb882640.aspx
Create an Entity SQL (ESQL) query http://msdn.microsoft.com/en-us/library/bb896297.aspx
http://msdn.microsoft.com/en-us/library/bb399367.aspx
http://msdn.microsoft.com/en-us/library/bb386964.aspx
Handle special data types http://msdn.microsoft.com/en-us/library/87z0hy49.aspx
http://msdn.microsoft.com/en-us/library/cc716724.aspx
http://msdn.microsoft.com/en-us/library/bb675163.aspx
Query XML http://msdn.microsoft.com/en-us/library/bb387098.aspx
Query data by using ADO.NET Data Services http://msdn.microsoft.com/en-us/library/cc668796.aspx

 

Manipulating Data

Create, update, or delete data by using SQL statements http://msdn.microsoft.com/en-us/library/tyy0sz6b.aspx
http://msdn.microsoft.com/en-us/library/tf579hcz.aspx
Create, update, or delete data by using DataContext http://msdn.microsoft.com/en-us/magazine/cc700340.aspx
Create, update, or delete data by using ObjectContext http://msdn.microsoft.com/en-us/library/bb386870.aspx
Manage transactions http://msdn.microsoft.com/en-us/library/bb896325.aspx
http://msdn.microsoft.com/en-us/library/bb738523.aspx
Create disconnected objects http://msdn.microsoft.com/en-us/library/ff407090.aspx
http://msdn.microsoft.com/en-us/library/bb896271.aspx
http://msdn.microsoft.com/en-us/library/zb0sdh0b.aspx
http://msdn.microsoft.com/en-us/library/7zt3ycf2(v=VS.100).aspx

 

Developing and Deploying Reliable Applications

Monitor and collect performance data http://msdn.microsoft.com/en-us/library/cc853327.aspx
Handle exceptions http://msdn.microsoft.com/en-us/library/orm-9780596520281-01-21.aspx
Protect data http://msdn.microsoft.com/en-us/library/ecb3hak0.aspx
Synchronize data http://bit.ly/jo73i5
Deploy ADO.NET components http://msdn.microsoft.com/en-us/library/bb896268.aspx
http://msdn.microsoft.com/en-us/library/gg258442.aspx
Posted On Saturday, May 7, 2011 1:35 PM | Comments (0)
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/en-us/netframework/dd939788

http://msdn.microsoft.com/en-us/library/ee391967.aspx

The exam objectives are:

Creating Services

Create service and operation contracts http://msdn.microsoft.com/en-us/library/ms731835.aspx
http://msdn.microsoft.com/en-us/library/ms733721.aspx
http://msdn.microsoft.com/en-us/library/ms731823%28v=VS.100%29.aspx
http://msdn.microsoft.com/en-us/library/ms731073%28v=VS.100%29.aspx
http://msdn.microsoft.com/en-us/library/ms733901%28v=VS.100%29.aspx
Create data contracts http://msdn.microsoft.com/en-us/library/ms733811.aspx
Create message contracts

Implementing generic message handling
http://msdn.microsoft.com/en-us/library/ms730255.aspx
http://msdn.microsoft.com/en-us/library/ms730255%28v=VS.100%29.aspx
Implement RESTful services http://msdn.microsoft.com/en-us/magazine/dd315413.aspx
http://msdn.microsoft.com/en-us/library/bb412172.aspx

http://msdn.microsoft.com/en-us/netframework/cc950529
Create and configure a routing service http://msdn.microsoft.com/en-us/library/ee517421%28v=VS.100%29.aspx
Create and configure a discovery service http://msdn.microsoft.com/en-us/library/dd456782%28v=VS.100%29.aspx
http://msdn.microsoft.com/en-us/library/dd456791%28v=VS.100%29.aspx

 

Hosting and Configuring Services

Create and configure endpoints http://msdn.microsoft.com/en-us/library/ms733107%28v=VS.100%29.aspx
Configure behaviors http://msdn.microsoft.com/en-us/library/ms730137.aspx
Implement self-hosting http://msdn.microsoft.com/en-us/library/ms731758%28v=VS.100%29.aspx
Implement web server hosting http://msdn.microsoft.com/en-us/library/ms733766.aspx
http://msdn.microsoft.com/en-us/library/ms733109%28v=VS.100%29.aspx

Consuming Services

Create a service proxy http://msdn.microsoft.com/en-us/library/ms734691%28v=VS.100%29.aspx
http://msdn.microsoft.com/en-us/library/ms730059%28v=VS.100%29.aspx
http://msdn.microsoft.com/en-us/library/ms731935%28v=VS.100%29.aspx
Configure client endpoints http://msdn.microsoft.com/en-us/library/ms731745%28v=VS.100%29.aspx
http://msdn.microsoft.com/en-us/library/ms734672%28v=VS.100%29.aspx
Invoke a service http://msdn.microsoft.com/en-us/library/ms730059%28v=VS.100%29.aspx
Consume RESTful services http://msdn.microsoft.com/en-us/magazine/dd315413.aspx
http://msdn.microsoft.com/en-us/library/bb412172.aspx

http://msdn.microsoft.com/en-us/netframework/cc950529
Implement service discovery http://msdn.microsoft.com/en-us/library/dd456791%28v=VS.100%29.aspx



Securing Services

Configure secure bindings http://msdn.microsoft.com/en-us/library/ms731172.aspx
Configure message security http://msdn.microsoft.com/en-us/library/ms734736.aspx
Implementing Authentication http://msdn.microsoft.com/en-us/library/ms733082.aspx
Implementing Authorization http://msdn.microsoft.com/en-us/library/ms733071.aspx
Implementing Impersonation http://msdn.microsoft.com/en-us/library/ms730088.aspx
http://msdn.microsoft.com/en-us/library/ms731090.aspx
Implementing security auditing http://msdn.microsoft.com/en-us/library/ms731669.aspx



Managing the Service Instance Life Cycle

Manage service instances http://msdn.microsoft.com/en-us/library/ms752230.aspx
http://msdn.microsoft.com/en-us/library/ms734715.aspx
Manage sessions http://msdn.microsoft.com/en-us/library/ms733040.aspx
Implement transactions http://msdn.microsoft.com/en-us/library/ms730266.aspx
Manage concurrency http://msdn.microsoft.com/en-us/library/ms752260.aspx
Manage consistency between instances, sessions, transactions, and concurrency http://msdn.microsoft.com/en-us/library/ms731193.aspx



Monitoring and Troubleshooting Distributed Systems

Configure message logging http://msdn.microsoft.com/en-us/library/ms731859.aspx
Configure diagnostics http://msdn.microsoft.com/en-us/library/ms730342.aspx
http://msdn.microsoft.com/en-us/library/ms735098.aspx
http://msdn.microsoft.com/en-us/library/ms735120.aspx
Debug client-service interactions http://msdn.microsoft.com/en-us/library/aa738503.aspx
Posted On Saturday, May 7, 2011 9:43 AM | Comments (0)
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 Team at Microsoft has done a great job of highlighting the options and explaining the process behind it in a recent post.  See it here.

Posted On Saturday, May 7, 2011 8:13 AM | Comments (0)
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 4

To summarize this introductory post, the exams needed are:

Exam # MS Learning Reference
70-513 http://www.microsoft.com/learning/en/us/Exam.aspx?ID=70-513&Locale=en-us
70-516 http://www.microsoft.com/learning/en/us/Exam.aspx?ID=70-516&Locale=en-us
70-583 http://www.microsoft.com/learning/en/us/Exam.aspx?ID=70-583&Locale=en-us

The next post in the series will be a detailed prep guide for each exam.

The other part of this will be to provide a OneNote Notebook with references and additional links that can help you be successful.

Posted On Friday, May 6, 2011 8:13 PM | Comments (0)
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

Posted On Friday, May 6, 2011 8:55 AM | Comments (0)
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 our environment from there.  This is where SQL Source Control shines, it integrates into SSMS.  It allows me to enroll a database into source control, and then check-in and check-out and control my resources.

I am including a step by step of the process I followed.

First you will come to the Welcome Screen and the status on the Database being enrolled.

4-23-2011 6-41-02 PM

The process starts by linking a database to Source Control.  I am connecting mine to TFS, but the fact is it can connect to other environments too.  Also important to note, it works really well with new or existing databases.

For example in my scenario I used AdventureWorksLT.

First, I add it.  Mind you, the first thing I did was created a location within my branching structure in TFS to store the DB Source.

4-23-2011 6-49-28 PM

There are two operating modes, dedicated or shared.  Again will depend on the approach your devs take, one is everyone has a copy or there is a central database everyone works towards.

Once the Link process has started, you will see an object enrollment process.  When it completes you will see a visual indicator stating the DB is now under source control.

4-23-2011 6-49-53 PM

If you do a right click on the database, and select Commit Changes you will get a list of the items that will be added, also as you click on the items on the list there will be a window displaying the changes in T-SQL.

4-23-2011 6-50-50 PM

Click on Commit.

4-23-2011 6-51-01 PM

Once the check-in completes you will notice the blue dots are no longer on the folders, which means all items are synchronized and current.

As I mentioned above, it is a very straight forward process, and a great tool for Change Management to be in effect for you DB environment.

Posted On Monday, May 2, 2011 9:07 PM | Comments (0)
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 TechEd 2011 in Atlanta, I hope to see you there.

Posted On Sunday, May 1, 2011 8:30 AM | Comments (0)
Disclaimer: The views expressed on this blog are my own and do not necessarily reflect the views of my employer.

Creative Commons License


Check out my about.me profile!

INETA Community Speakers Program

Follow enriquelima on Twitter
Locations of visitors to this page