Executing SSIS Packages
From Article:
This article presents three different methods of executing all packages in a folder:
- SSIS control package
- Stored procedure
- DOS batch file
Top and Order By Combination - SQL Server knowledge center
"View object is a table expression (in sql server 2005 and above); and if you specify ORDER BY clause, the result would not be a table expression but ANSI SQL cursor statement. SQL Server 2005 and later version put View objects as pure table expression so that they will ignore TOP…ORDER BY combination in View."
Microsoft Virtual Labs - MSDN Virtual Lab: Application Validation through Unit Testing
Overview:
After completing this lab you'll be better able to:
- Generate unit tests from existing code
- Author unit tests based off pre-existing assemblies
- Use data to drive the unit tests
- View the test results
- Enable code coverage and examine how well the unit tests are exercising the assembly under test
Microsoft Virtual Labs - MSDN Virtual Lab: Building an Application with ASP.NET MVC
Overview:
After completing this lab you'll be better able to:
- Create a controller
- Display data from a model
- Generate links
- Handle HTML forms
Subscribe to:
Posts (Atom)