THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » C#   (RSS)
Showing page 1 of 2 (12 total posts)
  • “Where Can I Learn Enough C# to Use Biml?”

    An attendee at today’s Biml 103 webinar (Automating SSIS Design Patterns with Biml – this link takes you to register to view the recording) asked a very good question in a follow-up email: “Where can I learn enough C# to use Biml?” The answer is the C# Primer at! Read, then test your knowledge! How cool is that? Create a ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 13, 2016
  • Seeing Sharply

    My technology career began as a curiosity in 1975. I was 11 years old and living next door to an elderly couple. Their son returned from an engineering career in the Air Force and began tinkering with a microprocessor kit. I was curious and he taught me Motorola 6800 machine language. After that, 40 years ago at the time of this writing, he taught ...
    Posted to Andy Leonard (Weblog) by andyleonard on October 5, 2015
  • 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 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
1 2 Next >
Privacy Statement