In this post I want to show a couple of ways to order the data that comes into the pipeline. a number of people have asked me about this primarily because there are a number of ways to do it but also because some components in the pipeline take sorted inputs. One of the methods I show is visually easy to understand and the other is less visual but potentially more performant.
2010-06-18
15,661 reads
In the beginning of a new series, Elliott Whitlow shows us how to process your data movement in parallel, covering six different methods for doing so.
2010-06-17
12,974 reads
In this tip, I am going to show you how you can create a Data Access Layer (to store, retrieve and manage data in relational database) in ADO .NET. I will show how you can make it data provider independent, so that you don't have to re-write your data access layer if the data storage source changes and also you can reuse it in other applications that you develop.
2010-06-17
5,532 reads
Arshad Ali discusses the Initiator, Target, Message Types, Contract and Queue--all components of SQL Server Service Broker (SSBS).
2010-06-16
2,275 reads
Paging through results of data, or finding specific sets of data is something that most of us need to do. A new article from Lawrence Moore shows us how we can do this with ROW_NUMBER()
2010-06-15
15,725 reads
There are numerous databases housing the same information and it's getting quite difficult to keep everything in line. I've heard from a number of departments who want a more centralized approach to handling customer data, but I don't know where to begin. Can you steer me in the right direction?
2010-06-15
4,680 reads
The idea of this challenge is to clean up the phrase from the words identified as 'noise' words from the beginning and end of sentences.
2010-06-14
2,686 reads
Some background on sp_who2 from Jason Brimhall and a dive into the inner workings of how to find current activity on an SQL instance.
2010-06-14
13,994 reads
Tapas Pal shows you how to encrypt your SQL Server database for a pre-existing, business critical web application using Transparent Data Encryption (TDE), a new full database encryption technique introduced in SQL Server 2008.
2010-06-14
2,995 reads
This article is the beginner's guide to Default Trace. The article outlines how to query the default trace for key trace events, with a focus on DDL history.
2010-06-11 (first published: 2008-11-11)
53,913 reads
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
I have an app that has an address field on the customer and the...
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
How do I easily get the next 12 sequence values from a sequence object?
See possible answers