The fourth part of a great data warehousing series from Vincent Rainardi. This article continues the look are still other methods of extracting data from the source system along with the advantages and disadvantages of each.
2006-05-02
14,466 reads
SQL Full-text Search (SQL FTS) is an optional component of SQL Server 7 and later, which allows fast and efficient querying when you have large amounts of unstructured data. This is the first of a two-part article that explores the full-text language features that ship with SQL Server versions 7, 2000, and 2005, with particular focus on the new language features in SQL 2005.
2006-05-02
3,641 reads
Apress, one of the premier techincal publishers, is releasing quite a few titles based on SQL Server 2005. They've agreed to sponsor our Question of the Day and give away some books. Read how you can win and what they're offering.
2006-05-01
2,447 reads
Mapping services have become quite popular on the Internet and with many applications, but in order to use these, you need to map an address to a latitude and longtitude. Corey Bunch brings us a CLR example of how you can do this.
2006-05-01
19,035 reads
In this article, adapted from the just-published second edition of MDX Solutions that Chris co-authored with George Spofford, Siva Harinath, Dylan Hai Huang, and Francesco Civardi, Chris shows us how to start exploring the world of cubes and MDX Scripts.
2006-04-30
1,472 reads
A Friday distraction from work when you have time. Can you figure out who has the dual 19" LCD monitors?
2006-04-28
9,449 reads
When architects speak with database administrators, it is important they come forearmed. Tools can help. While Microsoft's own database management tools cover the most common database administration scenarios, they don't do anything about some of the most common pain points faced when you need to maintain and deploy SQL Server databases for projects under active development. That's where Red Gate comes in.
2006-04-28
1,984 reads
Phonetic matching, working on finding terms that are misspelled, is an art and there are a number of ways to handle it. In SQL Server 2000 the tools are limited, but Michael Coles brings us part 3 of his toolkit with some handy functions that can help you with text searching.
2006-04-27
16,925 reads
There is a world of difference between the business processes that really take place in a company and the management's understanding of those processes…
2006-04-27
2,351 reads
Ensuring the availability of your database servers is becoming more important all the time. Fortunately you have more choices than ever. Bilal Ahmed looks at some of the possible solutions available for SQL Server.
2006-04-26
5,436 reads
By Steve Jones
This is kind of a funny page to look at. The next page has...
A while ago I blogged about a use case where a pipeline fails during...
By HeyMo0sh
Something has shifted quietly in 2026. The developers I know/respect—the ones actually shipping, not...
I have a table I didn't design that has tons of repeating groups in...
Comments posted to this topic are about the item Writing as an Art and...
Comments posted to this topic are about the item String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers