In this presentation we will be training on TSQL Functions, there will be three sections. —Date and Time Functions —Logical Functions —User Defined Functions Here is the link to the Google On Air Broadcast where you can watch live (or …

SQL Training – Functions (70-461) Read more »

    Click on the grid to enlarge, then print it. Find the following words in the grid up, down, left, right, horizontal, vertical, and diagonal. ROWS  RANGE  PRECEDING  FOLLOWING  UNBOUNDED  IIF  CHOOSE  OFFSET  FETCH  FORMAT  CONCAT  SEQUENCE  PARSE  TRYPARSE  …

SQL Sunday Fun – Word Search with New T-SQL 2012 Functionality Read more »

I had so much fun at SQL Saturday in Vancouver BC last year, I have decided to go again. The sessions submitted are: The “Run Faster” Switch The NO_LOCK hint is often believed to be the “Run Faster” switch, but …

Sessions submitted to SQL Saturday Vancouver BC Read more »

So far after playing around with SQL Server 2012 there are many new features to SQL.  Overall I think my favorites are in the Analytic Functions category.  Here is my breakdown of the top 10 transact SQL enhancements to SQL …

My Top 10 TSQL Enhancements in SQL Server 2012 Read more »

It has been a busy week getting ready for  SQL Saturday Vancouver, planning sessions to present at future training’s and determining new material to present. Today I submitted 4 sessions to Seattle Code Camp for their June session. Using SSRS …

4 Sessions Submitted to Seattle Code Camp Read more »