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.

SQL Server: Understanding the Data Page Structure

by nelsonaloor

PracticalSQLDba

We all know very well that SQL server stores data in 8 KB pages and it is the basic unit...

2012-08-20 (first published: 2012-08-12)

8,752 reads

SQL Server : Implementation of Table Valued Parameter (TVP)

by nelsonaloor

PracticalSQLDba

Some time there will be situation in application , where a
grid is populated with data and user has option to edit...

2012-08-09 (first published: 2012-08-01)

6,333 reads

SQL Server: List Explicit Permission on Database for Login and Database Role

by nelsonaloor

PracticalSQLDba

As part of security audit of login's, we have discussed earlier about the orphan users , listing server level and database level role...

2012-08-07

5,491 reads

SQL Server : Lost all Administrator Account in SQL Server and Forgot sa Account Password

by nelsonaloor

PracticalSQLDba

What will happen if you lost all your administrator account by mistake ? As per the best practice you have disabled...

2012-08-06

7,986 reads

SQL Server: How Recursive Common Table Expression (CTE) Works ?

by nelsonaloor

PracticalSQLDba

Last Friday evening, I forced to look into a procedure which is using Recursive Common Table (CTE) . The procedure was...

2012-08-06

12,279 reads

SQL Server : List Login's Database and Server Level Role Permission

by nelsonaloor

PracticalSQLDba

In my last post, we have discussed about the orphaned users and fixing the orphaned users. The next step in...

2012-08-05

10,513 reads

SQL Server : Fixing the Orphaned Users

by nelsonaloor

PracticalSQLDba

In my last post , we have discussed about orphaned uses and how to find out the orphaned users. In this...

2012-08-02

1,435 reads

SQL Server:Finding the Orphaned Users

by nelsonaloor

PracticalSQLDba

Orphaned user is a common problem in SQL server world.When I was working on internal security audit of our production...

2012-08-02

1,712 reads

SQL Server : Dedicated Administrator Connections

by nelsonaloor

PracticalSQLDba

Think about a scenario : People are complaining about your production database server.Many users are getting continuous time out error. Rest...

2012-08-01 (first published: 2012-07-30)

3,738 reads

Windows Cluster: Moving Quorum Disk to Another Node

by nelsonaloor

PracticalSQLDba

In my earlier post I have explained about various quorum settings available in Microsoft windows 2008 cluster environment. While we plan to...

2012-07-23

15,382 reads

Blogs

The Benefits of Teaching

By Brian Kelley

Even preparing for a class or seminar with set materials takes a lot of...

Power BI, Excel, OneLake – Dreams Do Come True!

By DataOnWheels

I can’t believe it’s finally here! A way to have Excel live in OneDrive...

The Book of Redgate: What Our Staff Says

This image is from 2010, and it goes along with my last post of...

Read the latest Blogs

Forums

Deny Connect problem

By Brandie Tarvin

I have a login I need to deny connect to on a server, but...

Website Stability 2025/12/05

By Steve Jones - SSC Editor

All week we've had issues with the site being up and down. There's been...

403 Forbidden

I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...

Visit the forum

Question of the Day

Fabric Mirroring

In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?

See possible answers