SSIS, Sql Server Integration Services, is a full functional development environment. Unfortunately when we are building a package, before register and release the package, we need to Log, trace or debug the script. This process is a MUST if we are using a script task, a task which give you the availability to work directly with C# or VB.NET.
Package Example.
Create a simple SSIS project and insert a Sequence Container, then in the sequence container insert a Script Task and choose the C# language.
Please don't take care about my screenshot, I know the package fails, but because I toke a screenshot and I'm lazy ...
This is just an example, ok?
Now let's create a couple of Global Variables in our package and let's call it: VARIABLE01 and VARIABLE02.
Finally let's go to edit our script task (right click on the task, edit script in the properties).
Some C# code.
First of all in out package class let's go to create a function that return our variable value.
1: private string ReturnVariableValue(string name)
2: { 3: string value = string.Empty;
4: value = (string)Dts.Variables[name].Value;
5: return value;
6: }
And now, let's write this if block in the main routine:
1: if(ReturnVariableValue("VARIABLE01") == string.empty 2: { 3: WriteLog(string.format("The variable value is {0}", 4: ReturnVariableValue("VARIABLE01")); 5: Dts.TaskResult = (int)ScriptResults.Success;
6: }else{ 7: WriteLog("The variable is empty!!"); 8: Dts.TaskResult = (int)ScriptResults.Success;
9:
10: }
Now we are ready to view how we can interact with the users in the SSIS package.
It's very important that in the main routine you assign a result for the package execution, don't forget!!
Write to the Log, to the Output or to the Windows.
Well, now we need to build our WriteLog function. We have 3 way to do that.
The first one is to write directly on the Log:
1: Dts.Log(message, 999, null);
The second one is to write to the Output, so when you will run the package in the Business Intelligence IDE, you will see the message in the output console:
1: Dts.Events.FireInformation(
2: -1,
3: "Check Variables",
4: message,
5: string.Empty,
6: -1,
7: ref False);
Or you can send a MessageBox:
1: System.Windows.Forms.MessageBox.Show(message);
If you have a technical blog like me, one of the most frustrating thing is the ability to copy and paste well formatted code into your blog. I have found a lot of JavaScript plug-in but no one works as I want.
Today I have found on windows live gallery a cool plug-in for windows live writer, Code Snippet.
This plug-in is written in C# and works very well with Windows Live Writer and SubText. I show you some example.
As you can see from the previous picture, it's a very useful plug-in for a NET blogger. You can:
- View different color for alternative lines and choose the color and the border line
- View the rows number
- Embed the CSS in the PRE tag or use your blog style
Cool Plug-in, in my opinion the best found on the web until today!!
Finally is out and I'm a friend of the Author (Simone Chiaretta)!!
ISBN: 978-0-470-43399-7
Paperback
500 pages
March 2009
Beginning ASP.NET MVC is for developers who have .NET and ASP.NET experience, but want to enhance their level of knowledge and need to learn about the MVC framework. The book is simple and basic in its approach, because it allows readers to learn the concepts in a straightforward, uncomplicated way, but it still assumes a level of programming background and knowledge. This appeals to those who don’t want to get bogged down in learning ASP.NET, but need to know how to get the most out of ASP.NET MVC. The book covers all the main topics about ASP.NET MVC, and applies all of the latest Microsoft technologies to demonstrate the benefits of its usage.
The book covers these key topics:
The concept of Test-Driven Development and unit testing
The principles of MVC pattern and the role of MVC pattern in TDD
An introduction to ASP.NET MVC and reasons to have such a new technology
How MVC pattern is implemented in ASP.NET MVC
A detailed discussion about the main elements of ASP.NET MVC including model, view, controller and routing
A detailed discussion about the main classes in ASP.NET MVC and how the abstraction and isolation is achieved for them
How to unit test an ASP.NET MVC application
Separate topics for authentication, authorization and AJAX
How to move from traditional ASP.NET webforms to ASP.NET MVC
Case studies to show the discussed topics in a practical and applicable way
You can buy a pre-sell on Amazon.uk at this address.
One of the most useful function that I like in SQL Server is the FULL TEXT search. When you have a table or some tables with string fields, like VARCHAR or NVARCHAR, you know that running LIKE clause is CPU consuming.
In order to run this example you must before activate the FULL TEXT search capability in your SQL engine. To do that:
- Open the SQL Server surface area configuration.
- Open the Services and Connections page.
- Configure the service to be enable.
Now you must run this Stored Procedure in order to activate the service in the Management Studio:
1: EXEC sp_fulltext_database 'enable'
Last step is to activate the service for the tables, fields you want to use.
- Right click on the table and choose: Full text index>>define new ...
- Define the columns that will take part in the index, the schedule and the file group (consider a separated file group for big data)
Now we can run our examples. We will use the two clause for implementing a FULL TEXT search, the CONTAINS and the FREETEXT.
Please refer to the previous post for the table schema (here).
Using the CONTAINS clause.
The CONTAINS function search the exact word matches and word prefix matches. Let's go to search all the addresses with the word Street.
1: SELECT
2: E.FirstName, E.LastName, A.Street
3: FROM
4: Employee AS E INNER JOIN Address AS A
5: ON
6: E.Employee_id = A.Employee_fk
7: WHERE CONTAINS(A.Street, 'Street')
And this is our result:
1: Carl Mark Main Street
2: Carl Mark Front Street
3: Pier Francoise Red Street
4: Mary Stevenson White main street
In this case with the CONTAINS clause we will get all the rows where there is a word Street but not the rows where the word Street is inside another word like: MainStreet. To do that we need this syntax:
1: WHERE CONTAINS(A.Street, '"*street"')
If you note, you need a double quote and a * before to find everything with street at the end.
Using the FREETEXT clause to get more results.
If you need to match all the result with the street word inside and similar results, you need to use the FREETEXT clause.
With the freetext clause, SQL generates various forms of the search term, breaking single words into parts.
1: SELECT
2: E.FirstName, E.LastName, A.Street
3: FROM
4: Employee AS E INNER JOIN Address AS A
5: ON
6: E.Employee_id = A.Employee_fk
7: WHERE FREETEXT(A.Street, 'street')
The result here will be:
1: Carl Mark Main Street
2: Carl Mark Front Street
3: Pier Francoise Red Street
4: Pier Francoise mainstreet
A subquery is a query that is nested into another query. When you work with T-SQL you have different ways to use subqueries, and every method has different performance results.
Our example is a Database with two tables, take a look on the image below:
In this case we have a main table Employee with a one-to-many relation to the Address table.
Where value IN. (non correlated example)
The first query I want to show you is:
1: SELECT
2: E.FirstName, E.LastName
3: FROM
4: Employee AS E
5: WHERE
6: E.Employee_id IN
7: (SELECT
8: A.Employee_fk
9: FROM Address AS A)
In this case the SELECT will search all the Employee id in the address table and will return a list of id used by the first query to show the employee found. In this case we will not view the employees without and address. This is a non correlated example, because SQL will search before in the Address table, without know nothing about the employee table, than it will match the list of id with the employee table.
Where value EXISTS. (correlated example)
The second query will use the EXISTS clause:
1: SELECT
2: E.FirstName, E.LastName
3: FROM
4: Employee AS E
5: WHERE EXISTS
6: (SELECT
7: A.Employee_fk
8: FROM
9: Address AS A
10: WHERE
11: E.Employee_id = A.EMployee_fk)
In this case the query is using a correlated value from the outer query. The inner query match the id's with the id's in the outer query.
The performance for this queries are totally different if you are working with thousand of rows.
To understand which one is better, you should run both queries with an execution plan and try to build the right clustered index to run the most performing query.
This is an unusual post for me, today I will not talk about C#, or about Design Patterns or about SQL but about IT audit.
In the past I have worked in a couple of banks in Switzerland and as a consultant. Now I'm working as an IT Manager in a finance company in Bermuda. One of the most non valued and non considered process in the IT departments are the procedures and technical manuals.
But not for me.
In my opinion one of the most important thing in a well maintained system is to keep live and up to date the procedures and the technical manuals. In this way in case of failure, in case of modify and in case of audit, the IT department will be ready to fly!!
Unfortunately Google doesn't give us a lot of suggestions and examples, so I want to share with you my knowledge.
What's an IT procedure?
An IT procedure is a document, manual that explain a process or a system in a well knows format, readable also by non-IT people. The document must contains some critical information that I will classify today for you.
Please don't create IT procedure with 10 thousand different font and colors, because it's an official technical document and non a graphic challenge!!
Main Structure.
Starting by the name, the document must represent what you are talking for. For example, if the document represent a backup procedure, the correct name syntax should be [PIT] [number] [procedure], where PIT means Procedure Information Technology, the number is a unique GUID assigned to the document, and the name in our example should be Backup procedure.
After the cover we should add the approval section. This section must be signed to give to the document a real mean.
After the approval we have to add the Table of Content and to accomplish this step, if you're using word, you can simply add a table of content object and use the Header 123456 to represent the various section of your manual.
The various sections.
Every section of the document should represent a particular information. You don't have to create a section for every step of the procedure, that part is the process section ... Let's see what I'm talking about.
Principal section [procedure name].
In this section you should explain the process you are going to document and add some extra sub section like: objective, description, scope, priority ...
Authorization and roles.
In this section you should explain who is involved in the process, which are the responsibilities and so on. Sub section are: authorization, roles (brief description), people involved in the manual.
Roles.
This is the detailed section of the previous one. For every roles present in the procedure you have to create a subsection that explain in details the role, the scope of the role and the people who take part in the role.
Process.
This section explains in details the process. I cannot make an example because for every process there different steps, but let's try to imagine a backup procedure, the subsection could be: backup process, verify process and restore process.
Don't forget to add a schematic flow that describe the process in all its content. Should be a diagram, a work flow or whatever you consider right.
Request forms.
If the process contains one or more forms, here is the place where you have to add a small screen shot of these forms, for every form you should create a subsection that describe the form instead.
Key contacts.
The key contacts is often the final section of an IT procedure. Here you have to add all the people involved in the document and in the process, why you should contact one of them, the exact role described previously in the document and so on ...
External links.
I suggest some articles (my blog is not a bible for nobody) that can help you.
How to write an audit approach
How to write procedure to increase control
How to write a standard operating procedure (IT specific)
Compliance books (ASAP my personal one)
Hope this will be helpful for someone. And enjoy your audit!!
I want to post something about what you're heard about Bermuda and a balance of wrong and true.
Bermuda is a bad move for your career?
Bermuda it used to be a halfway house on the road to professional oblivion for expat business types who were either tipsy or incompetent or both, but not any more. You can find very professional people in Accounting, IT and Financial area.
Everything is expensive?
Actually, also if we compare Bermuda to Europe after the Euro, Bermuda is merely expensive. A month rent for an house could be from 2000 to 20000 this is true, but with a salary of 6000 you can live good and save something, and the lowest rate salary here is 65000 USD annual.
Bermuda has racial problem?
First of all, is there any place without racial problem, come on!!
There are differences of opinion from race to race, this is true, and the black point of you is a little bit more expressed here. Nobody is disadvantaged economically and educationally or in access to complete healthcare.
Expact are third class citizens?
It could be for something, but not for your career. You can join financial companies here where all the management team is not Bermudans and also you can find good landlord that accept only expat people.
In another way you can find some places where if you aren't Bermudans, you have to wait to be served.
Is Bermuda suitable for Gay?
Definitively I can say NO! I'm married and I'm getting in touch with a lot of local and expat people, but if I have to be honest, Gay here are not considered.
Homosexual behavior here was illegal until 10 years ago, yeah I'm saying illegal, so you can imagine how is the local culture about Gays.
What about the hurricane?
I came from Europe, Italy, and definitively we don't have any Hurricane, Cyclone or stuff like that. Bermuda's people for century have built houses and offices as if they were under constant cannon ball. The most hard was Fabian in 2004 and 4 people were killed, but Bertha this here has passed with a power of 1 and nothing has changed. I can say that here is more pretty safe and organized than in U.S.A. about hurricane.
Guys this is what I can say about my 4 months experience in this Island.
If want to ask me something more (I'm not an expert) contact me, maybe I can suggest you.
This guide is made for who already has SubText installed and wants to upgrade to the latest release, the V 2.0.
Pre-requisite.
First of all, starting from the version 1.9 subtext requires the ASP.NET 2.0 so be sure that your web server, or your hosting provider can give you the way to change the ASP.NET framework in IIS control panel.
You need a version of SQL Server.
Your blog user that access the Database MUST have temporally DBO permission in order to apply some changes to the Database.
First step, backup and upgrade new application.
First of all I suggest to you to backup your existing web site (SubText blog) and save the package locally in your computer or in a separate folder in your web site. In this way it should be very useful to rollback in case of failure.
Second step you should download from SubText web site the Version 2.0.
For a faster installation you should create into the wwwroot of your web server a new folder called subtext V 2.0 or something else and then redirect your domain to the new folder.
This is my situation on WH4L (Web Host for Life) web server:
I have the wwwroot folder with two subtext package inside, the version 1.9.5 working and the new installation.
If your installation is an upgrade, download the appropriate package and delete the database file contained into the App_Data folder of the new package.
Merge Information.
Before start I suggest to verify everything like:
- Check your Host Admin panel located at http://yourblog.something/hostadmin and be sure to access in, otherwise you can run this query to reset your host admin password.
- Merge into the new web.config file the information from the old web.config of the previous configuration. Usually you should change information like: Database connection string, e-mail setting, Lightbox configuration and other third party configurations added previously to your blog. You can run a program like WinMerge very useful in this case.
- Copy all the files you have customized into the new package. This include your image folder, it contains all the images of your old posts. Your video, example, personalized skin and other files you added after the installation of your previous package.
Upgrade the blog.
Now it's time to go to your host panel and point the domain to the new folder. After do that it should be very easy to rollback to the previous version in case of failure.
If everything it's done well, you should see this page:
if you are not logged in as an Administrator this is the page your users will see until you will finish the Upgrade process.
This is the page you will see if you are logged in as an administrator:
Issues with Web Host for Life.
My web host for life doesn't recognize this tag in the web.config of the new package
<EnclosureMimetypes>
<add key=".mp3" value="audio/mpeg"/>
<add key=".mp4" value="video/mp4"/>
<add key=".zip" value="application/octetstream"/>
<add key=".pdf" value="application/octetstream"/>
<add key=".wmv" value="video/wmv"/>
<add key=".wma" value="audio/wma"/>
</EnclosureMimetypes>
Actually I have commented this section, I will let you know what to do.
Please Simone tell me what to do here. Thanks.
My friend Simone Chiaretta is writing his first book about Beginning ASP.NET MVC in collaboration with Keyvan.
The book will be targeted to the developers that are not really focused on the MVC framework. This framework is new in Microsoft and it is still in a Beta version but personally, I'm using it and I have used this framework for two web project and it's awesome!!
You can find a detailed series of articles about ASP.NET MVC, written by Simone on DotNetSlackers. I suggest to everybody to read them.
If you wanna read more details about the book, the Publishing date and related stuff, you can go directly to Simone weblog and read his post about, or go to Keyvan weblog and read his post about.
Enjoy!!
SubText is an open source Blog engine written with the Microsoft NET framework. Actually my English blog and also my italian blog are working with this blog engine.
After one year is out the new version, 2.0.
You can find the download here.
Details.
Simone Chiaretta a good friend of mine is one of the Developer contributor of this project, and he has released a series of posts about the new future in his blog:
- Publish in the future
- JS and CSS performance optimization
- Enclosures
If there is someone like me that are still using subtext in the version 1.9.5 or less, you can find here a detailed article about the upgrade procedure.
Enjoy SubText.
Yesterday Microsoft has published, for all the Microsoft MSDN subscriber, the new service packs for Visual Studio 2008 and NET framework 3.5.
The service pack for Visual Studio 2008 is here.
The service pack for NET 3.5 is here.
Additional Notes.
I have installed first the Service Pack for the NET 3.5 that is not really heavy. After the installation I have rebooted my computer and everything was still working.
The I have installed the approximate 893 Mbyte of VS08 SP1 that it's really heavy. All the project continue to work.
I want also to put in evidence, for all the people that are working with WPF and/or Silverlight and/or MVC; everything will continue to compile after this update, don't worry.
Enjoy the Download!!
Last week I have completed my first group of lessons at the Iko course. The level are tree: Discovery, Intermediate, Independent.
When you take the first lessons about the Discovery level, you don't need a kite because your teacher will give you everything. But when you start the intermediate level, you start with kiting; and in my opinion, because every kite is completely different, i have decided to buy my personal kite, board, and various instruments.
My 5th line kite.
This is a new entry in kite-boarding, actually you can find only kites with 4 lines, but I have bought a brand new North kite 5 lines, the Rebel 08.
If you want to know all the differences from a classic 4 lines kite and my brand new Rebel 08 5th line, you can watch this interesting video: http://www.northkites.com/public/content/e139/e161/e271/e5165/content/index_ger.html?image_actual=1.
The bar is awesome:
As you can see it's a 5 line bar with a lot of future like Iron-Heart, a chicken-loop more resistant and easy to use. Read here all the instructions.
My safety equipment.
I didn't buy only the kite with the bar, but also
the harnesses:
This is very important, because here you attach your kite!!!
Then I take also a impact vest, very useful if you have to swim a lot and also if you have to fall down from a bug height ...
Finally, the helmet:
The board
The board actually is a second hand given by an Italian friend of mine relocated in London.
As may People of you know, hurricane Bertha is coming really close to the east cost of Bermuda Island.
Today I have been to Sandy's beach to play kite-surf, because with the hurricane that is coming, the wind is perfect dangerous to play this crazy sport.
In first I want to give you some information about Bertha. Bertha actually is a small Hurricane quoted 1, so the smallest in that category. Actually is really close to Bermuda and we can feel it by the wind that today is increased too much. Actually here the wind is around 30 knots, and tomorrow can grow a little bit.
In these link Hurricane National Center you can stay updated with all the information you need for every hurricane present in the world. The web site is updated every quarter and you can also subscribe to an RSS feed.
Another thing I want to let you know is about Bermuda and Hurricanes. Usually in the other Countries like United States, the Government activates every time a procedure of evacuation when an hurricane is coming. But you cannot do this in Bermuda. So you can stay really quite here, because the houses are built in case of an hurricane 5, and also all the Public services and Companies give you all the information and all the instruments to be safe.
Actually I cannot tell you more about it, but I will send another post in the next days to keep you updated.
For the moment I can only say to you that tomorrow I will go to play another time kite-surf, and enjoy the strong wind, otherwise I will come back in Italy with a direct free flight with my kite, using the power of Bertha. 
During one of my tour around the City of Hamilton, Me and my wife we have found a really small and strange alley. Inside you can find any sort of strange shop.
I was really suggested about the paint made by a local painter here in Hamilton. Unfortunately I don't remember the name but I can show you some of them, because I was able to stole some shots with my camera.
Take a look.
Really nice, is some sort of Naïf painting but with a Bermudan touch.
I love it, maybe I will buy one and I will hang in my Office.
Hi guys and all readers of my blog. I'm really with everyone of you but unfortunately in these days I was very busy and I didn't get one minute to update my weblog.
I have receive a lot of requests about new shots from Bermuda so in this short post I will send you some updates.
Hope you will enjoy!!
Some shots from Hamilton City
Front street
The Parliament
One of the Churches
Some shots from my House
From the patio
My new Girlfriend !!
I hope you will enjoy, stay tuned I have a lot of more shots to show you!!
SSIS workflow is really amazing when you have to add some automatism in your data flow processes. But sometimes is better to make same checks before start with a really dangerous BULK operation.
One of the most noise stuff I have to do is to launch insert of new records when I receive updates from web (web services, XML data). But when I do this I'm always afraid about duplicated rows.
Ho to check if a row exist, in SSIS?
SSIS Package contains a component called lookup. Very intuitive name. So if you need to insert only some new rows in a table you can build a workflow like this:
So we have three components:
- A OLEDB Datasource that reads data from the source table
- A LookUp component that check every row, if exists in the destination table. If doesn't it redirects the rows in the error event.
- A Destination SQL that receive only the new rows, the rows that are in error in the lookup component.
Easy and automatic.
Premise: if you come from Europe you will find this post very strange. The reason is that in Europe you can take an International driving license and use it where you want.
But not in Bermuda!! If you want to take a Bike (Motorbike) or a Car you have to get the local Driving license. In addition you have to take 4 steps to drive everything. The first one is for the 50cc bike, then 100cc, then Automatic car and finally manual car.
How to do it?
First you have to go to the TCD (Transport Control Department) and get the book (for only 3 USD) and a Form for your doctor (the local one ...).
After this you have to pay around 60 USD to take the write exam on a computer, but the good thing is that if you mistake the exam you can retake it without paying anymore.
Now, at this point, you have to take the driving exam, but beware, because here is not like Europe, there aren't driving school, so you need some local that give you his bike for a while to take practice and also, the driving test.
I will let you know when I will take my.
Usually when we build a query we start the .sql file, or command in the query editor with a simple command ... CREATE PROCEDURE ... bla bla bla.
Ok but if I'm building a database from scratch is very probably that my procedure will be modified a lot of time. So every time we have to launch the command DROP PROCEDURE, or ALTER PROCEDURE.
This sounds good if you are building your object. But in case of you want to store as a BACKUP PROCEDURE some scripts in the network, is better to produce this scripts as ATOMIC and AUTOMATIC.
To accomplish this task, we can use a function really useful in SQL SERVER, IF [OBJECT] EXIST, DROP IT!
IF EXISTS (SELECT * FROM [dbo].[sysobjects]
WHERE ID = object_id(N'[schema].[procedure]') AND
OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [schema].[procedure]
GO
CREATE PROCEDURE [schema].[procedure]
AS
BEGIN
So now you can run the script as much time as you want.
If you have a SQL 2005 machine with a (x64) installation, some of the system queries have a different name, like [some_command]sys_64. So when you try to connect your powerfull SQL2005 to an old remote SQL2000, probably in x32 version, you can receive a strange error like Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO".
In many forums you can find a link to a microsoft KB that explains to you that you have to install the SP4 in the old SQL and maybe everything will done.
Usually I like to know why something doesn't run ...
So, when you execute from SQL2005 a query like
select * from sql2000.mybase.dbo.mytable
SQL Server 2005 x64 runs the following query on remote SQL2000 server:
exec [mybase]..sp_tables_info_rowset_64 N'mytable', N'dbo', NULL
So you can also try to add this stored in the Remote SQL2000 server, in the master database:
create procedure sp_tables_info_rowset_64
@table_name sysname,
@table_schema sysname = null,
@table_type nvarchar(255) = null
as
declare @Result int set @Result = 0
exec @Result = sp_tables_info_rowset @table_name, @table_schema, @table_type
It works and you don't need to run strange Package on your critical machine.
This year is a new year for me for everything, why?
New location (Bermuda), new job (IT Manager) and new technologies (no more NET dev but SQL Dev). So why don't put in my life another new interest in different certifications? I have decided to became a MCITP (Microsoft Certified IT Professional). Here you can find a detailed description of all the seminaries.
For MS SQL 2005 there are 3 ways. All the ways have the same startup. Exam 70-431 TS: Microsoft SQL Server 2005 – Implementation and Maintenance. With this exam you gain the MCTS SQL 2005. Now you can choose one of the three available profiles.
MCTIP Database Developer.
Microsoft Certified IT Professional: Database Developer certification demonstrates that you can design a secure, stable, enterprise database solution by using Microsoft SQL Server 2005.
Exams
70-441 - PRO: Designing Database Solutions by Using Microsoft SQL Server 2005
70-442 - PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
MCTIP Database Administrator.
Microsoft Certified IT Professional: Database Administrator (MCITP: Database Administrator) is the premier certification for database server administrators. This certification demonstrates that you can keep up with your enterprise business solutions 24 hours a day, 7 days a week.
Exams
70-443 - PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
70-444 - PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005
MCTIP Business Intelligence.
Microsoft Certified IT Professional: Business Intelligence Developer certification demonstrates that you can design analysis solutions, data transformations, and reports. Business intelligence developers design and implement multi-dimensional database models (logical and physical), data marts, data warehousing, data transforms, data analytics, and reporting solutions. This includes programming and customizing servers that use Multidimensional Expressions (MDX), customer transforms, and custom reporting solutions. Business intelligence developers are typically employed by medium-sized to large organizations.
Exams
70-445 - TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance
70-446 - PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005
I would like to get in first step the Database Administrator, that is the most hard to get. And in a second time I will start with the Database Developer. But if I have to honest what I love is the ETL process, so for me the dream is to get also the complete knowledge of how to build a strong Data warehouse.
Starting from now stay tuned because I will post a lot of info about SQL.
Happy Birthday to me ... 
Yep today I'm 30 so please connect to my blog, make a comment and say me HAPPY BIRTHDAY!!
This week-end in Bermuda was a long one, because yesterday there was the Bermuda Day, so one more day to stay on the Beach.
Another interesting thing is that I have started my Kite-Surf course!! So in first I want to share with you some interesting photos, not anything amazing but something to start with.
First thing I can say to you, Man finally I have found some interesting guys where I can talk and stay on the week-end. Also most of them, incredible, are IT technician like me.
There are guys from all the part of the world, for example, one from Sweden, one from England, one from South Africa and more and more ...
Let's start with some information about kite-surf in Bermuda.
Where to play
As you know, Kite-surfer are not well viewed from other tourist or Beach consumer. One of the reason I think is because Kite-surfer stole a lot of space in the beach with their instruments and kites ...
Another thing, in my opinion, because kite-surfer run very fast near the beach. But hey guys, I'm here to enjoy!!
So in Bermuda there are a lot of amazing Beaches where you can take the sun, make snorkeling, but only two for Kite-surfing. The reasons are more than one. First you need good wind direction, Second you need a safe place to land, with no obstacles, no risk to your health, Third you need the only two beaches in Bermuda where Coral are less!
Somerset Long Bay Beach - is the most famous for the Kite-Surfer, at the end of the West cost of the Island in the Sandy's Parish. Not easy to find, and this is another reason because I like this beach. For more details check the Map.
This beach is really quite, with a big place with green grass and trees, so if you want to relax after kiting, you can also take a sleep in this quite place. But not in Sunday where some People come to see the kite-surfers ...
Elbow Beach - This beach is not so far from Long bay, but is in the warwick Parish. I have never been there so I cannot give you more info about. I'm really sorry.
Last one, Official School
Hey man, Kite-surfing is not for quite people I think. Also it's a really dangerous sport if you don't know everything in the right way. So, in first, you need an official instructor and an official instrumentation to be sure that you will not injury anytime. First - keep safe!
The Official school is Kio and you can go on their web-site and search for a close Teacher to you country.
Here in Bermuda you have to call Simon, is the only official one here, and He's really cool.
Take care.
I guys finally I have some time to spent for you.
During this days I was and also I'm too busy so as you can imagine I have not time to blog.
Today I was to the Electricity Society for open my account. So if you are an emigrate you need:
- Passport Number and Passport copy
- Your landlord near you to sign the contract
- Your house contract
In 15 minute the www.belco.bm company will sign you for a new contract.
Obviously because you are a non-bermudians customer you have to deposit 150.00 BDM that they will give you back when you will stop your contract.
But don't worry about, because in Italy we have this also for Italian Citizens!!
For pay the bill you have more than one solutions, you can pay directly in the Company office, when you receive the bill (I suppose it's monthly), or you can pay in a ATM or also you can achromatized the process with your bank account or finally you can pay every time via E-banking.
Very nice.
Before starting to this fantastic Island, I have read a lot of forum, blogs and also personal experiences.
Anything was really true. I have prepared a long detailed list in excel format, with all my things inside, also Clothes, Electrical tools, Documents and more ...
I have also prepared my suitcases separating every one thing in a Plastic bag, I have divided the suitcases by things typologies (Clothes, Health ...) but when I was in the Customs ...
First - don`t be aware about Customs, they are friendly, sunniest, and in special case they are very very kind and compressively.
Second - actually in Bermuda the law about import has changed a little bit. I haven`t paid anything duties. Yes now when you come in the Island as a worker, the first time you don`t pay duties so please don`t be aware.
Finally I want to please all stupid people that write fantastic evil stories about Customs to STOP. Bermuda is a fantastic friendly place, people are very kind and also Police and Immigration employees are very compressively with stranger.
I finally can say that I haven`t had problem in the Airport and I am very happy to finally be in a place where stranger are good accepted more than in other European Countries.
I remember to you for any kind of question go directly to Bermuda Customs web site (search in my old posts), and ask everything you are in doubt.
Have a nice experience to like mine!!