(arcanecode) Hopefully everyone had some fun over the weekend with their digital cameras and listening to some good photo podcasts. Today we’ll return to the subject of Full Text Searching (FTS) under SQL Server 2005.
Other News
SSIS Script Task In SQL Server 2008 Can Use VB Or C#
(Denis Gobo) Where do I send a thank you letter? Finally we are allowed to use C# in the SQL Server Integration Services Script Task. I always wondered why SQL Server 2005 only uses VB and not C#, you can use C# in the SQLCLR but not in a Script Task. It turns out that SSIS in SQL Server 2005 […]
Get to know JsonML
(Martin Brown) The rise of JavaScript Object Notation (JSON) has gone hand-in-hand with the rise of Asynchronous JavaScript + XML (Ajax). JSON is useful because it enables you to easily transmit data that can be turned back into a JavaScript object, but it still requires custom scripting to deal wit
FIX: A foreign key constraint that you drop on a table at the publisher is not dropped on the table at the subscriber in a SQL Server 2005 merge replication
In a Microsoft SQL Server 2005 merge replication, you drop a foreign key constraint on a table at the publisher. After you synchronize the data between the publisher and the subscriber, the replication merge agent does not drop the foreign key constraint on the table at the subscriber.
Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 3
(Muthusamy Anantha Kumar) Part I and Part II of this series discussed PowerShell installation and simple SMO, WMI cmdlets. Part 3 of this series illustrates how to script PowerShell cmdlets and execute them. Scripting is essential for automation and executing repetitive tasks.
Encrypted .NET Serialization to a SQLite Database
(brettg) This is a follow-on to my first article, “.NET Serialization to a SQLite Database.” In that article, I pointed out that most non-enterprise applications need the ability to store data locally. Some need only simple storage, whereas others need a full SQL database capability for various need
Using the BackgroundWorker Component in .NET 2 applications
(Michael Livshitz) The BackgroundWorker Component allows a form to run an operation asynchronously. This is very useful when we deal with such kind of operations as database transactions, image downloads etc. In this case our user interface can hang (or not appear until loading will be finished). In
Using ANYDATA in Oracle 9i
(Shraddha Pandya) First introduced in Oracle 9i, ANYDATA is a “self-describing data instance type” which means it not only holds the value, but it also holds its own data type within each instance of it. An ANYDATA can be persistently stored in the database. It also contains many methods that allow
Getting friendly with DOM
(GB Shah) There are a number of such objects in the DOM model and it is important to understand some of these in detail.
Upgrading SQL*Plus Client
(John Russell) Sometimes the old ways are best, sometimes not. I have some rarely-used machines where I had never bothered to upgrade my client installation, and so were still running the 9i SQL*Plus. The older SQL*Plus could still compile all my PL/SQL source that used the latest and greatest 10g f