Herleson Pontes - IT Professional : SQL Server

Webcasts Technet – Migration to SQL Server 2008: 10 reasons to do it!

herleson — Thu, 30 Apr 2009 05:33:00 GMT

Hi Friends,

It´s with great happiness that I invite you to attend the Microsoft Technet Webcast that I will be presenting this Thursday: Migration to SQL Server 2008: 10 reasons to do it! This webcast will be present in Portuguese, and will start at noon (Brasília - GMT-3).

For those who don´t know, webcasts are online events promoted by Microsoft itself, where IT professionals have the opportunity to learn more about actual and new technologies. In these events, solutions such as Windows Server 2008 R2, Windows 7, SQL Server 2008, Exchange Server, and others are covered.

Webcasts have many advantages:

Comfort, peaceful and commodity, since they have the same format of a live presentation, but let you watch it at work or at home
The presenters are professionals recognized in all country, including MVPs and Microsoft Team
The presentations are grouped in series, providing a better learning
Download of the material related to the presentation
Drawing of many prizes
And these presentations are COMPLETELY FREE!

At April 30th, I´ll present the webcast Migrating to SQL Server 2008: 10 reasons to do it. Developed to Brazilian professionals, we will show in this session ten reasons that you should consider now to upgrade your data platform to SQL Server 2008, including demonstrations and practical examples.

Indeed, I will be presenting, with Maycon Alves, MORE THAN 10 REASONS for you to migrate to SQL Server 2008. There are so many new features and functionalities that this presentation deserves more demonstrations than proposed!

These demonstrations are ready, and we will have many surprises throughout the presentation! YOU CAN´T MISS!

You can register for this webcast at the URL (Portuguese): https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032409717&EventCategory=4&culture=pt-BR&CountryCode=BR

I wish to dedicate this victory to my wife Priscila, who is always at my side, supporting and taking care of me. Thank you my love: you´re everything to me. I LOVE YOU!

I´m counting with your attendance in this webcast!

Regards,

Webcasts Microsoft Technet – Brazil and United States!

herleson — Tue, 14 Apr 2009 03:22:00 GMT

Hi Friends,

It´s with great happiness that I invite you to attend the two webcasts which I´ll be presenting in this month: Migrating Databases from Oracle to SQL Server 2008 and Migrating to SQL Server 2008: 10 reasons to do it. In special, the first one is a great victory that I wanna share with you all.

For those who aren´t familiar with, webcasts are online events hosted by Microsoft, where IT professionals have the opportunity to develop their knowledge about Microsoft solutions. In these events, solutions such as Windows 7, Windows Server 2008 R2, SQL Server 2008, Exchange, and other technologies are presented. Also, these presentations are completely FREE!

However, tomorrow (04/14) is the big day! Starting at 01:00 PM (Pacific Time), one of my dreams will come true: I will be presenting my first official Microsoft webcast for Microsoft US! The webcast is called Migrating Databases from Oracle to SQL Server 2008, and it´s a part of webcasts that will be played at TechEd USA on May! During Microsoft´s biggest event of the world, my presentation will be available for professionals, and after will be available for download!

This webcast will be in English, and we will demonstrate SQL Server Integration Services, SQL Server Migration Assistant and Hyper-V!

The URL to register for these webcasts are below:

Migrating to SQL Server 2008: 10 reasons to do it (Portuguese): https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032409717&EventCategory=4&culture=pt-BR&CountryCode=BR
Migrating Databases from Oracle to SQL Server 2008 (English): http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?culture=en-US&EventID=1032408185

I wish to dedicate this victory to my wife Priscila, Who is always supporting me and give me strength to continue. Thank you my love, you´re my bless. I LOVE YOU!

I´m counting with your presence!

Regards,

MICROSOFT EVENT (LEVEL 300) - Installing and Configuring a SQL Server 2008 Instance in a Windows Server 2008 Domain

herleson — Wed, 04 Mar 2009 10:58:00 GMT

Hi Friends,

It's with great happiness that I invite all IT Professionals from Ceará and beneath states to attend a unique presentation, totally focused for professionals who manage SQL Server instances in Active Directory domains: Installing and Configuring a SQL Server 2008 Instance in a Windows Server 2008 Domain. This event will be presented by me and by my best friend Rafael Biserra, a recognized Windows Server administrator of SecrelNET.

One of the most common scenarios of SQL Server instance installation is in Windows environments with Active Directory Domain Service enabled. In this presentation, professionals will learn how to install and set up a SQL Server instance in a domain environment, some security tips and best practices. Also, we will present some important concepts of Windows Server and SQL Server. Throughout the presentation, we will set up a new SQL Server instance in a IT environment, while we explain the tips. This event is level 300, which means that the professionals who will attend this event must know some Windows Server and SQL Server basics.

This great event will happen on March 12th, at 06:30PM (GMT-3), at FANOR (Fortaleza, Ceará, Brazil). This is a Live presentation, and the language is Portuguese. But don´t worry: we will be holding English events soon.

Beside this event, we will host four more presentations until the end of this month, including two events about Windows 7. Ah, it´s good to remember that all Microsoft events hosted by us are TOTALLY FREE! And, at the end of each presentation, we´ll draw some gifts among the participants. In other words, you keep your knowledge up to date, don´t pay anything, and you can still win prizes!

So, what are you waiting for? Don't lose time: register now and assure your seat! The registrations are made by using the following URL: http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032407307&Culture=pt-BR.

I wait you there! It will be a fantastic event!

Regards,

New Year, New Paths

herleson — Sun, 08 Feb 2009 18:28:00 GMT

Hi Friends,

I´d like to begin this post apologizing about my “missing” in the last few months. I´m involved in a project that finishes this week, and soon I´ll be sharing with you here in my blog.

But, until that, let´s get back to work! And I start sharing with you my newest path: the Master degree in Applied Informatics.

In January, five slots for this Master course were open. Since I became Bachelor a few weeks ago, I took the chance and participated of the trials. And, after a week, I was selected and I will develop my project focused in the Database area!

Below is the screen of the website with the list of the five selected students.

I wish to dedicate this victory to my only one love: my wife Priscila. Without her support, I couldn´t have achieved this great victory. Thank you, my love. I LOVE YOU!

Soon we´ll have more news! Wait and see!

Regards,

Windows Installer 4.5 - Available for Download

herleson — Sat, 11 Oct 2008 18:11:00 GMT

Hi Friends,

Few professionals know it, but since the beginning of June Microsoft released the version 4.5 of Windows Installer for download. For those who don’t know, the Windows Installer allows the install of software and the configuration of services in Windows systems, using the *.msi files and its derivates (For example, the *.msu files allow the installation of HotFix).

The version 4.5 of Windows Installer brings some interesting functions, like:

Multiple Package Transaction: Now you can create a single transaction from multiple packages. In a multiple package transaction, a chainer is used to dynamically include packages in the transaction. If any of the packages do not install as expected, you can roll back the installation.
Embedded UI Handler: You can embed a custom user interface (UI) handler in the Windows Installer package. This makes a custom UI easier to integrate. You can also invoke an embedded UI handler from the Add or Remove item in Control Panel.

There are other interesting things, like the Shared Component Patching Resiliency During Uninstall and the Custom Action Execution On Update Uninstall.

But, the problem is that this version of Windows Installer is not installed automatic via Windows/Microsoft Update utilities. Users must download the installer according their version and language of Windows.

That why some users are experiencing problems in installing some standalone components of SQL Server 2008. When you start the SQL Server 2008 installation, the setup program installs the .NET Framework 3.5 and the Windows Installer 4.5, so no errors will arise. But, if you download and try to install a component, such as the Books Online, an error will appear, telling that the Windows Installer version is out of date.

To download the installer of this new version of Windows Installer, go to the URL http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=5a58b56f-60b6-4412-95b9-54d056d6f9f4 and download the file according to the version of your Windows system.

This version supports all editions of Windows XP SP2 and SP3, Windows Server 2003 SP1, Windows Vista SP1 and Windows Server 2008.

Regards,

BETA EXAM - 70-433: TS: Microsoft SQL Server 2008, Database Development

herleson — Fri, 19 Sep 2008 13:46:00 GMT

Hi Friends,

And one more exam of SQL the Server 2008 certification track will be available in the next Friday.

Microsoft has just announced to public the beta exam of SQL Server 2008 for database developers: 70-433 (TS: Microsoft SQL Server 2008, Database Development). This exam belongs to the MCTS (Technology Specialist) credential, and it can be taken by professionals for free.

The coolest thing about beta exams is, if you approved in a beta, you win the credential when the final version of this exam becomes available. The only problem is that the result of beta exams, differently of final exams, is sent to you three or four months later.

The exam 70-433 is Microsoft SQL Server 2008, Database Development. This exam, developed for database developers, tests the professional’s knowledge in developing and implementing data solutions using Transact-SQL.

The period of this beta exam starts this Friday (September 19th), and will be on until October 10th.

If you want to take this exam, access Prometric website (www.2test.com) and schedule the desired exam. The code of these beta is in the format 71-XXX. On the last step (Payment), inform the promotional code (Promocode): F589G. After you inform the code, the system will discount the whole value of the exam. Then, you confirm the appointment and get ready for the exam!

You can obtain more information about the topics that are covered by this exam at the link: http://www.microsoft.com/learning/exams/70-433.mspx

I already schedules mine. And you? Hurry up and get ready for this exam! The seats are limited.

Regards,

SQL SERVER 2008 BETA EXAM - 70-451 (PRO: Microsoft SQL Server 2008, Designing and Optimizing Database Solutions)

herleson — Wed, 27 Aug 2008 05:06:00 GMT

Hi Friends,

And the last exam to complete all SQL Server 2008 certification tracks will be available in the next Friday.

Microsoft has just announced to public the beta exam of SQL Server 2008 for database developers: 70-451 (PRO: Microsoft SQL Server 2008, Designing and Optimizing Database Solutions). This exam belongs to the MCITP (IT Professional) credential, and it can be taken by professionals for free.

The exam 70-451 is Microsoft SQL Server 2008, Designing and Optimizing Database Solutions. This exam, developed for database developers, tests the professional’s knowledge in planning and implementing data solutions using Transact-SQL, and also tuning queries and scripts.

The period of this beta exam starts this Friday (August 29th), and will be on until September 30th.

If you want to take this exam, access Prometric website (www.2test.com) and schedule the desired exam. The code of these beta is in the format 71-XXX. On the last step (Payment), inform the promotional code (Promocode): 14F65. After you inform the code, the system will discount the whole value of the exam. Then, you confirm the appointment and get ready for the exam!

You can obtain more information about the topics that are covered by this exam at the link: http://www.microsoft.com/learning/exams/70-451.mspx

I will schedule mine as soon as possible. And you? Hurry up and get ready for this exam! The seats are limited.

Regards,

Microsoft SQL Server 2008 - BETA exams available!

herleson — Mon, 18 Aug 2008 12:32:00 GMT

Hi Friends,

Microsoft has just released to public two beta exams of SQL Server 2008: 70-450 and 70-452. These exams belong to the MCITP (IT Professional) credential, and they can be done by professionals by free. The coolest thing about beta exams is, if you approved in a beta, you win the credential when the final version of this exam becomes available. It means that, if you take a beta exam and pass, you won’t need to do it again, ´cause the credential is yours. The only problem is that the result of beta exams, differently of final exams, is sent to you three or four months later.

The exam 70-450 is Microsoft SQL Server 2008, Designing, Optimizing and Maintaining a Database Administrative Solution. This exam, developed for Database Administrators (DBAs), tests the professional’s knowledge in planning, tuning and implementing a data solution, with questions of Backup, Replication, Security and so on.

The exam 70-452 is Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008. This exam, developed for administrators of Business Intelligence solutions, tests the professional’s knowledge in planning, tuning and implementing Data Warehouse and Data Mining solutions, integration between different solutions and design and deploy of reports using the BI triad of SQL Server (Integration, Analysis and Reporting Services).

The period of these beta exams has started last week, and will be on until September 10th for the exam 70-452 and until September 16th for the exam 70-452.

If you want to take these exams, access Prometric website (www.2test.com) and schedule the desired exam. The code of these beta is in the format 71-XXX. On the last step (Payment), inform the promotional code (Promocode), according to the exam:

70-450: 239F4
70-452: 3568C

After you inform the code, the system will discount the whole value of the exam. Then, you confirm the appointment and get ready for the exam!

You can obtain more information about the topics that are covered by these exams at the links below:

70-450: http://www.microsoft.com/learning/exams/70-450.mspx
70-452: http://www.microsoft.com/learning/exams/70-452.mspx

I have already schedule mine. And you? Hurry up and schedule your exam! The seats are limited.

Regards,

Welcome to my first English post!

herleson — Sun, 17 Aug 2008 02:16:00 GMT

Hi Friends,

Welcome to the first post of my English blog! It’s a pleasure for me to share news, articles, webcasts, events and many other things about Microsoft Technologies and Solutions to my worldwide IT Professional friends.

I live at the beautiful city of Fortaleza (Brazil). Here the sun shines almost every day and the beaches are places for fun and rest.

I’m Microsoft Most Valuable Professional (MVP) on SQL Server since July 1st 2007, Microsoft Certified Trainer (MCT), Microsoft Certified IT Professional, Microsoft Certified Technology Specialist and Microsoft Office Specialist.

I work as an IT consultant and instructor of Desktop, Web and Mobile environments, with more than seven years of expertise. My first contact with the IT world was with a TK90X computer, where I learned how to develop small algorithms with BASIC language (Ah! Old times!), about 17 years ago.

Here in Brazil, I contribute freely with the IT community, presenting many events and webcasts, writing articles, answering questions at Microsoft forums and by emails. I believe that the growth of a community and its professionals comes with sharing: When I share my knowledge, I’ll be helping others to work efficiently in their jobs. One day, it will be them that will help me to accomplish a task at my job. It’s a two-lane way: both sides win! (It’s like the Imagine Cup motto: You win! We all win!)

We started to develop the concept of community here in my state five years ago. Before that, professionals were incapable to learn more about Microsoft software and technologies, because all the things were happening in São Paulo. Then, we started to change this reality and calling all professionals to attend our initiatives, like events and meetings.

Nowadays, Ceará is the third state of our country that present Microsoft Events, and twice a year Microsoft Brazilian office sends speakers to present events for local professionals. Also, I travel all the country showing Every day, more professionals are studying and sharing knowledge with others. I’m really proud of being a part of this change, and I hope to help more professionals to learn more about Microsoft products, such as SQL Server, Windows Server and Windows Vista.

That is the motivation of this blog: to expand my work to professionals from all parts of the world, helping them to build their careers and learn more about this amazing world of IT.

The official URL of this blog is http://www.herlesonpontes.com.br/. There, you can choose the language (Portuguese or English). Spanish soon!

I also contribute with articles, webcasts and presentations for Microsoft Technet Brazil. I’m writer of SQL Magazine, WebMobile and DevMedia portal.

To end, I dedicate this post to my wife, Priscila. Thank you, my love, for being at my side in this new moment of my life. I LOVE YOU!

So, fell welcome here and count on me to help you to improve your skills in Microsoft solutions.

Let’s start!

Regards,