Taming Trees: B-Trees
Learn how to build a B-tree similar to those used by databases to implement indexes.
2008-06-25
3,117 reads
Articles
2008-06-25
45 reads
2008-06-25
20 reads
2008-06-25
42 reads
Exporting and Versioning Lookup Data: A Real-World Use of the CLR
The CLR has not been well-received and most people use it for Regular Expressions and string functions. Here is an example that goes beyond trivial uses.
2008-06-24
5,674 reads
Parameterizing Number of “Look Back” Periods with the MDX LastPeriods() Function, Part I
Parameterization of MDX functions is one of those things that cannot be delivered solely via graphical MDX Editor – but then, you really didn’t think that you could avoid actually touching MDX at all, did you? BI Architect Bill Pearson demonstrates a way to parameterize the highly useful LastPeriods() function.
2008-06-24
1,399 reads
SQL Server Disasters with Preventive Measures
Have you seen disasters in your environment? I would bet you have at some point. Let's see if our top 13 disasters matches your experiences.
2008-06-24
3,790 reads
T-SQL Data Processing
This article from new author Peter Kierstead shows us how to implement your own "fuzzy" dedup/merge logic without resorting to RBAR in T-SQL.
2008-06-23
8,009 reads
Execute SQL statements in Integration Services
This tutorial walks you through the process of adding SQL statements to your SSIS packages and bundling them into logical units of work if necessary.
2008-06-23
4,026 reads
Transparent Data Encryption in SQL Server 2008
This article describes how the Transparent Data Encryption feature in SQL Server 2008 can be used to secure your databases
2008-06-23
2,364 reads
Blogs
The Feedback Multiplier: How Leaders Can Turn Input into Innovation
By Chris Yates
In every organization there is a hidden currency more valuable than capital, more enduring...
SQL Saturday Boston Slides and Code
By Steve Jones
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...
Scaling SQL Server 2025 Vector Search with Load-Balanced Ollama Embeddings
SQL Server 2025 introduces native support for vector data types and external AI models....
Forums
how to use a variable in a CASE statement?
hi everyone I am getting an error when I add a variable to a...
How to Use SQL Server Features to Cut Web App Latency in Half
Comments posted to this topic are about the item How to Use SQL Server...
Choosing an AI in Sept 2025
Comments posted to this topic are about the item Choosing an AI in Sept...
Question of the Day
The New SQL Server 2025 Data type
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers