Tonight I attended Pitch Fest at the Big Idea Labs in Bellingham, and I was one of two winners of the pitch competition. Pitch Fest is like a mini Shark Tank where you present up to a 3 minute pitch, followed by 3 minutes of questions from the 4 judges. However the difference between this and with Shark Tank is …
Just 2 more days until the Bellingham Startup Weekend. It all starts off Friday night by pitching your ideas, then over the weekend building a startup.I am looking forward to the startup weekend to meet other entrepreneurs and attempt to get my idea as a startup. I have several ideas that I have been contemplating over the last several weeks, …
My second presentation at SQL Saturday in Portland Oregon is Advanced Common Table Expressions. Here is the outline for the session. 1. Hierarchical Recursive CTEs 2. Manipulating Data 3. Common Use Cases 4. CTE Performance Considerations Download the presentation and samples here: Advanced CTEs.zip See Also: Introduction to CTEs presentation
Today I am at SQL Saturday Portland Oregon, and at 9:00am I am presenting the Introduction To Common Table Expressions session: Here is the abstract: Have you ever wanted to create a recursive query, but didn’t see how to do it. With the Common Table Expressions session you will learn everything needed to start using CTE’s for recursive queries, as …
Over a year ago I was at a SQL Saturday listening to Rick Morelan from Joes2Pros talking about his goal, which if I remember correctly was to get 3 certifications a year, and that he has obtained over 30 technical certifications. Earlier this year I decided that I would follow with a similar goal of 3 certifications per year. Yesterday …
Great video that I discovered on YouTube today. Some great lines in this video… “The project gets crazy and they call me to save it, so I search Pinal Dave and copy and paste it”. “Your company is so backwards they still use Lotus Notes”.
I will be attending SQL Saturday #265 in Portland Oregon on November 16th 2013. This will be my second time attending SQL Saturday in Portland, and it is looking to be a great event. There are some great speakers on the line up that I am looking forward to learning from. I will be presenting 2 sessions on Common Table …
I have just registered for the Bellingham Startup Weekend, which is just 3 weeks away, and looks like it should be a fun weekend. Bellingham Startup Weekend is part of a larger organization that runs Startup Weekends all over the planet. On November 22nd, 23rd and 24th, teams of entrepreneurs will commit to a 54 hour weekend to build a …
I started out the day with the keynote presentation with some great info on PASS and the PASS volunteers, followed by Microsoft presenting on in memory tables, and native compilation for stored procedures, described and demonstrated as “Wicked Fast”. Next I attended a fabulous presentation from Erin Stellato on Extended Events, an improved replacement for the SQL profiler. I learned …
A great turnout for the CTE book signing tonight. Enjoy the books. The scripts don’t appear to be available at the publisher site any more here is the download. Download here: Joes2Pros T-SQL Scripts