Editorials

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

Is There a Danger in Managed Services?

I was talking with someone about their installation of SQL Server and they were bragging about how they were using a cloud-based solution (really doesn’t matter even which one) where the systems were completely managed for them. From backups to performance to just about every aspect of their SQL Server installation, it was taken care of. It was saving big […]

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 […]