Monthly Archives: January 2010

Livro SCOM 2007 R2 Unleashed (Mais Informações)

Após o lançamento do primeiro livro, SCOM 2007 Unleashed, tivemos uma grande mudança no SCOM com a versão R2, adição de muitas novas funcionalidades e correções, logo era perceptível a necessidade de uma literatura complementar para o SCOM 2007 R2. Foi pensando nisso que a autora Kerrie Meyler começou a elaborar a extensão do livro e surgiu a idéia do e-book SCOM 2007 R2 Unleashed. Desta vez ela convidou algumas pessoas para ajudar com o conteúdo e eu fiquei responsável pela parte de Service Level Monitoring. Com previsão para lançamento em 03/2010 (com venda na Amazon e nas principais livrarias internacionais), durante os 9 novos capítulos  o e-book trás os seguintes assuntos:


1.    Introduction and What’s New

2.    Unix/Linux Management: Cross Platform Extensions

3.    Operations Manager 2007 R2 and Windows Server 2008

4.    Using SQL Server 2008 in OpsMgr 2007 R2

5.    PowerShell Extensions for Operations Manager 2007

6.    Management Solutions for Small and Midsize Business

7.    Operations Manager and Virtualization

8.    Management Pack Authoring

9.    Unleashing Operations Manager 2007


·         Appendix A. OpsMgr R2 by Example

·         Appendix B. Reference URLs

·         Appendix C. Available Online



E a versão impressa do novo livro ou do livro atualizado, sai ou não sai? Isso vai depender muito da procura e interesse do público, fique antenado neste lançamento J



Obrigado pela leitura e até a próxima publicação,



Cleber Marques

Microsoft MVP & MCT | Charter Member: SCVMM & MDOP
Projeto MOF Brasil: Simplificando o Gerenciamento de Serviços de TI
Meu Blog | | |, le site pour les parents des enfants du web

Bonsoir Ă  tous,


Connaissez-vous le site C’ ?

Ce site est un guide en ligne interactif et ludique destiné aux parents pour les aider à mieux accompagner la vie numérique de leurs enfants.

Conçu avec le soutien des associations de protection de l’enfance, le site propose aux parents des parcours de formation personnalisés sur l’ensemble
des usages numériques de leurs enfants (surfer, chatter, jouer en ligne, etc.). Animations, quizz, micro-trottoir, interviews d’experts…

Le site permet de se former en s’amusant, tout en bénéficiant de conseils pédagogiques très concrets et de fiches pratiques, pour apprendre à éviter les risques.

Par ailleurs, vous apprécierez certainement les fiches pratiques, techniques ou pédagogiques, spécialement destinées aux parents. N’oubliez pas également, le dialogue et l’information ainsi qu’une part de confiance pour que la vie sur internet ne devienne pas le cauchemar des petits et des grands.

Après une première visite, vous y reviendrez tant les informations contenues sont extrêmement intéressantes pour les parents pas toujours rompus à l’administration de la sécurité d’un système d’exploitation.

Bonne soirée et bonne semaine.

DDD 8 Entity framework follow up – Will cast(column as int) allow use of an index


I pointed out yesterday that the EntityFramework doesn't
like smallints. Well it does and it doesn't The model handles them fine and the
objects have datatypes of int16 which is great.

However the queries that are generated do this odd thing with any predicates
on such columns. It applies a cast to column.i.e

as int)= @d

At first glance I thought oh now not another screw up with the SQL from
Entity framework, but on inspection of a query plan where the column in question
was indexed I still got a seek operation. Very nice, well done optimisation

When I pointed this out, I was asked whether this worked on SQL2005. Having
only got a SQL2008 instance on my laptop I took the question away for testing.
The reason of the question could be related to the fact that in SQL 2008 the
introduced the ability to cast a datetime to a date to be able to look for
specific days of data and still use an index.

I have now tested and can state that it does work on SQL


El Llenguatge dels ordinadors (Proximo evento en Vic)

El Llenguatge dels ordinadors

Dijous de 11 de Febrer del 2010 a les 20h (Durada aproximada 1:30min)

1ra Part – Introducció

Informació general
Dedicarem aquesta primera sessió a fer un recorregut entorn a l’evolució dels sistemes operatius i els llenguatges de programació tot posant especial èmfasis en la part mes filosòfica del desenvolupament d’aplicacions.

Entorn: Sistemes Operatius i Llenguatges
Audiència : Públic en General 

Biblioteca Joan Triadú
Arquebisbe Alemany 5

08500 VIC

Conduit :


Pep Lluis Bano

Spain.Net Leader
INETA Regional Speaker
MVP– Visual Developer


Visual Basic – Que hay de nuevo viejo?

Me complace poner a vuestra disposición la ultima charla realizada en Tarragona, compartiendo cancha con los profesionales más significativos en Visual Basic de nuestro país… espero sea de vuestro agrado.


Pep Lluis,

Save Energy when Running Your PC with ASUS EPU-6 Engine Utility

Windows 7 – The Pocket Guide | Get FREE books (Password: ilikefree) ASUS has a unique software called EPU-6 Engine that monitors your energy consumption and CO2 emissions of your system. I have utilized this software and have found it to be dependable and beneficial. It allows the system to exhibit minimal cooling to maximum cooling, […]

The Barry Dorrans’ farewell DDD performance

Seems I missed an interesting  at session at DDD8, Barry Dorrans’ final DDD performance, with assistance with of other speakers.

Barry you will be missed

Review of: Microsoft Dynamics AX 2009 Programming: Getting Started

I had been super() busy since the last few weeks so i was unable to do some serious blogging. I however got time last week and read through the new AX book ‘Inside Microsoft Dynamics AX 2009 Programming: Getting Started‘ by ‘Erlend Dalen’ and post my feedback.

This is a very good book for beginners who want to explore the technical side of Microsoft Dynamics AX 2009 as well as for Functional consultants who want to know what goes behind the hood. The language is simple and easy to follow and there is a case study which can be referred and the solution to the case study ‘Carz Inc.’ is unravelled as you move through the chapters. One good thing I like about this book is the plenty of sample code and step by step guidance which will help novice AX developers to understand the concepts and apply in real world scenarios.

Chapter # 8 (Integrate with Standard AX) is also very nice and provides some information regarding the important API’s which are required for Xmodule integration. There is plenty of sample code and entity diagrams for integration guidance. Considering the real world implementation scenario, this is an important chapter and has been well written.

Chapter # 9 (Creating a New Module) is also good for developers who want to create a new module in AX , just like the other AX standard modules and it walks the developer through number sequences, parameters, security aspects.

Chapter # 11 (Web Services) however deals with the old version of creating a web service (.asmx). In AX 2009 this framework has significantly changed to use WCF. You may want to refer to the latest AX 2009 SDK for AX 2009 AIF & WCF concepts.

Overall this is a very nice book for new developers. Its definitely worth reading this book. Kudos Erlend.

Open source takes on Active Directory

Coming out of RedHat ecosystem is FreeIPA,  a self-styled integrated security information management solution. IPA stands for Identity, Policy, Audit. Make no mistake – there is no PaidIPA, and FreeIPA is a take on Active Directory, combining the OS, LDAP, Kerberos and integrating Web and certificate services, as well as other infrastructure services into the software stack. Detailed features:

Version 1 will focus on

  • Allowing an administrator to quickly install, setup, and
    administer one or more IPA servers for centralized authentication and
    user identity management.

Version 2 will focus on

  • Adding DNS and Certificate Authority to the IPA core
  • Allowing an admin to join a machine to an IPA realm
  • Providing kerberos principal and cert to the joined machine
  • Providing service keytabs and service certificates to services
  • Managing the keytabs and certificates once provided
  • Plug-in architecture for IPA extensibility. freeRADIUS as a first plugin.
  • IPA Client code for managing authentication, authorization, caching, connection
  • Policy. Centrally managed sudoers/netgroups, SELinux role based access
  • Audit. Centrally collected audit logs from IPA servers and from IPA clients

I assume there will be an easy way to integrate email and real-time communications system into the IPA.

We have had all of this (bar a mandatory access control system) in Active Directory for a long while now. UNIX and Linux integrate well into AD through Samba and Likewise Open. But integrated authentication and authorisation subsystem designed specifically for Linux was missing. Until now, there were bits and pieces that are hard to integrate. FreeIPA is an attempt to close that gap and create some competition to Active Directory, which is a good thing.




Get the Windows Forums Latest Topics Google Chrome Extension

Windows 7 – The Pocket Guide | Get FREE books (Password: ilikefree)If you’d like to keep up with Windows Forums, right from your browser, you can get the Windows Forums Latest Topics Google Chrome Extension. More information | Download Extension | Daily Forum Digest Email | Get Google Chrome Random PostsThe Ribbon Graphical User Interface Will Define […]

How Long Has Your PC Been on for since Last Boot?

Windows 7 – The Pocket Guide | Get FREE books (Password: ilikefree) How Long Has Your PC Been on for since Last Boot? To check:Press Winkey+R, type CMD, and press Enter. Type net stats srv and press Enter. Look for Statistics since ##/##/###For me, just over one day:What about you? Tell us in the forums. Random PostsWinner of the ‘Best […]

Five-way Battle: Chrome, Safari, Opera, IE8, and Firefox

Windows 7 – The Pocket Guide | Get FREE books (Password: ilikefree) Ten years ago, when the web was new and everything was simpler, the choice of what browsers to use was much easier, with the only choice being whether to get NetScape or Internet Explorer.  Now, with the choices so wide, it can often leave […]

Entity Framework how to stop your DBA having a heart attack


My code and presentation from my session at Developer
Day 8 are now available here

DDD_8-Entity_Framework Code
Entity framework presentation

Any questions let me know


Estudo de caso: Ambiente virtualizado



See english version below…


Pessoal, hoje eu vou escrever um estudo de caso sobre como trabalhar em um ambiente virtualizado com tecnologias Microsoft. Minha idéia é apresentar as tecnologias para cada necessidade, como o Gerenciamento (físico e virtual), Monitoramento, Backup, virtualização de aplicações e Virtualização Apresentação. Pra começar vou falar um pouco sobre a organização, veja:



A empresa MOF Brasil cria diversos produtos, atua no mundo inteiro, seus funcionários estão em diversos lugares, no escritório e alguns trabalham em sua própria casa. Os usuários precisam utilizar as aplicações da empresa mesmo quando estiverem fora da rede, estas aplicações precisam estar sempre atualizadas, algumas aplicações só funcionam com o Windows XP, os computadores da empresa estão recebendo a instalação do novo Windows 7, alguns computadores são antigos e não possuem os pré-requisitos para o Windows 7. Parte da infra-estrutura da empresa é virtual, tornando os servidores de virtualização muito importantes, necessitando uma proteção constante dos dados e monitoração pró-ativa.



É claro que está empresa possui um domínio Active Directory, Exchange Server, SQL Server, ISA Server e até SharePoint, mas eu quero comentar aqui as tecnologias de gerenciamento e virtualização para responder: Como manter um ambiente com os requisitos citados acima?


·         O primeiro passo é trabalhar com o Failover Cluster do Windows Server 2008 R2 para manter o ambiente virtual em Hyper-V R2, com alta disponibilidade incluindo o recurso Live Migration, quando for necessário mover uma máquina virtual (VM) de um servidor para o outro, em caso de parada para manutenção de um dos servidores físicos ou falha.


·         O System Center Configuration Manager (SCCM) distribui o Windows 7 para todos os computadores na rede ou fora dela (pela internet), junto com o WSUS o SCCM atualiza as aplicações instaladas nos desktops e servidores (Aplicações da Microsoft e de terceiros). O SCCM distribui as aplicações virtualizadas pelo Application Virtualization (APP-V), diminuindo o esforço administrativo de novas instalações.


·         O Microsoft Enterprise Desktop Virtualization (MED-V) distribui aos usuários ambientes virtualizados em Windows XP para que estes usuários utilizarem as aplicações que só funcionam no Windows XP mesmo em desktops com o Windows 7 instalado.


·         O Remote Desktop Services (RDS) virtualiza a apresentação das aplicações, as aplicações são executadas no servidor e o usuário pode utilizar um computador com poucos recursos de hardware sem nenhum problema. Com o RDS e o APP-V é possível utilizar, ao mesmo tempo, o Office 2007 e o Office 2010 no mesmo computador, sem conflitos. E alguns usuários utilizam seus desktops de forma virtual através do Virtual Desktop Infraestructure (VDI).


·         O System Center Virtual Machine Manager (SCVMM) gerencia todo o ambiente virtual em Hyper-V, incluindo um servidor com o ESX da VMWare, administrando todas as máquinas virtuais, e se necessário, convertendo os servidores físicos em virtuais (P2V). O SCVMM usa o Offline Virtual Machine Servicing Tool para manter as máquinas virtuais (que estão desligadas) sempre atualizadas com a ajuda do SCCM e WSUS.


·         O System Center Data Protection Manager (SCDPM) protege os dados dos servidores físicos e virtuais, e é possível recuperar as informações de 15 minutos atrás se for necessário.


·         O System Center Operations Manager (SCOM) monitora pró-ativamente todo este ambiente, físico e virtual. Qualquer evento fora do normal é alertado e alguns são resolvidos automaticamente. Se for necessário, mais servidores RDS para  a estrutura de VDI o SCOM junto com o SCVMM (PRO Tips) podem automaticamente criar servidores virtuais.


Todas estas tecnologias ajudaram a empresa MOF Brasil, que agora vai colocar em prática também as sugestões do Microsoft Operations Framework J



O texto abaixo é uma tradução adaptada do que foi escrito acima. De agora em diante alguns assuntos eu vou publicar em português e em inglês, mas sem freqüência definida.



English Version: ON



Case Study: Virtualized Environment


Folks, today I will write a case study about how to work on virtual environment with Microsoft technologies. My idea is present some technologies for each necessity, as Management (Physical or Virtual), Monitoring, Backup, Virtualized Apps, and Presentation. To start I will talk about a company:



MOF Brasil develops some products, have branches in overall world, your employees are in many places, branches, and home office. These users needs to use your apps even out from network, these apps need to be always up to date, some apps only works in Windows XP, the desktops are being updated for Windows 7, some computers hardware don’t support Windows 7. A good side of infrastructure is virtualized, making virtualization server many important to business, needing a constant protection, and a proactive monitoring.



This company has Active Directory, Exchange Server, SQL Server, ISA Server, and even SharePoint, of course, but I want to talk about management and virtualization technologies to answer the question: How maintain an environment with these requirements?


·         First step is works with Windows Server 2008 R2 Failover Cluster to maintain a high availability Hyper-V environment, including Live Migration feature, when be necessary to move a virtual machine (VM) from a server to other, to stop a physical server to maintenance or failure.


·         System Center Configuration Manager (SCCM) deploy Windows 7 to all desktops on the network or internet, SCCM uses WSUS to update installed applications on desktops and servers (Microsoft an third party apps). SCCM deploy Application Virtualization (APP-V) virtualized apps, reducing administrative efforts to install new apps.


·         Microsoft Enterprise Desktop Virtualization (MED-V) delivers Windows XP virtualized environments to users use apps that works only in Windows XP, even when these users have Windows 7 in your desktops.


·         Remote Desktop Services (RDS) virtualizes apps presentation, these apps run on server an users can use computer without hardware requirements for the app. With RDS and APP-V is possible run Office 2007 and new Office 2010 in same computer, without compatibility problem. Some users have you desktop virtualized by Virtual Desktop Infraestructure (VDI).


·         System Center Virtual Machine Manager (SCVMM) manages all Hyper-V environment, including VMWare ESX Server, managing all virtual machines, converting physical server to virtualized servers (P2V) if necessary. SCVMM uses Offline Virtual Machine Servicing Tool to maintain virtual machines up to date with SCCM and WSUS.


·         System Center Data Protection Manager (SCDPM) protects data from physical and virtualized servers, its possible restore data/files of 15 minutes ago.


·         System Center Operations Manager (SCOM) proactive monitors all environment, physical or virtual. Any abnormal event has an alert, and some alerts are solved automatically. If necessary, SCOM and SCVMM can start a job to create more virtualized RDS servers for VDI infrastructure (using PRO Tips).


All these technologies help MOF Brasil, and now the company will uses Microsoft Operations Framework best practices too J


English Version: Off


Obrigado pela leitura e até a próxima publicação,



Cleber Marques

Microsoft MVP & MCT | Charter Member: SCVMM & MDOP
Projeto MOF Brasil: Simplificando o Gerenciamento de Serviços de TI
Meu Blog | | |

Tech-Ed North America 2010 – Pre-Conference Seminars Now Available

Get even more from Tech-Ed 2010 when you register for a Pre-Conference Seminar. Each full-day workshop offers in-depth study on a particular topic, which has been specifically developed to address the most relevant needs of today’s technology experts.

For an additional investment of $400 you receive dedicated class time on a specific subject with a noted industry expert. Select from one of these day-long workshops:

Visit the Tech-Ed website to see full descriptions of each seminar.

SQLBits Videos available now available


 You can watch all the sessions from SQLBits V now. They are available for
download or for viewing online.

If there is a delay then just wait, the videos are high quality and so are
very large.

These are the links to all the sessions

whistlestop tour of SSIS add-ins
SQL Server 2008 High Availability and Disaster Recovery – technical case
introduction to Master Data Services
cubes from ODS or Operational Systems
strategies for Analysis Services 2008
Integration Services Problems
High Performance Spatial Databases
& Backup Compression in SQL Server 2008
Visualisation with Bing Maps for Enterprise
Warehouse on a Fast Track forwards
warehousing features in SQL 2008
for simplification
I/O systems for SQL Server
– An Excellent Data Mining Tool
Dimensional with Data
need my reports……….Yesterday!
Project Madison
SQL Server Master Data Services
of MS StreamInsight.
to the Microsoft BI Technology Stack
make SQL fly – a technical session for developers and administrators who
believe in magic!
go more functional – F# WHAT , WHY and BI
SQL Server 2008 R2: What’s New in Reporting Services
Concurrency Internals
– old tricks for a new dog?
Your Feet Up : Simplified Management using the Enterprise Policy
Management Framework
World SQL Server High Availability
Report Builder
Service Business Intelligence- Project Gemini
consolidation with SQL Server
SQL 2008
Development Features
Injection Attacks (and how to prevent them)
Server 2008 – Unstructured Data Storage Solutions and Best
Server optimization stuff you won’t find on Google (yet)
NoSQL, SomeSQL – A look at non-relational databases
LINQDataSources and EntityDatasources in Database Design
Server 2008
for cache? – Troubleshooting memory problems in SQL Server 2008
R2 Duo: Running SQL Server 2008 R2 on Windows Server 2008 R2 Core
Tuning with Colin Chapman, Enzo Ferrari, and The Stig
Using Perfmon
and Profiler
Virtualising SQL
What's new
in R2 for the DBA
When a
query plan goes wrong


Premières rumeurs sur le nouveau Windows Home Server (Vail)

Les spécifications semblent se préciser :

  • Construit sur Windows Server 2008 R2.
  • Serait dispo en deux versions, HOMESTANDARD et HOMEPREMIUM
  • x64 nĂ©cessaire.
  • 160GB de disque mini.
  • l’interface utilise les nouveautĂ©s et le look Windows 7 (Aero, …)
  • Support natif des foncions de http://toutwindowsgroupe rĂ©sidentiel (homegroup) de Windows 7
  • Nouvelle console entièrement basĂ©e sur des Add-Ins :
  • Vivement que je puisse la tester !! Et en espĂ©rant que d’ici la Microsoft France aura une vraie stratĂ©gie marketing pour la promouvoir !!

    Laurent Gébeau –

    Source :

    Google invites attacks on Chrome

    Google has launched an experimental programme to encourage external security researchers to find and report vulnerabilities in its browser. Borrowing from the Mozilla Foundation’s 2004 Security Bug Bounty Program, $500 will be awarded for each bug found. In special cases, a committee will decide whether to increase the amount to a maximum of $1,337 – however, this reward is only for vulnerabilities which are particularly critical, or particularly smart reports on vulnerabilities and their exploitation.

    According to Google, it doesn’t matter whether the vulnerability is in the open source Chromium version or the binary Chrome version. The two differ only marginally anyway – Chrome additionally contains GoogleUpdater and sends an RLZ parameter which is forwarded to Google when a search term is entered in the Chrome address bar. The company will not be offering rewards for reports of bugs in third-party plug-ins.

    Continued here:

    Details in The Chromium Blog: Encouraging More Chromium Security Research

    “Leak” about Microsoft TechDays 2010 Portugal

        Today we had a small “leak” from an unknown source from Microsoft, about TechDays 2010 in Portugal stating that you can already register for techdays 2010 at

        Don’t forget to go there and start now to register for this incredible event for both Developers and IT Pros.

    Keep Your PC in Top Shape with a Semi-Annual Hardware Cleaning

    Windows 7 – The Pocket Guide | Get FREE books (Password: ilikefree) One of the worse things for any electronic component is “heat”. Cooling is essential for electronic components! Every six months I clean the inside of my system and perform maintenance on the electrical contacts of each card. REMEMBER Grounding is essential always when performing […]

    Recent Comments