I have total of 11 years of IT experience with Application development, Database Development and Database Administration. I have worked with different version of SQL server from 7.0 to 2008.Started my carrier as VB ,VC++ and database developer in a banking sector for implementing their core banking solution. Currently working as Database Administrator with wide knowledge in performance tuning, high availability solution, troubleshooting and server monitoring. This blog is my humble attempt to share my knowledge and what I learned from my day to day work.

Understanding the concept of SQL Server Failover Cluster

by nelsonaloor

PracticalSQLDba

Before getting hands on experience in SQL server on failover cluster , I used to read many article about failover clustering. Unfortunately...

2012-03-14

17,336 reads

Memory configuration in SQL server and break up of memory utilized by SQL server

by nelsonaloor

PracticalSQLDba

In this post I would like to explain memory configuration option and memory utilization pattern in SQL server.I have seen...

2012-03-11

3,725 reads

How to log off remote desktop users from a remote machine ?

by nelsonaloor

PracticalSQLDba

When you try to log on to a remote server on emergency to perform some task , it may throw an...

2012-03-06

8,193 reads

Resource Governor Configuration

by nelsonaloor

PracticalSQLDba

Resource Governor(RG) is a technology which introduced in SQL server 2008 to manage the CPU and Memory resource that a incoming session can...

2012-03-04

4,571 reads

How to setup a task to delete the old backup files or log files from the server ?

by nelsonaloor

PracticalSQLDba

Cleaning up the servers disks on daily basis is very important task for smooth functioning of servers.We have seen many...

2012-02-27

1,401 reads

How to remove new line character from string using SQL ?

by nelsonaloor

PracticalSQLDba

In a varchar column some of the entries were showing space in the left side and even after using the...

2012-02-26

9,137 reads

Blogs

Comparing My Current Schema with a Backup with SQL Compare

A customer asked if they needed to restore a database from backup to compare...

Improving Our Conversations

By Brian Kelley

If we aren't having the same conversation, we aren't going to be heard. That's...

How Do You Pick Events in Extended Events?

By Grant Fritchey

A while back I wrote about using AI to explore why people are not...

Read the latest Blogs

Forums

create a table with data capture for next 3 years

Hello, I would like to build a table capturing data starting from 1st day...

Is GenAI Coming Faster Than You Think?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is GenAI Coming Faster Than...

Local Storage Options

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Local Storage Options

Visit the forum

Question of the Day

Local Storage Options

I'm setting up a SQL Server 2019 instance and we are planning on using SMB storage for our database files. However, the file share isn't ready, so the idea is to use the \127.0.0.1dbfile as the location to start and then move these files to the remote server. Can I do this?

See possible answers