2009年12月_wyvern110

12月

转载如何将Assembly中的DLL拿出来？

当机器上安装一些程序后，Assembly中的DLL会变得越来越丰富。拿个常见问题来说明。安装ReportViewer后其中会出现以下DLL。 Microsoft.ReportViewer.ProcessingObjectModel.dll Microsoft.ReportViewer.WinForms.dl

2009-12-29 11:55:00 464

转载 CreationName for SSIS 2008 and adding components programmatically

We start with a very simple snippet for adding a component: // Add the Data Flow Task package.Executables.Add("STOCK:PipelineTask");// Get the task host wrapper, and the Data Flow task Tas

2009-12-28 21:56:00 900

转载 CreationName for SSIS 2005 and adding components programmatically

We start with a very simple snippet for adding a component: // Add the Data Flow Task package.Executables.Add("STOCK:PipelineTask");// Get the task host wrapper, and the Data Flow task Tas

2009-12-28 21:49:00 561

转载 Twenty tips to write a good stored procedure

The writing of stored procedures is a very common task in todays database world. Not only by database developers, but also application developers are writing the procedures. DBAs also need to write p

2009-12-28 13:43:00 440

Techfocus SQL Server 2008 Migration: Evaluate the Value of a SQL Server Upgrade

To get a handle on which SQL Server versions are available, first you need to understand some nomenclature semantics. SQL Server 2008, which shipped in August 2008, is now into Service Pack 1 (SP1)with Cumulative Update (CU) 4. SQL Server 11-officially named SQL Server 2008 R2-is due out in the first half of 2010. The next step is to consider your reasons for an upgrade. Different industries will have different motivations for migrating to the next version of SQL Server. These reasons can be grouped into the following categories: Compelling new features Hardware improvements Maintaining competitiveness Cost savings Support and community involvement This whitepaper will discuss each of these reasons to help you decide if migrating is for you.

2009-12-28