|
|
|
|
Adam Machanic, Boston-based independent database consultant, writer, and speaker, shares his experiences with programming, performance tuning, and optimizing SQL Server 2000, 2005, and 2008, in conjunction with related technologies such as .NET.
Browse by Tags
All Tags » SQLCLR (RSS)
-
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 Read More...
|
-
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 Read More...
|
-
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 Load The power of SQLCLR as a performance tool has been well-documented at this point; Read More...
|
-
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 Read More...
|
-
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 Read More...
|
-
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 Read More...
|
-
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 Read More...
|
-
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 Read More...
|
-
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. Read More...
|
-
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 Read More...
|
-
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, Read More...
|
-
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 Read More...
|
-
I spoke at the Beantown .NET user group meeting tonight, on the topic of SQLCLR in SQL Server 2005. One of the questions that came up during the UDT part of the talk was whether static properties are supported. Unfortunately, I had no answer at the time--it's Read More...
|
-
Widely acknowledged SQL Server expert Kimberly Tripp has weighed in on SQL Server 2005's CLR integration in her latest blog post . Tripp presents a fairly balanced reaction to the new technology, and stresses a message I've been trying to hit home recently: Read More...
|
-
More fun CLR conversation , this time from SQL advocate Joe Celko. Surprise, surprise, Celko is not a big fan of CLR integration. Yet he mentions the SQL/PSM standard as a better alternative, even though it has the same issues he mentions. But it's open-source Read More...
|
|
|
|
|
|