Tag Archives: sql server

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

Upgrading to 2012

Posted on April 20, 2013 by way0utwest

It’s been a little over a year since SQL Server 2012 was released in its RTM version. In that time, I’ve been using it on most of my machines for testing and demos. I like working with the new features and … Continue reading →

Posted in Editorial | Tagged | 1 Comment