MSBI Tutor

The update statistics task updates information about the distribution of key values for one or more statistics groups (collections) in the specified table or indexed view. By using the update statistics task, a package can update statistics for a single database or multiple databases. If the task updates only the statistics in a single database, you can choose the views or the tables whose statistics the task updates. You can configure the update to update all statistics, column statistics only, or index statistics only. Step 1: Drag and drop update statistics task and edit it Step 2: Give a new connection as update statistics task Step 3: Select database as AdventureWorks Step 3: Click on view T-SQL Step 4: Select update mode as all existing statistics Step 5: Execute a task

The shrink database task reduces the size of sql server database data and log files. By using the shrink database task, a package can shrink files for a single database or multiple databases. Shrinking data files recovers space by moving pages of data from the end of the file to unoccupied space closer to the front of the file. When enough free space is created at the end of the file, data pages at end of the file can deal located and returned to the file system. Step 1: Drag and drop shrink database task and edit it Step 2: Give a new connection as shrink database task Step 3: Select a database as adventureWorks Step 3: Give shrink database as 50 MB Step 4: Click on view T-SQL Step 5: Execute a task

The reorganize index task reorganizes indexes in sql server database tables and views. By using the reorganize index task, a package can reorganize indexes in a single database or multiple databases. If the task reorganizes only the indexes in a single database, you can choose the views or the tables whose indexes the task reorganizes. The reorganize index task also includes an option to compact large object data.  Large object data is data with the image, text, ntext, varchar(max), nvarchar(max), varbinary(max), or xml data type. Step 1: Drag and drop reorganize index task and edit it Step 2: Give a new connection as reorganize index task Step 3: In databases to select a database as AdventureWorks Step 4: In selection to select a view as HumanResources.vEmployeeDepartment Step 5: Execute a task

The rebuild index task rebuilds indexes in sql server database tables and views. By using the rebuild index task, a package can rebuild indexes in a single database or multiple databases. If the task rebuilds only the indexes in a single database, you can choose the views and tables whose indexes the task rebuilds. Step 1: Drag and drop rebuild index task and edit it. Step 2: Give new connection as rebuild index task Step 3: Click on databases and select one database as AdventureWorks Step 4: In selections to select a table as dbo.singlemales Step 5: Execute a task

The notify operator task sends notification messages to sql server agent operators. A sql server agent operator is an alias for a person or group that can receive electronic notifications. Notify operator task works with sql server agent  operator.  Server agent operators are persons or groups who receive electronic notifications. So if you want to inform person/group with email, you can define operators in sql server agent. Step 1: Open ssms, connect to database engine. Step 2:  Under management, double click on database mail. Step 3: In the select configuration task, choose manage database mail accounts and profiles. Click next Step 4: In the manage profiles and accounts step, choose create a new account option, and click next Step 5: In the new account step, enter an account name. Then enter e-mail address with a smtp account,display name, reply e-mail and smtp server name.in smtp authentication, choose basic authentication, ent

The maintenance cleanup task removes files related to maintenance plans, including database backup files and reports created by maintenance plans.  Step 1: Drag and drop maintenance cleanup task and edit it Step 2: Give a new connection as Maintenance Cleanup Task Step 3: Select a delete file from the pc Step 4: Click on view T-SQL Step 5: Execute a task