<body><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener('load', function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <div id="navbar-iframe-container"></div> <script type="text/javascript" src="https://apis.google.com/js/plusone.js"></script> <script type="text/javascript"> gapi.load("gapi.iframes:gapi.iframes.style.bubble", function() { if (gapi.iframes && gapi.iframes.getContext) { gapi.iframes.getContext().openChild({ url: 'https://www.blogger.com/navbar.g?targetBlogID\x3d8211560\x26blogName\x3dTech+Tips,+Tricks+%26+Trivia\x26publishMode\x3dPUBLISH_MODE_BLOGSPOT\x26navbarType\x3dBLUE\x26layoutType\x3dCLASSIC\x26searchRoot\x3dhttp://mvark.blogspot.com/search\x26blogLocale\x3den\x26v\x3d2\x26homepageUrl\x3dhttp://mvark.blogspot.com/\x26vt\x3d-5147029996388199615', where: document.getElementById("navbar-iframe-container"), id: "navbar-iframe" }); } }); </script>

Tech Tips, Tricks & Trivia

by 'Anil' Radhakrishna
An architect's notes, experiments, discoveries and annotated bookmarks.

Search from over a hundred HOW TO articles, Tips and Tricks


SQL Server Acronyms

While reading some material on SQL Server 2005 recently, I was stumped for a moment when I ran into the term "SAC tool". I soon realized the author who abruptly introduced the term was a victim of Acronymitis & was referring to the Surface Area Configuration tool. Of course considering the sheer breadth of topics that continue to emerge, it is getting imperative to abbreviate commonly used terms & use TLA's (Three Lettered Acronyms).


Here is a quick reference of acronyms related to SQL Server:
  • BOL - Books Online
  • BLOB - binary large object
  • CTE - Common Table Expressions
  • DBCC - Database Console Commands
  • DDL -  Data Definition Language
  • DCL - Data  Control Language
  • DML - Data Manipulation Language
  • DMV - Dynamic Management Views
  • DTA - Database Engine Tuning Advisor (new in SQL Server 2005, replaces ITW - Index Tuning Wizard of SQL Server 2000)
  • FTS - Full Text Search
  • ISQL - Interactive Structured Query Language
  • MDX - multi-dimensional experssions
  • MSDTC - Microsoft Distributed Transaction Coordinator
  • ODBC - Open Database Connectivity
  • OLTP - Online Transaction Processing
  • sa - system administrator
  • SSAS - SQL Server Analysis Services
  • SSIS - SQL Server Integration Services
  • SSMS -  SQL Server Management Studio
  • SSRS - SQL Server Reporting Services
  • PDS - Physical Design Structures
  • TDS - Tabular Data Stream
  • TSQL - Transact -  Structured Query Language
  • UDA - User-Defined Aggregate (Function)
  • UDT - User Definied Type
To be continued....

Labels: ,

Tweet this | Google+ it | Share on FB

« Home | Next »
| Next »
| Next »
| Next »
| Next »
| Next »
| Next »
| Next »
| Next »
| Next »

»

Post a Comment