Tag Archives: Jeff Jones
Transact-SQL does Windows presented by Jeff Jones – SQL Saturday April 28 – Chandler, AZ.
Interface Technical Training Instructor Jeff Jones will present “Transact-SQL does Windows” at SQL Saturday April 28. Jeff’s session is at 9:45 a.m. The free training event will be held at Chandler-Gilbert Community College, 2626 E. Pecos … 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 thoughts on various topics related to Transact SQL. In this video, Itzik … Continue reading
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 … Continue reading
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 … Continue reading
Interface Tech Immersion 2011
Our DEEP DIVE Tech Immersion 2011 was a great success! A highlight was the keynote by Microsoft Distinguished Engineer Jeffrey Snover, the father of PowerShell. Snover cleared up some of the confusion about … Continue reading
Extracting SSIS Package information using T-SQL
SQL Server Integration Services can store it packages in either the file system or the MSDB system database. One of the advantages of storing a package in MSDB is that you can use T-SQL to read the package definition and … Continue reading
Downloading all Adventureworks databases by Jeff Jones – Interface Technical Training
You can get to all Adventureworks databases by going to the following link on Codeplex.com. This includes, Adventureworks, AdventureworksDW, Adventureworks2008, AdventureworksDW2008 and AdventureworksLT2008. Make sure you download the correct release of the samples based on the release of SQL Server … Continue reading
Links to SQL Server User Group Community in Phoenix, AZ – by Jeff Jones
Here are a couple of links to the Arizona SQL Server User Group community. The first is the Arizona SQL Server User Group. It usually meets each month except during the summer. The second is a link to SQL Saturday. … Continue reading
SQL Server 2008 Policy Management Links by Jeff Jones – Interface Technical Training
Here are few links to blogs and open source projects related to Policy Management with SQL Server 2008. The SQL Server Policy Management Team blog – http://blogs.msdn.com/sqlpbm Bart Duncan’s blog entry on Complex Server “Health” Policies – http://shrinkster.com/1bqq Codeplex project … Continue reading
Extracting SSIS Package information using T-SQL
SQL Server Integration Services can store it packages in either the file system or the MSDB system database. One of the advantages of storing a package in MSDB is that you can use T-SQL to read the package definition and … Continue reading
Reporting Services Interesting Links
Below are links to projects in Codeplex.com where you can download the Adventureworks Sample databases and sample codes for reporting services. I have included a link to download a report to link SQL Agent job names created by Reporting Services … Continue reading
FN_Split() Table Valued Function by SQL Instructor Jeff Jones
Fn_Split() The link above is to a file with a table-valued function called fn_split(). This function allows you to pass a string of values to an IN clause of a SQL query. It breaks them down into a set of rows … Continue reading
Integration Services Security in SQL Server by Jeff Jones
Defining security for SQL Server Integration Services (SSIS) is a bit complex. I want to focus on the security required by a developer to create and manage their own packages and people that are not SysAdmins but need to manage … Continue reading
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 … Continue reading
Moving Logins Across Multiple SQL Servers
Moving logins from SQL Server to SQL Server has to be done a lot. There are a number of situations that require moving logins like: log shipping, moving a database from one server to another, or database mirroring. In SQL … Continue reading
Accessing Master..Sysperfinfo Table in SQL Server
The SQL Server 2000 statistics are available in a pseudo-table in Master called sysperfinfo. This table returns the statistics in a table format. There are some statistics that represent ratios (i.e., Buffer Cache Hit Ratio). These statitics must combine two … Continue reading
Moving DTS packages to a SQL Server 2005 Server by Jeff Jones
I have a bunch of DTS packages sitting in the MSDB database on my SQL Server 2000 system. I want to move the packages to my SQL Server 2005 server to continue executing them while I begin the migration. It … Continue reading
SQL Server 2005 Displaying Object Owners
I got a question in class to as to how to figure out the owner of a stored procedure or a view. After looking at the sys.all_objects system view, saw that the principal_id column had a NULL in each row. … Continue reading
