The SSWUG.ORG Ultimate Virtual Conference Starts This Wednesday
The largest online event for SQL Server, Business Intelligence, SharePoint and .NET is about to happen – it’s just 1 day away! You’ve been reading about it for a week. Now it’s time to get registered before you forget.
If you go to the registration link there is plenty of information about the conference. There is even a quick video on the home page of the conference that gives all the details.
The details should make it easier for you to justify the time with your management. You can tell them exactly the kinds of things you expect to get from this great resource. And you should be praised for your initiative to find cost effective ways to improve your skills to the benefit of your company. When was the last time you attended a conference (70 sessions, 20 speakers) with a money-back guarantee, no travel, incredible content and full access to presenters?
This is the biggest online event, period – check it out!
Watch the video here or Get Registered
Solid State Disks are a Real Option… Finally.
It’s a well-known fact that solid state disks are a killer solution when it comes to performance and really speeding up your SQL Server or Oracle applications. Up until now, price was an issue, but things are changing! Check this out – the PCIe type SSDs, such as the Texas Memory Systems 450GB RamSan-20 (pricing information here), can sustain 120,000 read IOs per second (IOPS) and 50,000 write IOPS. The 10TB network-based RamSan-630 QDR (check out the prices here) can sustain a massive 1-million random read/write IOPS. One SSD could replace a data center full of hard drives. With new pricing moves, it’s worth a look. More information here.
Featured Article(s)
Import/Export Options (Part 3 of 3)
We’re going to spend a little bit of time in this session talking about import/export options, and the things that are available to you in the SQL Server Native Tools about how to get data quickly in and out of SQL Server. This is something that perplexes database developers quite a bit, in terms of “Well, how do I get sample data into my system?” Or, “How do I get data from another source into the database that I’m working with; how can I load that?We’ll spend a little bit of time just talking about a couple of tools that are available to you in terms of the Import/Export Wizard, and how we can go about generating files that are necessary to use for importing and exporting data.
Featured Script
dba3_Alter_Database_ToSecureDbForAdministrativeUse_Demo
One may always use Kill and a cursor to kill active spids as with 6x installations, however with newer versions using an Alte… (read more)
SQL 2008 Full Text Search Service Enhancements
Full text search is a feature that has been integrated with SQL Server for several releases. Full Text Search provides indexing of un-structured data stored in your database. Each word in a string for one or more columns in a table is indexed and can be searched using the "CONTAINS" keyword in the where clause instead of the more common comparisons like =, >, LIKE, etc.
The Full Text Index is not intended to replace good database design or native indexes. The intention is to extend the capability of searching data that may be stored in a database which is intentionally unstructured. For example, The subject and body of emails could be stored in a table. Full Text Search then provides the ability to find records that contain one or more search parameters without having to shred the text into some highly normalized, but un-useful, construct.
In order to use Full Text Search you have to specify on a table by table, column by column basis, where it is to be used. Be aware that creating these full text indexes places additional load on your database.
Prior to SQL Server 2008, Full Text Search was implemented through integration with the Full Text Search Windows Service. Interaction with the service was performed by connections from SQL Server to the Full Text Service.
When SQL Server 2008 was released Microsoft integrated the Full text service with SQL Server, just like SQL Server Agent, or SQL Server Integration Services, the Full Text Service runs as a database process. It is started and stopped along with the SQL Server Engine. Using the Windows Services Management Console you will see it along with SQL Server Service, SQL Server Agent Service, etc.
As a result it does not work like previous versions. When you upgrade from SQL Server 2005 to SQL Server 2008 or later you will need to be aware of the differences. For more information on full text search, follow the link to a Microsoft White Paper regarding the Full Text Search Engine changes in the SQL Server 2008 release.
Do you use Full Text Search? Drop us a note and share your experiences with our readers.
Cheers,
Ben