Pro Members

Pro Members SQL Server Standard Members

Learning SSAS-Part II: Data sources, Data source views

Learning SSAS-Part II: Data Sources, Data Source Views Welcome to the second part of the Learning SQL Server Analysis Services series. In the first article of the series you learnt the basics of business intelligence and data warehousing. You also understood about various terms like cube, dimension and facts. Now it is time to use this understanding and apply it...

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

DB2 SQL: Stages 3 and 4

DB2 SQL: Stages 3 and 4 By Craig S. Mullins All good DB2 developers and DBAs know about Stage 1 and Stage 2 predicates, right? But have you ever heard of Stage 3 and Stage 4 predicates? Well, you’re about to! First of all, let’s do a quick review to catch those readers who don’t know what Stage 1 and...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Are your employees professionally engaged?

Are your employees professionally engaged? How can you tell if your employees are engaged and motivated? How would you motivate someone who’s driven by "Identity and Purpose"? Professional development series This is Laura Lee Rose, a business and life coach that specializes in professional development, time management, project management and work-life balance strategies. In my GoTo Academy: Soft Skill Tools...

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

Working with OData Protocol

With the rise in the availability of data, it is extremely important that we keep our data in a structured format as much as possible. Whether we choose to work on a mainframe, a mini, a server farm or a PC, a standardized API for dealing with the data in a structured format is needed. If the data is relational,...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting problems with SQL Server 2012 cursors

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

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.
Log In Register
Pro Members SQL Server Standard Members

Partitioning Relational Data – (Part – 2)

Partitioning Relational Data – (Part – 2) By Basit A. Farooq This is the second part of the three part article series on partitioning relational data. In the first part of this three-part article series on partitioning relation data, I started the article by giving an introduction to partition relational data along with the reasons why you might want to...

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.
Log In Register
Development Pro Members Standard Members

Implementing a Custom Output Cache Provider in ASP.NET 4

Introduction Initially the performance of the ASP.NET applications was a serious concern for web application developers. However many improvements have come in place over the time. This is evident in the newer versions of the .NET Framework. The IIS improvements also provide a better support to the application pools and so does the IIS compressions, etc. The use of CACHE...

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.
Log In Register
Pro Members SQL Server Standard Members

Tips for using SQL Server 2012 data types

Tips for using SQL Server 2012 data types Use tinyint data type, if you need to store integer data from 0 through 255. The columns with tinyint data type use only one byte to store their values, in comparison with two bytes, four bytes and eight bytes used to store smallint, int and bigint values accordingly. For example, if you...

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.
Log In Register
Pro Members SQL Server Standard Members

Learning SQL Server Analysis Services: Part 1- Introduction

Learning SQL Server Analysis Services: Part 1- Introduction I recently decided to write about SQL Server Analysis Services and it didn’t take me long to realize that it will be a lot better to write a series of articles rather than making a mess of it in an all-in-one article. So, I am going to begin the series with an...

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.
Log In Register
Pro Members SQL Server Standard Members

Addressing Security Issues In Windows Server 2008 R2

In this article we will discuss the security issues in Windows Server 2008 R2 OS and the mitigation strategies. Windows Server 2008 RC was released for manufacturing on February 4, 2008 and the official release came on February 27, 2008. Windows Server 2008 RC 2 was released on July 22nd, 2008. After the success of Windows Server 2003, Windows Server...

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.
Log In Register