Monthly Archives: April 2013

Factivism

I believe that we should all give back to the world outside of our families at some point in our lives. This might not be the time for you, and you might not have a cause right now. However I … Continue reading

Posted in Editorial | Tagged

Flight Data

I’m getting ready to fly tomorrow, heading to SQL Saturday #175 in Fargo, ND. I have a morning flight, to give me a little time in the afternoon to go see the woodchipper. That’s if I don’t have any delays. I … Continue reading

Posted in Editorial | Tagged ,

Adding Data to Filestream with T-SQL

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 , , ,

Natural Data

Can you own data? In one sense, that’s what the arguments before the US Supreme Court over a Myriad Genetics patent are about. The company has patents for a few genes, which in and of itself, are really just data about a … Continue reading

Posted in Editorial | Tagged

Accelerating Your Career

I ran across an article on ways to accelerate your career and for the most part I think these are good ideas and suggestions. Networking, finding a mentor, and more will help you no matter what business or field you are working. … Continue reading

Posted in Editorial | Tagged

Does TDE really work on MDF files?

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

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 , ,

Upgrading to 2012

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

Doing Your Job

I wish this were the mantra of all people, but certainly those in technology:

Posted in Blog | Tagged , | 1 Comment

SQL Saturday #175–Fargo

One of the goals early on with SQL Saturday was to spread them far and wide. Andy Warren and I used to chat about how long it would be before we had 12 events in a year, or one event … Continue reading

Posted in Blog | Tagged , , ,