622 reputation
418
bio website jadito.us
location Chicago, IL
age 27
visits member for 2 years, 4 months
seen Dec 18 at 19:25

Currently I am a Technical Consultant. Previously, I was a Jr. Database Administrator and before that, a SQL Server Database Programmer. My graduate research and studies are primarily involved with database models and optimization. I like to write on my blog about technical problems which I've encountered. Feedback is always welcome and appreciated.

I'm a Pastafarian and part of the Church of the Flying Spaghetti Monster.

Writing a question? Follow Jon Skeet's guide on how to write a good question.

Answering a question? Follow Jon Skeet's guide on how to write a good answer.


Dec
17
comment Where do I find the tables that a role has access to in Vertica?
No worries. It just tacks on the navigation path unnecessarily.
Dec
17
revised Where do I find the tables that a role has access to in Vertica?
edited link, syntax, version
Dec
17
suggested approved edit on Where do I find the tables that a role has access to in Vertica?
Dec
4
awarded  Popular Question
Oct
3
comment How to query from a linked server via a linked server in sql server?
@kaptan Next time you go to the mechanic, and they ask what's wrong, don't give them any explanations.
Sep
30
awarded  Explainer
Sep
17
comment Keeping rows ordered by counter value
@MaxVernon What's the point of storing relational data in a relational database system?
Sep
1
comment How to architect an analytical BI platform?
You can try browsing around vertica.com or third party vendors for white papers or use cases. If you choose Vertica, architecture could be part of the work. In regards to your earlier comment, I'm pretty sure Vertica has a much lower cost of ownership than other EDW. Feel free to reach out privately (send me a message at vertica.tips) and we can discuss further.
Aug
31
answered How to architect an analytical BI platform?
Aug
27
comment Proposal: MySQL blob handling revision
GIVE IT A TRY!!! ... there, now your answer is perfect.
Aug
10
awarded  Yearling
Jul
2
awarded  Curious
Jun
20
comment Where do I find the tables that a role has access to in Vertica?
But you said you "poked around" in the GRANTS table...
Jun
19
comment Where do I find the tables that a role has access to in Vertica?
What is your desired result? This may help
Jun
2
comment Innodb: Operating System Error number 5 in MySQL
Off-topic and belongs on Database Administrators
May
28
comment Is there better way to design SQL tables
I think the ReceivedOrder, HoldOrder, DispatchOrder could be combined.
May
14
revised How do I get the size of a Vertica database?
added 3094 characters in body
May
14
answered How do I get the size of a Vertica database?
Mar
11
comment Database software advice
@Jason Perhaps you're not being clear about what you need and blindly going with some less-than-optimal solution.
Mar
5
comment Ola Hallengren with database mirroring
@swasheck Speak for yourself, but I was more excited than a little school girl.