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 : How to List All Email Subscription configured in SSRS ?

by nelsonaloor

PracticalSQLDba

Often I used to get request from my business managers to get a list of all subscriptions configured in SSRS...

2012-09-27

14,420 reads

SQL Server: Part 4 : Approaching Database Server Performance Issue

by nelsonaloor

PracticalSQLDba

In the last three parts, we have discussed about different queries that can be used to list the current state...

2012-09-26

1,734 reads

SQL Server: Part 3 : Approaching Database Server Performance Issue

by nelsonaloor

PracticalSQLDba

In the last post, we have discussed the script to list the sessions which are waiting for resource or currently...

2012-09-24

1,154 reads

SQL Server: Part 1 : Approaching Database Server Performance Issues

by nelsonaloor

PracticalSQLDba

When you work as DBA, many people will approach you with a complaint like "Application is taking ages to load...

2012-09-18

1,394 reads

How to Connect PerfMon to a Remote Server ?

by nelsonaloor

PracticalSQLDba

Till now, we do not have any third party tool to monitor the SQL server, but we have implemented many custom...

2012-09-17

4,936 reads

SQL Server : Usage of OVER Clause

by nelsonaloor

PracticalSQLDba

Over clause can be used in association with aggregate function and ranking function. The over clause determine the partitioning and...

2012-09-17 (first published: 2012-09-10)

10,430 reads

Discuss

SQL Server: String Pattern Matching

by nelsonaloor

PracticalSQLDba

It is common scenario that, we might need to extract the data from the SQL server based on some pattern....

2012-09-13

11,641 reads

SQL Server: Understanding GAM and SGAM Pages

by nelsonaloor

PracticalSQLDba

We know that SQL server stores the data in 8 KB pages. An extent is made up of 8 physically contiguous...

2012-09-12

26,367 reads

SQL Server:Output Clause

by nelsonaloor

PracticalSQLDba

Couple of days back, one of my colleague came to me asking for help. He is inserting multiple record from a...

2012-09-09

1,490 reads

SQL Server:Understanding the Data Record Structure

by nelsonaloor

PracticalSQLDba

In our last post, we have gone through the data page structure and we have noticed that there is an...

2012-08-22

7,189 reads

Blogs

Privacy Policy

By Cláudio Silva

We value your privacy. This policy explains what personal data we collect and why. What...

Why use XACT_ABORT?

By hellosqlkitty

This came up one day at my work when a developer was using it....

Using AI for Data Conversion

By Grant Fritchey

I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...

Read the latest Blogs

Forums

Find all records in a table whose values when summed up will equal another value

By kirkdevilliers

I have a list of transactions in a table. Each transaction has a unique...

sp_lock memory leak

By TheRedneckDBA

I spotted this in the release notes for CU17 in SQL Server 2022: KB3616559...

Migration related issue

I migrated DB server from 2017 enterprise to 2019 enterprise. After the migration, every...

Visit the forum

Question of the Day

Browsing for Instances

I have a SQL Server instance that is not listening for connections on port 1433. By default, all ports are locked down on my server, except for the SQL Server port. What can I do to allow users to connect to the instance without knowing the port?

See possible answers