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 » SQLCLR   (RSS)
Showing page 2 of 3 (26 total posts)
  • 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
  • Webcast - September 28, 2010 - Next-Level SQLCLR: Parallel Processing and Bulk Load

    Tomorrow at 12:00 p.m. EDT (4:00 p.m. GMT) I'll be doing a webcast for the PASS Application Development Virtual Chapter.Next-Level SQLCLR: Parallel Processing and Bulk LoadThe power of SQLCLR as a performance tool has been well-documented at this point; certain queries, when re-written the right way using SQLCLR components, can run an order of ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on September 27, 2010
  • TechEd 2010 Thanks and Demos

    Thank you to everyone who attended my three sessions at this year's TechEd show in New Orleans. I had a great time presenting and answering the really great questions posed by attendees. My sessions were: DAT317 T-SQL Power! The OVER Clause: Your Key to No-Sweat Problem SolvingHave you ever stared at a convoluted requirement, unsure of where to ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 10, 2010
  • Visual Studio 2010 and SQLCLR: Some Good, Some Bad

    This past week I've been trying out Visual Studio 2010 for SQLCLR development. Verdict: A couple of nice things, a couple not so nice. In the interest of keeping things somewhat positive around here, we'll start with the good stuff:Pre-deployment and post-deployment scripts are built in. This is great, especially if you're working with features ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on May 2, 2010
  • T-SQL Tuesday #001: Exploring "Fuzzy" Interval Islands Using SQLCLR

    When working with time intervals, we often want to ask a couple of basic questions: Which time periods are not covered by our intervals? These are known as ''gaps''. What are the time ranges that we are fully covering? These are known as ''islands''. If you're unfamiliar with ''gaps'' and ''islands'' I highly recommend reading some ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on December 8, 2009
  • Full Outline for my PASS Pre-Con: SQLCLR From Beginner to Expert

    Since the announcement of my SQLCLR pre-conference seminar at this November's PASS conference I have received a few e-mails asking for more detail about what I will be covering. In addition to the Q&A I did with PASS, I thought it might be helpful if I post the entire schedule for the day (see below). The seminar's goal is to literally move ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on August 17, 2009
  • SQLCLR String Splitting Part 2: Even Faster, Even More Scalable

    Two days ago, after posting what I thought was a pretty solid SQLCLR string splitting method, I received a comment telling me about a big thread on SQLServerCentral dedicated to the question of how best to split strings. So I jumped in, and went back and forth, and back and forth, and back... and forth... Many, many messages and several ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 28, 2009
  • Faster, More Scalable SQLCLR String Splitting

    It seems like every couple of months we see yet another post on SQLCLR string splitting routines. Many bloggers, I suppose, are still struggling, even three years later, to find that ''perfect'' use case for SQLCLR. Is string splitting it? Probably not. And with SQL Server 2008 table-valued parameters now available, SQLCLR string splitting has ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 26, 2009
  • Speaking Season About to Begin: MCM, Roadshow, PASS, and SQLCLR Precon at DevTeach

    Fall is now in full swing, and after a relatively quiet several months my speaking schedule is about to jump into fairly-packed mode.  Following is a list of where I'll be headed over the next couple of months: Next week I'm really excited to be teaching a day of the Microsoft Certified Master: Microsoft SQL server 2008 program's beta ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 21, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement