Standard Members Archives - Page 94 of 110

Standard Members

Database Administration in an Increasingly Complex World

by Craig Mullins

Database Administration in an Increasingly Complex World by Craig S. Mullins The Database Management Systems we use every day are becoming more and more complex – there can be no denying this basic fact of life. Whether you are using DB2 or SQL Server or Oracle or any other popular DBMS, each and every new version adds new features, functionality,...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

SQL Server 2012 Linked Servers Optimization Tips

by Alexander Chigrik

SQL Server 2012 Linked Servers Optimization Tips Try to avoid the ad hoc queries that use the OPENROWSET or the OPENDATASOURCE functions to access remote data. Create a linked server and perform a linked server’s query instead of using an ad hoc query with OPENROWSET or OPENDATASOURCE functions. Using the linked server’s queries to access remote data is more efficient...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Elemental MDX: MDX Time Series Functions: PeriodsToDate() and OpeningPeriod(), Pt. 2

by William Pearson

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 focusing upon the PeriodsToDate() and OpeningPeriod() time series functions, we will continue to expose member and set functions that we can use to perform analysis within the context of time. As we discussed in Part 1,...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

XML Support and SQL Server (Part 6)

by Basit Aalishan Masood-Al-Farooq

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 part, you will learn about the XML primary indexes and secondary indexes. XML indexes As we all know that XML query processing is resource-intensive, because SQL Server parses the XML instance...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Learning SSAS-Part IV: Deploying and Processing a cube

by Kautuk Pandey

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 learnt the basics of Analysis Services. I talked about data sources, data source views, diagrams, calculated columns etc. before actually building an OLAP cube based on a star schema using...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2012 Integration Services

by Alexander Chigrik

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. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 Integration Services bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the...

Already a member? Log in here

Continue Reading →

Oracle Pro Members Standard Members

Using external tables to invoke Linux utilities and hold the data received

by Yuli Vasiliev

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 be used in your external table, you might create a shell script calling a Linux utility, such as ls, df, or ps. Moreover, you can pass arguments to the utility...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

The Public Role — a potential high risk security concern for DBAs

by Basit Aalishan Masood-Al-Farooq

The Public Role – a potential high risk security concern for DBAs By Basit A. Farooq In this article, I’ll discuss the security issues associated with the public database role, and how you can quickly find privileges granted to the public database role in each database. Finally, I’ll discuss how you can properly revoke the privileges granted to public database...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Tips for using SQL Server 2012 User-Defined Functions

by Alexander Chigrik

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 stored procedure with a scalar user-defined function. A stored procedure cannot be invoked from the SELECT statement, but if you need to invoke some code inside the query, try...

Already a member? Log in here

Continue Reading →

Oracle Pro Members Standard Members

External Table as a Data Loading Tool

by Yuli Vasiliev

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. You can create the external table with the SQL CREATE TABLE…ORGANIZATION EXTERNAL statement. Before you can do that, though, you have to set up a directory where the external table data...

Already a member? Log in here

Continue Reading →