September 2008 Entries
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,...
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...
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...
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...
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
...