How is automation impacting the dba role?

via GIPHY I was at a dinner party recently, and talking with some colleagues. I had worked with them years back on Oracle systems. One colleague Maria said she really enjoyed my newsletter. Join 38,000 others and follow Sean Hull on twitter @hullsean. She went on to say how much has changed in the last …

How to interview an amazon database expert

via GIPHY Amazon releases a new database offering every other day. It sure isn’t easy to keep up. Join 35,000 others and follow Sean Hull on twitter @hullsean. Let’s say you’re hiring a devops & you want to suss out their database knowledge? Or you’re hiring a professional services firm or freelance consultant. Whatever the …

How to build an operational datastore on AWS with S3 & Redshift

via GIPHY You’re building your data warehouse, and getting data into Redshift. You’ve got your ETL pipeline running, and presentation layer talking to the warehouse. Great. But how to get access to that source data? Wouldn’t it be nice if that was close by too? Join 35,000 others and follow Sean Hull on twitter @hullsean. …

A roughneck walk down database alley

via GIPHY I was just responding to some Disqus comments on a recent blog post. Admittedly it had a provocative title Will SQL databases just die already. What do you think? Join 34,000 others and follow Sean Hull on twitter @hullsean. A reader pointed out that some No-SQL databases do support joins. Huh? My face …

What products & improvements are new on AWS?

Amazon is releasing new products & services to it’s global cloud compute network at a rate that has all of our heads spinning. Join 32,000 others and follow Sean Hull on twitter @hullsean. Here’s new stuff worth mentioning around databases & data. 1. For ETL – AWS GLUE Moving data from your transactional MySQL or …

5 essential tools for Redshift DBA’s

Like every other startup, you’ve built everything on AWS or are moving there quickly. So it makes sense & is an easy win to build your analytics & bigdata engine on AWS too. Enter Redshift to the rescue. Unlike the old days of Oracle where you had career DBAs to handle your data & hold …

Five ways to get your data into Redshift

Everybody is hot under the collar this data over Redshift. I heard one customer say, a query that took 10 Hours before now finishes in under a minute. Without modification. When businesses see 600 times speedup, that can change the way they do business. Join 32,000 others and follow Sean Hull on twitter @hullsean. What’s …

Why is everyone suddenly talking about Amazon Redshift?

It seems like all I hear these days is Redshift, Redshift, Redshift! I met up with a recruiter today. We talked about this & that. The usual. Then when he came to the topic of technology he said, “yeah it seems as though suddenly everybody is looking for Redshift & Snowflake” As I blogged about …

Is data your dirty little secret?

While I was fumbling for the dictionary to figure out what polyglot persistence was, the CTO had decided to build a warehouse on Redshift. “Everybody’s moving data there.” He declared. I looked on quizzically. Join 32,000 others and follow Sean Hull on twitter @hullsean. “That’s a very new database engine”, I chimed in. “Lets do …