Interface Technical Training hosted a very special Advanced T-SQL course with SQL MVP Itzik Ben-Gan on October 17-21, 2011. We sat down with Mr. Ben-Gan to get his thoughts on various topics related to Transact SQL. In this video, Itzik shares his insights on the new features of SQL Server 2012 codename “Denali”. Below is … Continue reading Video: Itzik Ben-Gan on the new features of Microsoft SQL Server 2012 Denali
Interface Technical Training hosted a very special Advanced T-SQL course with SQL MVP Itzik Ben-Gan on October 17-21, 2011. We sat down with Mr. Ben-Gan to get his insights on various topics related to Transact SQL. In this video, Itzik discusses how to optimize queries in your SQL Server Database. Below is the transcription of … Continue reading Video – Itzik Ben-Gan on T-SQL Query Optimization at Interface Technical Training
We were honored to have world-renowned SQL Server MVP Itzik Ben-Gan as an instructor on October 17, 2011. Students attended Itzik’s SQL400 class both in person at our facility and online with RemoteLive. We sat down with Itzik to hear his thoughts on using RemoteLive to deliver live training online.
I’ve had a lot of requests for an Advanced T-SQL class over the years. I’m proud to announce that Interface is now offering a 5-day Advanced T-SQL Querying, Programming & Tuning class from world-renowned instructor and MVP Itzik Ben-Gan on October 17, 2011. You can also attend this class online with Remote Live™ if you … Continue reading Advanced T-SQL Class at Interface with MVP Itzik Ben-Gan, and you can attend online with Remote Live™
One week only! Interface Technical Training offers SQL400: Itzik Ben-Gan's Advanced T-SQL Querying and Tuning for SQL Server 2005 and 2008 in Phoenix, October 17-21. This course can also be attended online with Interface Remote Live™ technology. This is a 5-day masterclass for writing and tuning queries, programming and problem solving with T-SQL, in SQL Server 2005 & 2008. … Continue reading Advanced T-SQL Querying and Tuning Masterclass by MVP Guru Itzik Ben-Gan – One week only, Oct 17
One aspect of using the PIVOT is to include a list of columns that will be used as the crosstab of the query. For example, if you wish to display the total quantity ordered by Productid by Year you need to include the list of years for the query. This unfortunately must be a static … Continue reading Dynamic PIVOT by SQL Server Instructor Jeff Jones