Archive for March, 2011


Tips for Querying Text Columns in SSMS

SQL Server Management Studio (SSMS) is a great tool for writing and running queries. This post will provide some extra tips on querying text fields in a database table. These include:

  • Query fields with long or formatted text
  • Copying strings by dragging them from the results grid
  • T-SQL query tips for working with strings

Continue reading

Movie ReelIn a previous post, I encouraged you to consider an older video series focussed on learning SQL Server 2005 Express. In this post, I’d like to highlight a different video series focused on SQL Server 2008 Express: SQL Server 2008 Express How-To-Guide Series. Here is how I would suggest getting the most out of these videos.

Continue reading

Understanding SQL Server Connection Strings

Many people start learning SQL Server, because they want to use a database in application development. You can develop web or client applications with a retail version of Visual Studio or the free edition, Visual Studio 2010 Express (there is also a new product called Web Matrix that we hope to talk about in future posts). A connection string specifies how to connect to your SQL Server database. Development tools can hide or create this connection string for you, but it helps to know how to create one and what it means. In this post, we’ll cover the basics, provide some examples, and point to tools that automatically generate connection strings.

Continue reading