Abstract:

SQL Server has many features that almost no one uses or even know about , by using them it will make life much more easier, CTE (Comman Table Expression), Merge statement , Accessing WebServices form Stored Procedure, File Steam, Schemas and application roles,Sending e-mails from SQL Server

Abstract:

SQL server is next to being a great database an excellent choice for implementing BI solutions in an organization. We will cover the following topics in the session Why do I BI, how to look at data in a BI scenario this is different than data in a transactional system. What tools does SQL server has available to setup a BI environment which tools can we use to use the data in our BI cubes. And throughout this session we will build a small BI sample using adventure works database.

Abstract:

SSIS (SQL-Server Integrations services) enable us to retrieve data from multiple sources transform and perform data cleaning operation on it before we store it in our data warehouse for our BI operations. Besides being and advanced data gathering tool you can design flows and automate data gathering processes to help turn data into information for the end users. We will address the various options and scenarios for the use of SSIS as well as building a small working demo while covering this somewhat unknown tool of SQL-Server.