SQL

Fast and Furious Dynamic SQL

Fast and Furious Dynamic SQL (Tuesday March 17th 2015) Presenter: Jay Robinson We all appreciate a well-defined and well-tuned stored procedure. But sometimes the problem calls for a more dynamic solution. What are those problems and how do you generate SQL to solve them? After attending this session, you will…


SQL Saturday Pre-Conference Events

It’s Official we will have Four Pre-Conference Events on Friday August 7th the day before SQL Saturday.  New Horizons of Indianapolis host this all day event. Click here to register. Register before July 23rd for an Early Bird discount. And what a great line-up we have. When Bad Things Happen to Good…


SQL Server Exam Prep

Studying for your SQL Server certifications can be a daunting task, but Microsoft has just made it easier for you by offering a complete portfolio of online resources on Microsoft Virtual Academy (MVA). These courses cover SQL Server 2012, along with performance tuning and high availability features of SQL Server…


Call for Speakers

Dear SQLSaturday Speakers, SQLSaturday #402 is coming to you on Aug 08, 2015 at Indiana Wesleyan University North , 3777 Priority Way South Drive, Indianapolis, IN 46240. You can submit your session by using the call for speakers page. We look forward to hopefully seeing you as a speaker for…


Working with Data Types

This is my Working with Data Types presentation for the SQL Saturday in Cleveland on February 7th, 2015. Some helpful links. Sample Code from Presentation Character Data Type Demonstration Integer Data Type Demonstration Date and Time Data Type Demonstration Data Type Conversion Demonstration How Rows are Stored in a Data Page…


SQL Saturday #402

Yes, we are live. Registration for SQL Saturday has begun. We are very excited to bring this wonderful event back to Indy!  This year the event will be held on Aug 8, 2015 at Indiana Wesleyan University North.  The address is below.  Admittance to this event is free, but we…


IndyPASS – SQL Certification

Attached is my presentation on SQL Server Certification (Updated 8/2017) that will be presented at IndyPASS on January 20th. Also provided are useful links in getting certified on SQL Server. Microsoft Learning – SQL Server Certifications. MTA – Exam 98-364: Database Fundamentals Why get Microsoft Certified Microsoft Certified Solution Associate Microsoft Second Shot…


Cleveland Schedule Released

The schedule for SQL Saturday for Cleveland has been released. Looks like I will be doing my presentation on Data Types at 3:00pm in Training Room 5. Click here for the complete schedule. SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This…


January Speaker for IndyPASS

It has been confirmed that I will be the Guest Speaker for the IndyPASS meeting on January 20th, 2015. The topic of the night will be on How to obtain Microsoft SQL Certification. I will be starting with discussing the certification paths and the electives availabe for both the Database Platform…


First Guest Speaker for Brazil

What a fun time I had being the first ever guest speaker for the first SQL PASS chapter meeting in Recife, Brazil. It went much smoother than I thought considering Armando had to translate everything into Portuguese. I have written blog posts on the topics covered and have listed them…