• Ike Ellis, San Diego SQL Consultant
  • Ike Ellis, San Diego SQL Consultant in Black & White


Partner at Crafting Bytes, SQL Server Consultant, and Data Architect

What I do:
-I'm a partner in Crafting Bytes. We love creating software and helping customers. If you have a tight deadline or a hard problem, hit us up. We have deep experience in Microsoft .NET, JavaScript, mobile development, WCF, REST services, software architecture, Azure, Amazon EC2, SQL Server, Azure DocumentDB, AngularJS, and NodeJS.
-I consult on SQL Server performance tuning, SQL Server architecture, data warehouse design, and business intelligence projects

Things I like to brag about in casual conversation:
-5 year Microsoft Data Platform MVP
-Co-authored a book with a few other MVPs on database performance
-Co-authored a book on Developing Azure Solutions with Michele Bustamante and Zoiner Tejada
-14 years as a MCDBA, MCSE, MCSD, and MCT
-Wrote a cover story for TDWI - 2014
-Wrote a story for CIO Insider magazine on Database Lifecycle Management
-Regularly speaks at Code Camps and SQL Saturdays on topics like Data, BigData, Data Visualization, Business Intelligence, SQL Azure, DocumentDB, Azure SQL Database, and SQL Server.
-Wrote the course material for Power BI and SQL Server HADR (AlwaysOn) for Azure University.
-Spoke at SQL Pass 2014, 2015
-Spoke at RedGate SQL in the City in London and Seattle 2014, 2015
-Spoke at SQL PASS Business Analytics Conference 2015.

I have a strong interest and experience in Application Lifecycle Management (ALM) as it relates to the database. I'm a Friend of RedGate who is a certified trainer and consultant. I actively consult on RedGate Source Control, RedGate Continuous Integration, RedGate Continuous Release, Octopus Deploy, JetBrains TeamCity, and tSQLt, Approval Tests, XUnit, RedGate SQL Prompt, RedGate ReadyRoll, JetBrains Resharper, and GoCD.


  • PartnerJanuary 2013 - Present

    We're a small software development shop. We service customers in San Diego. We specialize in web development, commercial software development, and mobile development. We currently have six full time developers. We just hired a full time QA resource that tests every line of code we write. We don't charge for this service, but provide it complimentary to improve quality and distinguish ourselves from competitors.

    We focus on:
    Microsoft development
    Modern Web Development (Javascript, NodeJS, RESTful services, ASP.NET MVC/WebAPI)
    Cloud software development and architecture (Azure mobile services, Azure data services, Azure websites, Azure VMs, and more.)
    Cross platform mobile apps (PhoneGap, Xamarin)
    Interactive entertainment experiences (Xbox360, XboxOne, Kinect, Multitouch)
    Big Data (SQL Server, Hadoop, SSIS, SSRS)

  • Consultant2000 - Present

    Ellis Consulting

    With over 17 years of experience with Microsoft SQL Server, Ike Ellis is a business intelligence and SQL Server Consultant. Ike has been a SQL Server MVP since 2011. Ike has been Microsoft certified since the beginning, currently holding an MCDBA, MCSE, MCSD, and MCT. He is a popular consultant, lecturer, and community leader.

    Ike specializes in creating data warehouse, ETL systems, reports, dashboards, and data models. He works with SQL Server extensively. He also does troubleshooting, analysis, programming (T-SQL, MDX, and DAX), mobile BI solutions, and performance tuning.

    Ike is also a popular user group, code camp, SQL Saturday, and conference speaker.

  • SQL Server & BI Author and Instructor2010 - Present


    Ike flies around the world, teaching students about SQL Server, Data, and Business Intelligence.

  • Microsoft MVP2011 - Present


    In recognition of his industry contributions, Microsoft awarded Ike a Most Valuable Professional designation, with an emphasis in SQL Server. This goes along with the other Microsoft Certifications he's earned, including MCSD, MCDBA, and MCSE.

  • Founder2011 - Present

    San Diego Tech Immersion Group (SDTIG)

    This user group focuses on helping students go in depth on a wide variety of technical topics. Every 3 - 6 months, we choose a book, and every member of the group reads the book together. We meet once a month. It has grown into the largest user group in San Diego.

  • Virtual Chapter Leader2013 - Present

    SQL Pass

    SQL Pass is the largest world wide organization of SQL Server Professionals. Ike leads the Book Readers virtual chapter.

  • Board Member2010 - Present

    San Diego .NET User Group

    We are the largest organization of Microsoft developers in San Diego

SQL Server

  • Performance Tuning

  • T-SQL Programming

  • Troubleshooting

  • Database Design

Business Intelligence

  • Reporting Services

  • SSAS - Tabular

  • SSAS - Multidimensional

  • Integration Services


  • SharePoint


  • C#/.NET

  • MDX

  • DAX

  • JavaScript

Favorite Tools
  • Microsoft Azure DocumentDB
  • Azure's NoSQL document database implementation. Product is a PAAS play that is fully scalable with you. Fits really well with Microsoft Azure Websites.
  • I'm pretty excited about this product. There are some rough edges, but over all, I love it.
  • PocketCast
  • Podcast app for Android phones
  • I love this app. It downloads all of my favorite podcasts at 2am. I always have something to listen to in my car. I can't tell you how liberating this feels.
  • Kindle Cloud Reader
  • Book reader app for Chrome and FireFox
  • Ever since Amazon allowed my notes and highlights to be shared between all of my devices, I have loved reading on the Kindle. If I'm in Chrome and highlight a text, it syncs with my Kindle Paperwhite. If I'm bored and on my phone, I can read a book, and it syncs my current page read. I read a ton more than ever because I always have access to my entire library.
  • Bids Helper
  • A Visual Studio add-in that enhances development functionality in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools (SSDTBI).
  • This tool is essential for all SQL Server Business Intelligence professionals. It helps with SQL Server Analysis Services, Integration Services, and Reporting Services. It helps troubleshooting, cube creation, designer improvements, etc. Anyone working with these tools without using BIDS Helper is working impaired.
  • JetBrains OxDBE
  • A tool for working with all different types of databases. This is one tool that will work with PostGres, SQL Server, and Oracle (among others, but those are the big three.)
  • I love SQL Server Management Studio (SSMS), but this tool is really great with Oracle. I dislike Oracle's native tools, and Toad is too expensive. This is a great tool for creating and interacting with Oracle objects.
  • RedGate SQL Lighthouse
  • When your databases change, you get an alert from SQL Lighthouse. On the web dashboard, you can see everything that's changed, who made the changes, and when. You can then decide to roll back the change or deploy it to more databases, using SQL Compare.
  • This combats database drift. It's a problem in every single database shop I've ever worked with. This will allow us to correct drift as soon as it happens, making it cheaper and more reliable.
Favorite Quotes
  • "Do not rely on Rigid, Inefficient Processes (RIP)."
  • Steve McConnell
  • Software Project Survival Guide
  • "Early in the project you can have firm cost and schedule targets or a firm feature set, but not both."
  • Steve McConnell
  • co-Inventor of Extreme Programming
    Preface to Extreme Programming Pocket Guide
  • "There is a word for software that cannot be changed after delivery. That word is hardware."
  • Ward Cunningham
  • Software Project Survival Guide
  • "The problem with quick and dirty is that dirty remains long after quick is forgotten."
  • Unknown
  • "Question: What is the difference between a methodologist and a terrorist?
    Answer: You can negotiate with a terrorist."
  • Martin Fowler
  • UML Distilled
  • "You should use iterative development only on projects that you want to succeed. Perhaps that's a bit glib, but as I get older, I get more aggressive about using iterative development."
  • Martin Fowler, espousing Extreme Programming
  • UML Distilled
Favorite Podcasts
  • JavaScript Jabber
  • A podcast with a few hosts that illuminate the darkest corners of JavaScript
  • I listen to every episode. I look forward to new ones. They are funny, educational, and enthusiastic. I highly recommend this.
  • Carl Franklin and Richard Campbell talk about various Microsoft software development technologies.
  • I have been listening to these guys for over 10 years. The amount of things they've taught me are incalculable. Love it!
  • Herding Code
  • Developers talk about a wide range of topics, from cloud development to functional programming.
  • I'm a big fan (and friend) of K. Scott Allen and John Galloway. They do great work and have keen insight into software development. I wouldn't miss this podcast.
  • Chandoo
  • A data analysis podcast.
  • This guy cracks me up. He's so authentic in his podcast, that I can't get enough of it. He always says when he finds a topic difficult to learn or when he struggled gaining a skill. He's just so real and unashamed of anything. His excitement for a topic really shines through. It's not for everyone, but I love this guy.
More Favorites to Come