learning from experience

Blog

Common Mistakes in SQL Server – Part 2

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

Read More »

Common Mistakes in SQL Server – Part 1

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.

Read More »
How to Secure SQL Server
Administration
Hemantgiri Goswami

SQL Server Security Checklist

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

Read More »
How to Secure SQL Server
Administration
Hemantgiri Goswami

How to Secure SQL Server

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

Read More »
Data Platform MVP
News
Hemantgiri Goswami

Data Platform MVP

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

Read More »