Author: Ben Taylor

Editorials

Tiers of Support

When it comes to a database engine and maintaining efficient performance you have four basic options. Don’t do anything and take what the engine does by default Host it with a provider that manages your installation Outsource a professional service to manage your database as an add on service Hire your own expertise A lot of people get reliable performance […]

Editorials

NOEXPAND

Generally, I don’t like using SQL Server materialized views, sometimes called Indexed Views, because they are materialized by creating an index on the view definition. In order to create an index on the view you have to define it with phrase WITH SCHEMABINDING. What this does is map the view definition to the underlying tables in the query, even if […]

Editorials

What’s Keeping Us From The Cloud

What’s keeping us from embracing the cloud for our data storage? From my experience the primary hurdle has been cost. Because the cloud is so flexible on how you can store things, calculating that cost is different from one implementation to the next. One thing that seems to be pretty consistent, regardless of implementation, is the cost of bandwidth to […]

Editorials

How to Copy Sql Data

When you think about database redundancy and SQL Server, there are a number of ways to implement the duplication of data, built directly into the engine. SQL Azure automatically creates three copies of any database you publish. It has a working copy, a witness, and witness of the witness. If the working copy goes offline, the witness is promoted, and […]

Editorials

SSMS Database Scripting

One of the great features included in SQL Server Management Studio (SSMS) is the ability to script out a database so that it can be re-created using TSQL commands. This makes the database highly transportable in that the script can be generated and then modified if needed to address implementations for different versions of SQL Server. For example, the Sequence […]

Editorials

SSMS and SQL Server Profiler

Here’s a very useful tip when working on queries in SSMS. While you are in SSMS you can quickly open the SQL Server Profiler program by selecting SQL Server Profiler from the tools menu. This is probably common knowledge. However, did you know you can open up a profiler session already configured to capture the command related to a specific […]

Editorials

Query Tips in SSMS

You can open many different query windows in SQL Server Management Studio (SSMS). Each query window creates its own connection to the specified database. Even though SQL Server supports executing multiple queries over the same connect, no connections are shared in SSMS. Here’s a cool thing you can do from a query window. Press F4, or select Properies Window from […]

Editorials

SSMS Templates

One of the things I really like about SQL Server Management Studio (SSMS) is the ability to use templates to help standardize and automate the creation of SQL code. This works by including special text in your template document, much like mail merge in the old days of word processing. Pressing Ctrl-Shift-M opens a dialog allowing you to replace the […]

Editorials

SSMS

One thing that sets SQL Server apart from many other data engines are all of the tools and extensions that surround it. SQL Agent, SSIS, SSRS, Analysis Services, Data Broker, etc. are a few of those valuable extensions. The one I have enjoyed the most, maturing from two different products in the early ‘90s, is SQL Server Management Studio, (SSMS). […]

Editorials

FileStream vs. FileTable

Today I want to talk a little bit about the difference between the Sql Server FileStream introduced in 2008, and the SQL Server FileTable introduced in SQL 2012. Both features share the common capability of integrating file data with a SQL Server database which has been enabled to use FileStreams. A file stream is a pointer to a byte array […]