learning from experience
The Identity property creates an incremental value for the specified column automatically, which is why it is widely used by developers when they designed the table and a primary key – an identifier column. This is the Common Mistakes in SQL Server Part 2
In this series of articles I will be sharing the common mistakes in SQL Server. I am certain that this is going to be very interesting read, here is the Common Mistakes in SQL Server – Part 1.
In this article I will share the Microsoft SQL Server Security Checklist that I have used for many of my clients to help them achieve PCI compliance. This can be used as SQL Server Security Best Practice Checklist as well
Security! This is the word that comes to mind of every concerned person when it comes to storing, accessing, and sharing the data and database or database server. In this article I share some of
I have seen this question many a time that people have asked “The Cloud or On-Premise – is it a go or no go?”. This
This weekend I was working, as usual, holding the on-call and listening to my favorite singer Kishor Kumar. And, my friend Rakesh call me in
Last year, September 2020 we had organized 1st yearly event and we named it Surat Tech Talk. That event was a great success. This year,
I have a good news to share with you all. This year, 1st of August 2021 I have received an email that surprised me. The
Recently I have faced a very interesting issue. A good friend of mine and my batchmate Rakesh called me this morning. He told me that
I have the privilege to work on Saturday and Sunday, holding a pager during my shift hours. I get most of the blog ideas during
As usual, I was working on my weekend on-call and I have had an alert. Our monitoring system has reported a message printed from the
One of my friends client has got an issue with his SQL Server. A weekly database integrity check has reported a corruption for one of
