Tags
Articles in DTS/SSIS
Manipulating and Massaging Data in Excel
Today’s author: Chad Rothschiller, a program manager on the Excel team. Chad is going to discuss using formulas to 'clean up' data in Excel. Overview Excel is a great tool to use when you need to...
From : Microsoft Excel 2007 (nee Excel 12)
2007 Nov 12
Readability
Readability Stats: Word Count: 2941; Sentence Count: 106; Grade Level: 11.1
Use LINQ with WPF : Styles and DataTemplates in code
Using Windows Presentation Foundation (WPF) and LINQ is easy in code. We'll create a query and display it in a WPF ListBox Using XAML is harder: the ObjectDataProvider class works with non-anonymous t...
From : Calvin Hsias WebLog
2007 Nov 12
Readability
Readability Stats: Word Count: 2365; Sentence Count: 191; Grade Level: K
Datareader to Datatable Convertor
On forum today I saw an interesting post where I had advised the ORPO that a datareader could be binded to combobox, having worked on ASP.NET for the past months now its easier than falling over as you can use...
From : VB & .NET Blogs @ vbCity.com
2007 Oct 17
Readability
Readability Stats: Word Count: 534; Sentence Count: 68; Grade Level: 9.3
Data Transformation pattern
Here's an interesting and informative article on implementation of a Transformation Interface that can serve as an intermediate layer between an application and a data store. This is particularly useful for ou...
From : A BULLs view of LIFE and TECHNOLOGY
2006 Sep 08
Readability
Readability Stats: Word Count: 53; Sentence Count: 4; Grade Level: 11.2
Enhancing TableAdapters
I've been playing around and researching different ways to enhance TableAdapters when more custom functionality is needed. If you're not familiar with TableAdapters, they act as the glue between ...
From : Dan Wahlins WebLog
2006 Aug 31
Readability
Readability Stats: Word Count: 654; Sentence Count: 44; Grade Level: 6.3
Growing Number of Object Attributes – Part II
st1\:*{behavior:url(#ieooui) } Overview Problem Presented A few weeks ago, I posted a blog similarly titled, Growing Number of Object Attributes in Relational Databases. ...
From : Eugene Asahara : C#/SQL Server Code
2006 Jul 03
Readability
Readability Stats: Word Count: 7617; Sentence Count: 487; Grade Level: 8.1
SCL Custom SSIS Task
I recently returned from a two-week trip, the main event being the delivery of a full-week “BI ramp-up” to a group of MCS consultants. One recurring topic throughout the workshop and adjacent customer engageme...
From : Eugene Asahara : C#/SQL Server Code
2006 Jun 26
Readability
Readability Stats: Word Count: 2345; Sentence Count: 120; Grade Level: 10.9
Visual Studio for Data
I know I’m way late on this one, but it’s a great one, and that’s the announcement of Visual Studio Team Edition for Database Professionals. One of the coolest things about Microsoft is seeing all the interes...
From : Dan Fernandezs Blog
2006 Jun 08
Readability
Readability Stats: Word Count: 282; Sentence Count: 10; Grade Level: 11.1
KPI Cause and Effect Visio Graph
A couple of weeks ago I posted a blog on an idea I have for a graph that can potentially be mined out of an Analysis Services 2005 Unified Dimensional Model (UDM). This graph consists of relationships between ...
From : Eugene Asahara : C#/SQL Server Code
2006 Mar 12
Readability
Readability Stats: Word Count: 4134; Sentence Count: 324; Grade Level: 6.3
Favorite New Features of SSIS
I have to say it, I love the new SQL Server 2005 Integration Services (SSIS). Wow. There is some really awesome stuff in there that really just blow me away. There are so many new things in SSIS that I ju...
From : ryanfarley on C#
2006 Jan 13
Readability
Readability Stats: Word Count: 471; Sentence Count: 30; Grade Level: 6.8
Passing a DataSet to a SQLCLR Stored Procedure
Is it possible to pass a DataSet to SQL and process the data in a SQLCLR stored procedure? This is the question I set out to answer. The .NET Framework 2.0 adds some features to the DataSet that make this sc...
From : Jeff Papiez
2005 Sep 26
Readability
Readability Stats: Word Count: 868; Sentence Count: 162; Grade Level: 6.4
HttpContext.Cache Viewer (With DataSet Support)
Aw, the HttpContext.Cache. Most of the items I place in the Cache are named with GUID's so it's not very helpful to loop through and print out the Cache Item Name. I've built this handy ASPX page that gives a ...
From : Scott Cate .net Knowledge Base and Weblog
2004 Feb 05
Readability
Readability Stats: Word Count: 1291; Sentence Count: 210; Grade Level: 5.5
