24 hours of PASS.. Get better at SQL

If you missed a webinar, want to replay your favorites, or wish to share this training with colleagues, now is your chance! The webinar recordings are ready for viewing, learning, and sharing. This event and session recordings are brought to you by the generous support of our presenting sponsors. View their sessions below:SQL Server on… Continue reading 24 hours of PASS.. Get better at SQL

The fastest way to split a string using CLR

The original post appeared here: http://sqlblog.com/blogs/adam_machanic/archive/2009/04/28/sqlclr-string-splitting-part-2-even-faster-even-more-scalable.aspx Please visit the original website for more discussion, this is for reference purpose only.   using System; using System.Collections; using System.Data; using System.Data.SqlClient; using System.Data.SqlTypes; using Microsoft.SqlServer.Server; public partial class UserDefinedFunctions { [Microsoft.SqlServer.Server.SqlFunction( FillRowMethodName = “FillRow_Multi”, TableDefinition = “item nvarchar(4000)” ) ] public static IEnumerator SplitString_Multi( [SqlFacet(MaxSize = -1)]… Continue reading The fastest way to split a string using CLR

learn LINQ in 5 minutes

Translating SQL to LINQ can prove difficult for new and experienced C# developers. This post contains common SQL queries written in LINQ. I hope it’ll serve as a reference when writing LINQ queries. I’ll use a MS SQL database and Entity Framework for my examples. However, these examples can be extracted to other ORMs and… Continue reading learn LINQ in 5 minutes