Came across Connected Information Security Group's Blog. There are 2 new tools to help diagnose code for security vulnerabilities; CAT.NET and Anti-XSS both in early review releases.
I am more interested in testing CAT.NET for testing within Visual Studio.
Check it out for your applications.
http://blogs.msdn.com/cisg/archive/2008/12/15/anti-xss-3-0-beta-and-cat-net-community-technology-preview-now-live.aspx
Sometimes I just want to run a SSIS package without creating a job in SQL Server job.
Dangerous?? Well not really just sometimes, especially in production, unwise.
Nonetheless here is my raw example for sharing with others. Make sure you add the reference to Microsoft.SQLServer.ManagedDTS for DTS.Runtime.
using System;
using System.Data;
using System.Data.SqlClient;
using Microsoft.SqlServer.Dts.Runtime;
namespace LaunchSSISPackageAgent
{
class Program
{
static void Main(string[] args)
{
int returnCode;
//returnCode = RunSSISPackage( "myServer", ".", "mypackage" );
}
// Always mention sources of ideas...
// http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.application.existsonsqlserver(SQL.90).aspx
public static int RunSSISPackage (string packageServer, string packagePath, string packageName)
{
Package myPackage;
Application integrationServices = new Application();
Int32 ExecuteCode = 0;
// Combine path and file name.
// Package is stored in MSDB.
// Combine logical path and package name.
// Verify that the package was saved.
//Boolean packageExists = app.ExistsOnSqlServer(packageName, packageServer, null, null);
//Console.WriteLine("Package exists? {0}", packageExists);
if (integrationServices.ExistsOnSqlServer(packageName, packageServer, null, null))
{
myPackage = integrationServices.LoadFromSqlServer(packageName, packageServer, null, null, null);
DateTime pkgCreation = myPackage.CreationDate;
Console.WriteLine("Creation Date = {0}", pkgCreation);
ExecuteCode = (Int32) myPackage.Execute();
Console.WriteLine("Package Executed.. ");
Console.WriteLine(ExecuteCode);
Console.Read();
return ExecuteCode;
}
else
{
throw new ApplicationException("Invalid package name or location: " + packagePath);
}
}
}
Microsoft Press Release on SQL Server 2008
I am very excited about SQL Server 2008!! The product provides a lot of new features (i.e. spatial and filestream) as well many performance improvements.
Want to learn more? Check out these resources:
