DBA Depot

DBA Depot Don't have a budget for a full time DBA? Need to pick the brain of an expert for a few hours at a t Our long-term experts will solve your short-term problems.

Performance tuning, custom development, on-site training...we do it all.

We can't wait to see what happens next
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/

We have been patiently waiting for this day...Just kidding!  We have been jumping up and down with excitement ever since...
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...

Address

Ottawa, ON

Alerts

Be the first to know and let us send you an email when DBA Depot posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Share