Dinesh's Blog :::: Being Compiled ::::

Once I wrote a post on Hortonworks HDP Sandbox ( Looking for a Hadoop Cluster for testing? Let's configure Hortonworks HDP Sanbox ) wh...

I noticed that values of a column related to newly inserted records which is an identity property enabled column in one of the tables, sud...

Among multiple methods given for securing data stored in the SQL Server database, even though the latest one which is Always Encrypted  is...

Assume that you use SQL Server 2016 and trying to create a  Symmetric Key or Asymmetric Key  for encrypting data. If you try use an algori...

He is the Brain Basher or the interview question of the week. This is something every database engineer should know and it is not limited ...

Once I wrote a post on SQL Server Template Explorer   that describes available TSQL templates and how they can be used. Just like template...

Do you know that you can add, specifically surround your code with BEGIN/END, IF, and WHILE  statements using a menu item without writing ...

This is something I had to use with one of my projects today. As a part of the implementation, an average value had to be rounded off to 0...

If you are 100% sure that the job configured with SQL Server Agent has been executed successfully but you do not see the execution record ...

While designing my new database in Azure as an Azure SQL Database, was thinking to manage the cost for the storage, hence thought to apply...

I have been blogging for years but I think that the most important and success year is 2016. I have made 171 posts in 2016 based on my e...

Have you ever deleted a database accidentally? If you have done, then you know very well that how it makes you uncomfortable :). If you ar...

A column like email address  in en entity like Customer or Employee is always set with an UNIQUE Constraint  to make sure that no duplica...

There are set of server level configurations related to optimizing SQL Server but not all guarantee that the result will be as expected an...

I have been continuously hitting with this when the Reporting Services portal is opened first time; Could not load folders contents ...

Although we have a new version of SQL Server 2016, multiple file upload facility is still not given as a built-in function and it annoys u...

I have written two posts on SQL Server Error Log;  How to delete current SQL Server error log? My current log is in GBs and  Reading SQL ...

Thought to share a specific conversation of one of the interviews did last month on a DBA role. The interview was done over the Skype call...

While coding on my new project, wanted to show the duration between two DateTime values as a Time Span like Remaining Days : Remaining Hou...

In order to access Azure SQL Server databases, firewall rules have to be set at either server level or database level by adding client IP ...

We use Transparent Data Encryption (TDE) for protecting our databases, making sure that no one can get our databases added to a different ...