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.

Blogs

Comparing My Current Schema with a Backup with SQL Compare

By

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

Improving Our Conversations

By

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

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

By anug

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