Virtual Training – SSIS, and Replication
February 1 – 28, 2011
Here is an opportunity for you to add or extend your SQL Server skills in the areas of SQL Server Integration Services (SSIS) and/or SQL Replication. As Steven wrote a while back, there are so many skills a SQL Server professional needs to have today, its difficult to keep up.
Eric Johnson, SQL Server MVP, has put together 12 virtual classes on SSIS and Replication. For those who register, the classes will be available for the whole month of February. An interactive DVD is also available. This allows you to study at your own pace, and fill those gaps in your tool set.
You’re going to have to register.
Register today for SSIS
Register today for Replication
SharePoint Administration Expo
Friday, February 11, 2011
9 a.m. – 1 p.m. PST
This expo is all about providing the foundation for providing outstanding service with SharePoint. We’ll be going into information on access control, uses of different capabilities of SharePoint and working with SharePoint projects.
Our expert panel of presenters will be investigating access controls, focusing on points you’ll want to know about as you set up your systems and the security surrounding them. We’ll also have information about assuring a successful project to help you determine which aspects are important to consider.
There will even be information about implementation strategies and tips you can put to use immediately.
With registration, all attendees will also receive a complimentary month of full membership to SSWUG.org, where they can learn even more about SharePoint and other databases and database technologies through in-depth articles, podcasts, how-to videos and more. All the content will also be able for seven calendar days after Feb. 11, allowing attendees to revisit key portions of information at a convenience.
Register today to save your place for these great sessions!
Featured White Paper(s)
Essential Performance Tools for SQL Server DBAS
Optimizing SQL Server performance can be a daunting task. Especially so for an increasing number of reluctant DBAs faced with… (read more)
Featured Script
dba3_0030_hr_Set_SuperSets_WithOrder_Article
Creates stored procedure hr_Set_SuperSets Used in demonstrating a Maps and Sets logical design of a hierarchical system. … (read more)
$$SWYNK$$
Full Text Indexing in SQL Server 2008
Full text indexing is a really cool feature that has been a part of AQL Server for many releases. For those of you who don’t know, Full Text Index is a tool that allows SQL Server to integrate and search large textual documents, create an index on the contents, and then utilize that index using search criteria against the full text data.
Full text indexes may be created against BLOB data stored physically in SQL Server, or stored externally in physical files. Prior to SQL Server 2008, full text indexing was a Windows NT Service against which SQL Server integrated. With SQL Server 2008, All Full Text Indexing for SQL Server runs as a separate Windows NT Service. As a result, you have many more new options to tune the way the Full Text Indexes are created and maintained, better integrating with the flow of data in your environment.
For XML data, Full Text Indexing may be a better option than an XML Data Type with an XML Index. Your performance may vary.
For textual data such as text documents, pdf files, etc. Full Text Index does a good job of parsing the contents. You can even tune your index for the type of document being indexed.
Multiple language support is available. However, documents with Mixed Languages do not index as well as documents with a single language.
There is some performance loss on your database server when running full text index. As a Windows Service, it will require CPU and Memory resources; those resources are not available for the database engine, SSIS, or SQL Agent. The performance loss is compensated for through high performance when searching through data with a lot of character content. It is much faster than using one or more LIKE expressions against a string.
You can read more about Full Text Indexing at this Microsoft SQL Server Customer Development Advisory Blog. If you are new to Full Text Indexing, this blog recommends the following resources…
If you would like a good introductory tutorial, start with SQL 2008 Books Online, then read this whitepaper: http://msdn.microsoft.com/en-us/library/cc721269(SQL.100).aspx. It is one of the best whitepapers I’ve seen recently on a product feature.
Also for more introductory lessons here is an excellent link: http://sqlblogcasts.com/blogs/simons/archive/2008/02/19/SQL-Server-2008—iFTS-Introduction.aspx
Simon Sabin also has a nice series of posts on the new iFTS features: http://www.sqlskills.com/blogs/simon/2008/02/20/SQLServer2008IFTSNewFeatures.aspx
Are you using full text indexing, or do you have questions. Send your comments to btaylor@sswug.org.
Cheers,
Ben