SQLBits 2013

Searching Binary Data in SQL Server 2012

A look at binary data in SQL Server and full-text searching of the content of binary files.

More and more data collected in organizations is in an encoded format, essentially a binary classification of data. These can be images, audio files, video, or even common formats like Word and Excel files. This data contains lots of important data, but the formatting must be stripped out in order for users to effectively search this data.This presentation starts with a discussion of the three types of data in SQL Server to set the framework. It demos and explains:

structured data
semi-structured data
unstructured data

The talk then looks at how unstructured data is stored in SQL Server, specifically briefly looking at Filestream and Filetable.There is a short discussion of full text search, with a look at the changes in SQL Server 2012 before moving on to the iFilter interfaces which are used to search the binary data while ignoring the encoding.

There are demos of the basics of CONTAINS and FREETEXT searches, along with some of the more advanced options, like customizable NEAR and weighting of search terms.The talk finishes with a short look at the new semantic search feature in SQL Server 2012.

Steve Jones's previous sessions

Blogging for the Tech Professional

Blogging is a fantastic way to attract prospective employers that want to learn more about skills. This can raise your profile, help you guide the interview process, and even help you become an MVP.

Including Your Database in a DevOps CI/CD Process

Many organizations want to build software in a DevOps framework, but struggle to include the database. Come see how Continuous Integration, Testing, and Continuous Deliver can work with a database.

Get Testing with tSQLt

tSQLt is a testing framework that is designed to help you write repeatable, isolated tests against your database code. In this session we will briefly examine the goals of testing, and introduce tSQLt with a variety of demonstrations.

Branding Yourself for a Dream Job

Everyone wants a job they enjoy and look forward to working at each day. This session will present practical techniques for improving your brand and giving you the chance to interview for the job you want.

Continuous Integration for Databases

Building software is hard, and we often find that fixing bugs is expensive if they are not caught early. Continuous Integration (CI) has proven to be a valuable technique in improving software quality and this session demonstrates CI for databases.

Searching Binary Data in SQL Server 2012

A look at binary data in SQL Server and full-text searching of the content of binary files.

Preparation for Disaster

Sooner or later some sort of disaster occur on your SQL Server instance. It might be the destruction of a server, the corruption of a page inside the database, or just the unexpected deletion of some data. When disaster does strike, will you be prepa