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 2 of 3 (24 total posts)
  • 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
  • [OT] SQLTeach: Almost Here

    I was just reviewing my calendar for the next several weeks and noticed that the Toronto SQLTeach conference is now only a few weeks away.  This conference includes quite a few interesting SQL Server-related sessions, on topics ranging from best practices, to performance, to some of the new SQL Server 2008 features. I fully expect ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 24, 2008
  • Running sums yet again: SQLCLR saves the day!

    Back again!  Fourth post for the month of February, making this my best posting month in, well, months.  Expect this trend to continue.After yesterday's post on running sums and the evils of cursors, Jamie Thompson came up with a faster solution than the curser I posted.  Alas, Jamie's solution uses an undocumented form ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 12, 2006
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement