Posts
  • Sylvia's SQL Center

    Reviewing Security Vulnerabilities

    • 0 Comments
    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...
  • Sylvia's SQL Center

    SSIS Lookup Transform Example

    • 1 Comments
    Matt Mason has a data flow package example that looks pretty complete. Gotta check it out. http://blogs.msdn.com/mattm/archive/2009/01/02/api-sample-data-conversion.aspx
  • Sylvia's SQL Center

    Executing a SQL Server 2008 SSIS Package

    • 1 Comments
    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...
  • Sylvia's SQL Center

    SQL Server 2008 Dependencies..

    • 1 Comments
    The PSS SQL Server Engineers have SQL Server 2008 Installation explanation. http://blogs.msdn.com/psssql/archive/2008/08/11/sql-server-2008-visual-studio-2008-sp1-and-net-framework-3-5-sp1-explained.aspx
  • Sylvia's SQL Center

    SQL Server 2008 is RTM!!

    • 0 Comments
    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: SQL Server...
Page 1 of 1 (5 items)