THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » C#   (RSS)
  • Running SSIS packages from C#

    Most of the developers and DBAs know about two ways of deploying packages: You can deploy them to database server and run them using SQL Server Agent job or you can deploy the packages to file system and run them using dtexec.exe utility. Both approaches have their pros and cons. However I would like to show you that there is a third way (sort of) ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on April 9, 2012
  • Verify a connection before using it [SSIS]

    Just recently I've inherited some SSIS packages that were in dire need of fixing however, as is often the case, most of my battles were with connection string configurations. It always baffles me when I see packages that don't log information that would be useful for debugging purposes and when its me that has to debug those packages I tend to ...
    Posted to Jamie Thomson (Weblog) by jamiet on October 25, 2011
  • Performance impact: Try/Catch blocks in SQLCLR – a follow up

    My previous post showed a simple test that appears to suggest that you may experience significant performance degradation if multiple users are calling the same SQLCLR function at the same time and they are all catching a lot of exceptions.   However, it’s not clear whether that behavior is limited to SQLCLR or applies to .NET in general. ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on July 7, 2011
  • Performance impact: too many try/catch blocks may be harmful in SQLCLR

    If you have many try/catch blocks in your .NET code and your code execution actually passes through them, you should expect a performance hit. That’s intuitive and no surprise.   What is surprising is the extent to which you may experience severe performance degradation when multiple users are executing a piece of SQLCLR code (e.g. calling ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on July 6, 2011
  • Lock variables in Script Task using C# [SSIS]

    If you have ever written code to lock variables inside a SSIS Script Task or Script Component then you will probably have written some VB.Net code that looks something like this: Public Sub Main() Dim vars As Variables Dim fireAgain As Boolean = True Dts.VariableDispenser.LockOneForRead(''VarName'', vars) 'Do ...
    Posted to Jamie Thomson (Weblog) by jamiet on July 29, 2010
  • Encrypt it in .NET/Decrypt it on SQL Server?

    A common question on the newsgroups is ''how do you encrypt data in a .NET [or other] client application and then decrypt it on SQL Server [or vice versa]?'' I actually ran down my list of answers to someone who asked this in the newsgroups a few weeks ago. I won’t get into the details, but the answers all pretty much say the same thing -- ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on January 29, 2010
  • Free e-Book and Magazine

    A pair of Canadian Server MVPs have led the charge to create a free e-Book for developers called (what else?) ''Developers, Developers, Developers, Developers''.  This book features development tricks, tips and insights from 17 of the best developers in the game.  Download it now at ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on October 30, 2009
  • Let's Encrypt a BLOB

    SQL Server 2008 has an impressive array of encryption features -- cell-level symmetric and asymmetric encryption, key management, EKM, TDE, and more. But they do have some limitations. Symmetric encryption functions, for instance, can only encrypt slightly less than 8,000 bytes of data (the additional information like random IV and ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on April 8, 2009
  • SSIS Script Task In SQL Server 2008 Can Use VB Or C#

    Where do I send a thank you letter? Finally we are allowed to use C# in the SQL Server Integration Services Script Task. I always wondered why SQL Server 2005 only uses VB and not C#, you can use C# in the SQLCLR but not in a Script Task. It turns out that SSIS in SQL Server 2005 uses VSA (Visual Studio for Applications) but SQL Server 2008 will ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on July 4, 2007
  • Folder Info

    Although not a SQL Server post, I thought this would be helpful for anyone... In an attempt to clean up my laptop, I have been archiving old projects, setup files, etc., off to a file server. Alas, some directories have a multitude of subdirectories, and trying to figure out how much space each takes up is cumbersome at best. So, I decided to ...
    Posted to Peter DeBetta's SQL Programming Blog (Weblog) by Peter DeBetta on January 30, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement