Standard Members

Development Pro Members Standard Members

New features and enhancements in Visual Studio 2013

by

New Features and Enhancements in Visual Studio 2013 You asked and Microsoft responded. And, responded with a bang! Confused in these twist of sentences? Relax! Microsoft has just come up with the Preview Release of the latest version of its world class development environment. Yes! It’s Visual Studio 2013. There have been many new advancements (new features and extended features...

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

Designing and Implementing Online Analytical Processing (OLAP) Architecture – (Part 2)

by

Designing and Implementing Online Analytical Processing (OLAP) Architecture – (Part 2) Author: Basit A. Farooq Editor’s Note: This is the two part article series on designing and implementing online analytical processing (OLAP) architecture. In the part-1 of this article series, you learned OLAP database design, options for data warehouse schema design, and key considerations for designing relational data warehouse schema...

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

Troubleshooting problems with SQL Server 2012 cluster

by

Troubleshooting problems with SQL Server 2012 cluster If you have problems with SQL Server 2012 cluster, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 cluster bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time this...

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

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

by

Elemental MDX: MDX Time Series Functions: PeriodsToDate() and OpeningPeriod(), Pt. 2 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, many business requirements revolve around...

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

Understanding Data Normalization

by

Understanding Data Normalization Author: Basit A. Farooq Introduction Normalization, which is the key part of the OLTP databases logical design process, is a design requirement for OLTP databases. Normalization refers to a process used to design relational database tables. Its objectives include minimizing the duplication of information within OLTP databases, as well as reducing the overall size of databases and...

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 →
Oracle Pro Members Standard Members

Reporting on Sparse Date Data

by

Reporting on Sparse Date Data By Yuli Vasiliev You may need to generate a row per hour within a certain day or generate a row per day within a certain date range. Often you need a report showing every date/time position within the entire range, regardless of whether there was an activity on a particular day or hour, or not....

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

Tips for using alerts in SQL Server 2012

by

Tips for using alerts in SQL Server 2012 SQL Server writes the events to the Windows Application log. SQL Server Agent checks the Windows application log for SQL Server events. An alert is an automated response to events raised by SQL Server. When an event occurs, the SQL Server Agent checks if the appropriate alert exists and if so perform...

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 →
Oracle Pro Members Standard Members

Using 11gR2’s DBFS Database File System

by

Using 11gR2’s DBFS Database File System By Yuli Vasiliev The Oracle Database File System (DBFS) is an Oracle Database 11g feature providing a standard file system interface to store and access files within the database. The files are stored in a database table as SecureFiles LOBs. An important point to note here is that a DBFS file system is mounted...

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 →
1 … 88 89 90 91 92 … 110