Searching for data in a database is something we all do constantly, but few of us use the Full-Text Search features of SQL Server. Yousef Ekhtiari brings us a look at how you can get around some of the limitations of this feature and possibly use it in your application.
2007-07-24
6,470 reads
Part 3 of this series discussed how to script PowerShell and connect to SQL Server. This installment illustrates how to use a PowerShell script to loop through the content of a file and connect to different servers.
2007-07-24
2,479 reads
Express Edition remains the primary choice for deployments of a full-fledged database engine in less demanding environments. Part two of this series explores its features in more detail in order to better understand its unique role in SQL Server 2005 portfolio.
2007-07-24
2,562 reads
Many new DBAs think that User-defined types are a very cool feature in SQL Server when they first encounter them. However many experienced DBAs soon realize that UDTs can be a pain to work with and longtime SQL Server guru David Poole discusses his experiences
2007-07-23
7,962 reads
Service Broker is a new feature in SQL Server 2005. It is an integrated part of the database engine and it provides queuing and reliable direct asynchronous messaging between SQL Server 2005 instances only. In the future this is planned to be extended to non-SQL Server instances. This article shows how to use Service Broker and triggers to capture data changes.
2007-07-23
2,956 reads
Phil Factor presents a poetic stored procedure for storing any VARCHAR(MAX) to file.
2007-07-23
2,381 reads
Do you wish callers of your library could describe their types to you programmatically? Read a little about reflection in CLR Programming.
2007-07-20
2,249 reads
This article describes how to provide full text search using Microsoft Indexing Service in .NET applications.
2007-07-20
2,379 reads
SQL Server Integration Services (SSIS) includes two very interesting transforms, the Fuzzy Grouping and Fuzzy Lookup transformations. Brian Norberg discussed the former in another article and this time examines the Fuzzy Lookup Transformation.
2007-07-19
10,265 reads
SSIS introduced a feature called "Package Configurations". Package configurations allow us to make SSIS packages portable and help us change SQL Server and file connectivity information dynamically.
2007-07-19
2,738 reads
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Comments posted to this topic are about the item Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers