Tag Archives: sql server

The Challenger

Posted on May 15, 2013 by way0utwest

There’s a lot of competition among database platform vendors. Once a platform is chosen, companies rarely change, and with good reason. The cost of the people building your application accounts for most of the resources you expend on a database … Continue reading →

Posted in Editorial | Tagged | Comments Off on The Challenger

Adding Data to Filestream with T-SQL

Posted on April 25, 2013 by way0utwest

I’ve written on how to enable Filestream and how to add a filegroup, but I haven’t touched the Filestream impact on your tables. This post will look at the table side of Filestream and how you get your binary data … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Adding Data to Filestream with T-SQL

Does TDE really work on MDF files?

Posted on April 22, 2013 by way0utwest

Yes, it does. However, let’s prove it. First let’s create a database, a table, and enter some data: — create a database CREATE DATABASE TDE_Primer ; GO — create and populate a table USE TDE_Primer go CREATE TABLE MyTable ( … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

A Billion Transactions

Posted on April 22, 2013 by way0utwest

How long would it take your systems at work to process a billion transactions? You’d expect some, heavily used and highly visible systems to be involved. The stock market systems process billions of trades a day, but I’m sure most … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on A Billion Transactions