Filters:

  • Technologies

  • Instructors

  • Blog Author Archives: Jeff Jones

    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 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

    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™

    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 you are using. Adventureworks Sample Databases – http://msftdbprodsamples.codeplex.com/

    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.  A group of SQL Server users are attempting to organize a SQL Saturday event.  Check … Continue reading Links to SQL Server User Group Community in Phoenix, AZ – by Jeff Jones

    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 to provide a dashboard for Policy Management – http://epmframework.codeplex.com  

    Who has access? – SQL Server

    Occasionally you would like to find out all the tables, views and stored procedures a user can access and what permissions they have.  With a combination of the new EXECUTE AS command and the new HAS_PERMS_BY_NAME function you can figure this out.  Below is a query that uses the sys.All_Objects metadata view to generate object names.  Then it passes … Continue reading Who has access? – SQL Server