SQL Server 2008 R2 Archives

Sorting Month Name in Date Dimension in SQL Server

August 25, 2012

SQL server, SQL Server 2008 Analysis Services

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…

SSL Encryption in SQL Server

July 2, 2012

Kalyan Bandarupalli

SQL server, SQL Server 2008 R2

No Comments

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…

Using Memory Beyond 4GB in SQL Server

May 27, 2011

Kalyan Bandarupalli

SQL server, SQL server 2008

No Comments

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…

Analyzing SQL Server Performance using Performance Monitor Counters

May 25, 2011

Kalyan Bandarupalli

SQL server, SQL server 2008, SQL Server 2008 R2

No Comments

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…

What is new in SQL Server Code-Named “Denali”?

May 23, 2011

Kalyan Bandarupalli

Denali, SQL server, SQL Server 2008 R2

2

This post just re-caps the T-SQL features that introduced in SQL Server 2008 and discusses the new T-SQL features in Microsoft SQL Server next version code name “Denali”. Actually there are not any T-SQL features in SQL Server 2008…

Creating SQL Server Database Objects Backup using SMO

May 22, 2011

Kalyan Bandarupalli

SQL server, SQL server 2008, SQL Server 2008 R2

1

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…

Creating Maintenance Plans in SQL Server 2008 R2

March 14, 2011

Kalyan Bandarupalli

SQL server, SQL server 2008

No Comments

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…

Creating Maintenance Plans in SQL Server 2008 R2

March 14, 2011

Kalyan Bandarupalli

SQL server, SQL server 2008

3

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…

Monitoring running processes in SQL Server 2008 R2

March 3, 2011

Kalyan Bandarupalli

SQL server, SQL server 2008, SQL Server 2008 R2

No Comments

You can view the current connections and processes that running on a sql server instance in two ways Using Activity Monitor Using T-SQL statements Monitoring Process in Activity Monitor To open the Activity Monitor in SQL Server Management Studio…

SQL Server Reporting with Analysis Services

March 1, 2011

Kalyan Bandarupalli

SQL server, SQL Server 2008 Analysis Services, SQL Server 2008 R2

1

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…