Tips for using views in SQL Server 2012 Keep the indexes on the views as narrow as possible. Because each index takes up disk space try to minimize the index key's size to avoid using sup...

Running Oracle Database on Oracle VM VirtualBox By Yuli Vasiliev This article covers how you might evaluate Oracle Database coming with the Database App Development VM appliance that install...

Designing and Implementing Online Analytical Processing (OLAP) Architecture - (Part 1)   Author: Basit A. Farooq     Editor’s Note: This i...

Tips for using Very Large Databases in SQL Server 2012 Use distributed partitioned views to partition tables horizontally across multiple servers. By using distributed partitioned views you ...

SQL Server index related dynamic management views and functions – (Part 3) By Basit A. Farooq Editor’s Note:  This is the part-3 of this three part art...

SELECT from INSERT, DELETE, UPDATE, and MERGE By Craig S. Mullins   A somewhat under-utilized feature of DB2 SQL provides the ability to SELECT from INSERT, DELETE, UPDATE, and MERGE ...

Tips for using SQL Server 2012 file and filegroups Microsoft SQL Server 2012 introduces many new useful stored procedures, functions and operators. Some actions you can perform without these n...

Tips for Minimizing Deadlocks By Basit A. Farooq The Database servers are configured in such a way that they can service multiple requests from multiple users. Obviously this incr...

Elemental MDX:  MDX Time Series Functions: PeriodsToDate() and OpeningPeriod(), Pt. 2 by William E. Pearson, III In this, the second of a three-part article focu...

XML Support and SQL Server (Part 6) By Basit A. Farooq Editor’s Note: This is the sixth part of my XML support and SQL Server article series. In this par...

Learning SSAS-Part IV: Deploying and Processing a cube Hello and welcome to the fourth part of this series dedicated to learning SQL Server Analysis Services. In the previous articles you lea...

Troubleshooting SQL Server 2012 Integration Services If you have problems with SQL Server 2012 Integration Services (SSIS), review this troubleshooting checklist to find potential solutions. ...

Using External Tables to Invoke Linux Utilities and Hold the Data Received   By Yuli Vasiliev You might use external tables to query operating system data. As a preprocessor program to...

The Public Role – a potential high risk security concern for DBAs   By Basit A. Farooq   In this article, I’ll discuss the security issues associat...

Tips for using SQL Server 2012 User-Defined Functions If you want to invoke a stored procedure directly from a query and this stored procedure returns a scalar value, consider replacing a sto...

External Table as a Data Loading Tool   By Yuli Vasiliev   The external tables feature can be used as a data loading tool – a good alternative to SQL Loader.  &nbs...

SQL Server index related dynamic management views and functions – (Part 2) By Basit A. Farooq Editor’s Note:    This is the part-2 of this this three par...

  Import or Export Files to or from in MSSQL  2005 and above versions. Eli Leiba 03/2013. General Description :   The task of importing or exporting&nb...

Tips for using SQL Server 2012 Join Hints If you want to set any join hints, do not remember to test the query with hint and without the hint and compare results. Because SQL Server 2012 q...

Using OWB to Handle Heterogeneous Data Sources   By Yuli Vasiliev   Being an Oracle database user, you may need, at some point, to access data stored in a remote non-Oracle data...