SQL Server
There are 4 entries for the tag
SQL Server
I was doing a data conversion that involved importing data from a flat-file source into SQL Server. I fired up SSIS and created the Data Flow tasks that would move the data into the SQL Server tables. The problem was, the longer fields (i.e. a “Notes” column) were all being truncated no matter what data type I made the destination field. So I created a Data Conversion task to sit between the Flat-File data source and the SQL Server Destination. After I had tried every conceivable destination data...
My favorite SQL Server command is: STUFF. What an awesome name for a command. During a recent data conversion I had to combine many duplicate part records in the Part table, but retain the values from all of the duplicate part rows. I used STUFF to collapse the rows: Select Distinct [CustomerPartNo] ,[CustomerNo] ,(Stuff((Select ', ' + CustomerDescription From [PARTS] T2 Where T2.[CustomerPartNo] = T1.[CustomerPartNo] and T2.[CustomerNo] = T2.[CustomerNo] FOR XML PATH('')),1,2,'')) From [PARTS] T1...
Blogging so that I can find these again when I have time to watch them...:) Ø Introduction to Microsoft Dynamics CRM, Susan Sauls Ø Intro to SQL Server Data Services, Soumitra Sengupta Ø The Spy Who Hacked Me! , Alex Smolen, Rudolph Araujo Ø How Microsoft SQL Server Helps You to Lower Your Cost of Storage, Torsten Grabs Ø Microsoft System Centre Virtual Machine Manager 2008: Overview, Edwin Yeun Ø A Hackers Diary: How I Can Hack Your Vulnerable Services and How You Can Stop Me, Marcus Murray Ø Advances...
I took Jeff McWherter's suggestion to play around with SubText, and have successfully gotten SubText upgraded and running in VS 2008, .NET 3.5. My environment is the "Visual Studio® Team System 2008 Team Foundation Server and Team Suite VPC Image (Trial)" Virtual PC from Microsoft. Here are the steps that I followed: 1. Download and unzip the latest source code from SourceForge 2. Open Visual Studio 2008 Team Edition and Create a new Team Project (File - New - Team Project). I selected the MSF For...