MSSQLTREK

Clustering

Installing SQL Server 2008/2008R2 Failover Cluster- Part6

Published by

sreekanth bandarla

on

August 11, 2011

In part5 of this series I’ve shown you how to create a windows cluster. In this part of this Series, let’s proceed further installing and configuring Active-Passive configuration of your SQL Cluster. Before proceeding any further, let me tell you, I’ve created 2 domain accounts called “sqldbengine” and “sqlagent” in…
Continue reading →: Installing SQL Server 2008/2008R2 Failover Cluster- Part6
Clustering

Installing SQL Server 2008/2008R2 Failover Cluster- Part5

Published by

sreekanth bandarla

on

August 9, 2011

In part-4 , I’ve covered how to configure SAN using Starwind software and we’ve successfully attached our LUNS to Node1. In this part of the series, let’s Install Windows cluster. Before proceeding any further, let us initiate ISCSI service on Node2 as well and add our SANDC machine as portal…
Continue reading →: Installing SQL Server 2008/2008R2 Failover Cluster- Part5
Configuration

SQL Server Default Ports

Published by

sreekanth bandarla

on

August 9, 2011

Most of the times…We, the DBA’s are concerned about the TCP port which SQL Sever is running under and UDP Port under which Browser service is running under. So…what about the rest of the SQL Services? What is the Def port for SSIS? How about SSAS? Thought of keeping all…
Continue reading →: SQL Server Default Ports
SQL Denali CTP3

Restoring a Database-SQL Server DENALI SSMS

Published by

sreekanth bandarla

on

August 6, 2011

Today i was playing with SSMS in Denali and found few Very Very Interesting enhancements with Restore Task. Let me show you what i’m saying…. Let’s play with Adventureworks Database for demo purpose. FYI I’ve a folder on my D$ where i placed all my Full, Diff and T-Log backups for this database. First,…
Continue reading →: Restoring a Database-SQL Server DENALI SSMS
SQL Denali CTP3

SQL DENALI SSMS – Few Interesting Facts/improvements.

Published by

sreekanth bandarla

on

August 5, 2011

This DENALI version of SQL Server is really driving me crazy with all the cool features/enhancements and even few funny things which you can do using your Management Studio!! Am getting soooo addicted to it:) Let me ask you something. How many times do you open your Browser while you…
Continue reading →: SQL DENALI SSMS – Few Interesting Facts/improvements.

Howdy!

Welcome to MSSQLTREK, my little corner of the internet where I geek out about SQL Server, databases, and all things cloud. This blog is my space to share lessons learned, cool tips, real-world troubleshooting stories, and the occasional deep dive into data and performance. Whether you’re a fellow Cloud Architect, DBA, Developer, or just cloud-curious, come along for the ride — let’s explore, optimize, and build awesome data solutions together!

Recent posts

Let’s connect

Join the party!

Stay updated with my posts…