Thursday 17 November 2011

Day 13

-http://www.third-time.com website developement begins
-SQL code to change a column data type
 ALTER TABLE ???????
 ALTER COLUMN DATETIME NOT NULL
-http://msdn.microsoft.com/en-us/library/ms139892.aspx (Intergration Services Tasks)
-In Integration Services, a source is the data flow component that makes data from different external data sources available to the other components in the data flow.
-The capabilities of transformations vary broadly. Transformations can perform tasks such as updating, summarizing, cleaning, merging, and distributing data.
-A destination is the data flow component that writes the data from a data flow to a specific data store, or creates an in-memory dataset.
-Sources have outputs, destinations have inputs, and transformations have both inputs and outputs. Additionally, many data flow components can be configured to use an error output.

Inputs

Destinations and transformations have inputs. An input contains one or more input columns, which can refer to external columns if the data flow component has been configured to use them. Inputs can be configured to monitor and control the flow of data: for example, you can specify if the component should fail in response to an error, ignore errors, or redirect error rows to the error output. You can also assign a description to the input or update the input name. In SSIS Designer, inputs are configured by using the Advanced Editor dialog box.

Outputs

Sources and transformations always have outputs. An output contains one or more output columns, which can refer to external columns if the data flow component has been configured to use them. Outputs can be configured to provide information useful to downstream processing of the data. For example, you can indicate whether the output is sorted. You can also provide a description for the output, or update the output name. In SSIS Designer, outputs are configured by using the Advanced Editor dialog box.

Error Outputs

Sources, destinations, and transformations can include error outputs. You can specify how the data flow component responds to errors in each input or column by using the Configure Error Output dialog box. If an error or data truncation occurs at run time and the data flow component is configured to redirect rows, the data rows with the error are sent to the error output. By default, an error output contains the output columns and two error columns: ErrorCode and ErrorColumn. The output columns contain the data from the row that failed, ErrorCode provides the error code, and ErrorColumn identifies the failing column.

Tuesday 15 November 2011

Day 12

-Setting the formatting options of a Value correctly
-Highly recommended to read (The Microsoft Data Warehouse Toolkit 'Wiley')
-Started using SSIS
-Extract-Transfer-Load (ETL)
-Good tutorials http://www.youtube.com/my_subscriptions?feature=mhee&s=J77DAMeSPrNDXnTWR8xn_uAaeZ4SG4T8FoEhai2Ui2c
http://www.youtube.com/my_subscriptions?feature=mhee&s=J77DAMeSPrNDXnTWR8xn_inRZd7ZMnkGslzywAWBhtU
-Imported Excel spreadsheets into MS SQL (Created Tables)
-Setting up DNS Server
http://www.elmajdal.net/win2k8/setting_up_your_first_domain_controller_with_windows_server_2008.aspx
-SSIS info
http://msdn.microsoft.com/en-us/library/ms141026.aspx

Component Interfaces with Integration Services
http://i.msdn.microsoft.com/dynimg/IC39990.gif

Day 9

-Understanding of Clustered Servers
-Data Mining (finding the jewel within data) something that a company can use to help push them forward!
-Data warehousing
-The ways in which a Data Warehouse stores the data (groupings)
-Union
-Union All
-Completed my first report
-Created first subscription using report manager
-Dundas.com (good for SSRS plugins) Charts,Graphs etc
-http://pal.codeplex.com/releases/view/43096
-Virus/Malware removal http://www.bleepingcomputer.com/combofix/how-to-use-combofix
-Found really helpfull tutorial videos on SSRS by http://www.youtube.com/user/PCTeachME
- Shade alternating rows in a SQL Server Reporting Services report
   = IIf(RowNumber(Nothing) Mod 2 = 0, "Silver", "Transparent")
-Started looking into SSIS

Day 5

-Setup my workstation
-Installed MS SQL R2 Enterprise
 Includes ( Visual Studio 2008)
-Got sent my first bit of data to play with in SSRS

Day 3

-Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services (3 day course)
-Learnt the basics of setting up Ms SQL Managment Studio 2008 RS
-Connecting to a database
-Learnt the basics of BIDS (Microsoft Visual Studio 2008)
-Created basic reports using the AdventureWorks database
-Parameters
-Expersions
-Datasets
-Backing up keys
-Stored Precedures
-Using Report Manager
-Using Report Builder
-How reporting services can be used within Sharepoint
-Relised why companies use BI specialists
-

Day 1

Here we go!