Tag Archives: T-SQL

Video – Itzik Ben-Gan on T-SQL Query Optimization at Interface Technical Training

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

Advanced T-SQL Class at Interface with MVP Itzik Ben-Gan, and you can attend online with Remote Live™

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™

Advanced T-SQL Querying and Tuning Masterclass by MVP Guru Itzik Ben-Gan – One week only, Oct 17

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

Renaming SQL Server

The following is a T-SQL script you can use to rename your SQL Server after you have changed the computer name. This script will work if you are connected to the default instance or a named instance. After running the script, you must restart SQL Server for the action to complete. DECLARE @machinename sysname, @servername … Continue reading Renaming SQL Server