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 » SQLCLR   (RSS)
Showing page 1 of 3 (24 total posts)
  • SQLRally Nordic and SQLRally Amsterdam: Wrap Up and Demos

    First and foremost: Huge thanks, and huge apologies, to everyone who attended my sessions at these events. I promised to post materials last week, and there is no good excuse for tardiness. My dog did not eat my computer. I don't have a dog. And if I did, she would far prefer a nice rib eye to a hard chunk of plastic. Now, on to the purpose of ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on November 11, 2013
  • Query Performance Sessions in Stockholm and Amsterdam

    As previously mentioned, I'll be delivering my full-day ''No More Guessing'' performance troubleshooting seminar at both the Stockholm and Amsterdam SQLRally events. In addition to the seminar, I'll be doing two breakout sessions at each event. It's going to be a busy week! But luckily for me, I'm doing the same things in each ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 4, 2013
  • TechEd 2013: Demos for "Data, Faster: Microsoft SQL Server Performance Techniques with SQLCLR"

    Today at TechEd in New Orleans I delivered a breakout session entitled ''Data, Faster: Microsoft SQL Server Performance Techniques with SQLCLR.'' This session covered a number of techniques for using SQLCLR as a query tuning tool, especially for big, ugly, and heavily analytical queries. Thank you so much for all who attended and took the time ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 4, 2013
  • SQLCLR Performance Session at TechEd US

    I am super-excited to visit New Orleans next month for Microsoft TechEd; it will be my sixth time speaking at the show. My session takes an in-depth look at some of the techniques I've developed for using SQLCLR modules -- and some of the great performance gains I've been able to achieve. Hope to see you in NOLA! If you're not attending the ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on May 8, 2013
  • CloudSeeder: CLR Stored Procedures For Creating CPU Pressure

    Sometimes, in the interest of testing various scenarios that your server might encounter, it's useful to be able to quickly simulate some condition or another. I/O, memory, CPU pressure, and so on. This latter one is something I've been playing with a lot recently. CPU pressure in SQL Server creates all sorts of interesting side-effects, such as ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 23, 2012
  • 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
  • Performance, Discounts, and an Excuse to Visit New York City

    A couple of weeks ago I announced a two-day advanced performance seminar in New York City, which will be delivered in July. This seminar will cover SQLCLR and parallelism techniques to help you take performance well beyond the levels that typical tuning exercises yield. Check out the links for more details, including a full outline. Thanks to the ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 2, 2011
  • Two Days of Advanced Performance Techniques - July 14-15, New York City

    I am pleased to announce that I will be delivering two days of training in New York City, July 14 and 15. This seminar focuses on achieving ''next-level'' performance--going beyond that which you can gain via normal tuning methodologies. The vehicles for this performance improvement are two technologies that I've been pushing on this blog and in ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on May 18, 2011
  • QueryParallelizer Beta 1

    QueryParallelizer is a .NET component designed to assist with parallel processing and ETL of SQL Server-based data. It can be used either hosted in the SQL Server process as a SQLCLR module, or in an external .NET application. Full documentation forthcoming.
    Posted to Beta Projects (FileGallery) by adam machanic on September 28, 2010
1 2 3 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement