TechBubbles Microsoft Technology BLOG

CategorySQL Server 2008 R2

Sorting Month Name in Date Dimension in SQL Server

 

In order to sort the month name in your date dimension, you need to define an attribute relationship and Sort Order in the Date Dimension. This post discusses about defining a new attribute in date dimension based on existing column in the underlying dimension table.

Step 1: Open the Date Dimension designer then switch to Attribute Relationships tab

SSL Encryption in SQL Server

  This post discuss about security of SQL Server data and  steps required to configure SSL Encryption in SQL Server. There is a feature named Transparent Data Encryption in SQL server 2008 which provides security for static data, what about the data that flows over the network. SSL Encryption can answer this question. What is SSL Encryption? Secure Sockets Layer(SSL) encryption encrypts...

Using Memory Beyond 4GB in SQL Server

  Physical Address Extension (PAE) allows you to use up to 64 GB of physical memory depending on operating system you use. All existing 32 bit processors supports this extension of memory. PAE mode requires an Intel Architecture processor and more than 4GB of RAM. You can configure at two levels to use Memory Beyond 4GB in a 32 bit windows server operating system. Operating System Level...

Analyzing SQL Server Performance using Performance Monitor Counters

This post discusses about using Performance Monitor tool to create a base-line using different performance counters. It also discusses analyzing hardware resource bottlenecks and retrieving performance monitor data in sql server using views. Performance Monitor Tool collects the detailed information of system resources including memory, processor , disk and network.SQL Server 2008 provides...

Creating SQL Server Database Objects Backup using SMO

  This post explains taking the SQL Server Database Objects backup only schema not data in SQL Server 2008 R2. In an ETL server you may come across the situation where you need to change the database objects schema quite frequently especially when data source changes. In this case we may need maintain our schema or take the backup our database objects script some place where we can restore...

Creating Maintenance Plans in SQL Server 2008 R2

    One of the repetitive task that DBA need to perform is create maintenance plan for database. Maintenance plans enables you to automate maintenance activities for a database, backups, db integrity checks and index maintenance tasks. We can easily create a maintenance plan using a wizard in sql server 2008 R2.   You can use the following steps to create a maintenance plan 1...

Creating Maintenance Plans in SQL Server 2008 R2

One of the repetitive task that DBA need to perform is create maintenance plan for database. Maintenance plans enables you to automate maintenance activities for a database, backups, db integrity checks and index maintenance tasks. We can easily create a maintenance plan using a wizard in sql server 2008 R2.   You can use the following steps to create a maintenance plan 1. Select the...

SQL Server Reporting with Analysis Services

    SQL Server Analysis Services is used to present the aggregated data to support analysis, ad-hoc reporting and decision making process. Technically CUBE is used in Analysis Services to build the aggregated data. Once it is build then you can easily navigate and produce reports for business analysis. This post discusses using analysis services in SQL Server Reporting with MDX query...

TechBubbles Microsoft Technology BLOG

Follow me

Archives

Tag Cloud