DBA Depot

01/12/2018

We can't wait to see what happens next

Reminder: Settle It On the Screen's 2-hour LIVE primetime special series finale show starts at 6pm PST Jan. 12th here on the Twin Galaxies FB Page! We will have video game world record news, Steam giveaways, console giveaways, pieces of our set giveaways, and Guitar Hero sleepshorts giveaways. (no hoodies) Our guests will be Todd Rogers, William McEvoy and Mikey McBryan for this epic show! Share it, love it and tell your mom to watch it! Did I mention the giveaways?

03/19/2015

Powershell and AWS are a powerful combination. I wrote a powershell app that helped me remove hundreds of thousands of files from an S3 bucket, based on their modification date. 19TB gone in a matter of minutes.

09/06/2013

If you have been sitting on the fence, trying to decide if and when you should apply compression to your tables...go for it!

I just added page level compression to a heavily de-normalized table's clustered index, and achieved a 30 to 1 compression ratio!

We now have 20 million records taking up 150MB. Before compression it was taking up 4500MB.

09/05/2013

When using SSMS (SQL Server Management Studio) I rely heavily on keyboard shortcuts. I have been using the relatively same shortcuts for 15 years (ctl-e, ctl-t, ctl-d, etc.) but I have never been able to figure out how to cancel a running query other than using a mouse to click the stop button, or to use the menu shortcuts.

Today however, I learned that you can stop a running query by pressing alt-break!

Interesting times indeed.

08/02/2013

Amazon's cloud services truly are amazing. Sign up and give it a try. If you need any help migrating your databases, give us a shout. We are always glad to help.

07/29/2013

Did you know that if you tried to store 1TB of data on 1980's era cassette tapes (standard 30 minutes per side) it would require roughly 5 million tapes? Oh, it would also take 105 years to record the data.

The lesson? If you are having a hardware based performance issue, just wait a few years and it will solve itself. :)

07/27/2013

We are migrating another big SQL Server to the Amazon cloud. Gonna be a long night.

04/24/2013

Any C # developers out there with a strong work ethic looking to join a team on a new long term project? Strong work ethic required, must be able to function well in a corporate environment. Agile is a bonus.

04/05/2013

Keep an eye on those self incrementing integer fields in your database. If you are even close to a billion, consider converting from INT to BIGINT. And no, don't use SSMS to do that. Create a new table with the new data type, then start exporting records into in chunks. When finished, swap the names of the tables. You have to manage FK constraints and whatnot, but you get the idea. If you want to know more, shoot us a message and we will fill you in on the details.

03/12/2013

If you have a SQL Server EC2 instance, and you want to get your bakups into S3 storage, here is a handy dandy little command line utility to help you do just that: http://s3.codeplex.com/

12/05/2012

http://www.PatrickScottPatterson.com - Episode 2 of Culture x History x Attitude features the following fun! - Scott visits the midnight launches of Halo 4 a...

11/01/2012

We have been patiently waiting for this day...Just kidding! We have been jumping up and down with excitement ever since we became a sponsor. Give it a watch, and enjoy the show!

Here is the media-only select preview of Culture x History x Attitude. This is an unpublished link that will only be live until Friday, October 26. Please, i...