The sample demos that I have listed below illustrate some of my database development skills:
I make extensive use of variables, expressions, and .NET scripting in an SSIS 2008 package that performs a backup of user data on a Windows file system.
- SSIS package variables and expressions.
- .NET scripting that interacts with the file system.
- Use of the Foreach Loop container to execute a File System Task for a collection of directories.
- Execution of SSIS packages in external .NET applications.
Using the express editions of the SQL Server 2008 database engine and reports server along with Microsoft Visual Web Developer 2008 Express Edition and the Microsoft Report Viewer 2008 Redistributable Package—all free software downloads—I demonstrate how one can develop a complete reporting application.
- Reports development using SQL Server 2008 Reporting Services (SSRS).
- Utilizing the Report Viewer control in an ASP.NET 3.5 web application.
This demonstration shows how one can use SQL Server 2008 Integration Services, Analysis Services, and Reporting Services to implement a data mining solution.
- ETL development with SQL Server 2008 Integration Services (SSIS).
- Data mining development and DMX programming with SQL Server 2008 Analysis Services (SSAS).
- Reports development with SQL Server 2008 Reporting Services (SSRS).
Using a hypothetical CPU-intensive string parsing operation, I illustrate the performance benefits that SQL Server 2008 CLR assemblies offer over T-SQL-based solutions.
- SQL Server 2008 CLR development in C# 2008.
- Performance analysis and tuning.
This case study demonstrates my favorite T-SQL enhancements that appeared with SQL Server 2005: TRY...CATCH structured error handling, the OUTPUT clause, recursive CTEs, and the ROW_NUMBER() function.
- T-SQL enhancements for SQL Server 2005.
- Analysis of business problems and specification of technical requirements.