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

How do you check and see whether you have permission on a specific object and what permission types you have been granted? This requiremen...

I have been using SQL Server Database Mail for sending mails and have used various email providers. However, while troubleshooting and hel...

While discussing with one of my clients, this question raised but I knew that there is no direct way unless we use something related to in...

If you have not changed the default Growth Rate settings in SQL Server files, then the default will be applied. SQL Server 2016 is smart, ...

While discussing with few data enthusiasts, the topic Type of Data Analytics  came up and various types were discussed. There were few arg...

Here is the question of the week. I am sure that you have seen guest  user account in your databases. This week question is based on it; ...

Without noticing, you may experience double-hop  problem with your SQL Server and you may be clueless on it. With this, all you see is, so...

There are few new releases related to Microsoft SQL Server in last few days. Here is the list, get them downloaded as you need and install....

Are you experiencing this error with newly restored database? Cannot execute as the database principal because the principal "abc...

In order to make the database (or table) consistence, one of the integrity types we use is Referential Integrity . It is implemented using...

Interesting question was asked during the user group meetup today and it was about CALs used with SQL Server 2016 Standard Edition. When w...

We archive data when we see that database has many records, they never get updated and they are rarely read. With traditional archiving wa...

You know that SQL Server creates a plan for your query and keeps them in the cache for reusing when it is required. When you make a reques...

Have you seen Warnings  on operators in Query Execution Plans ? Warnings indicate that Query Optimizer has found something that mi...

If you have not read previous two posts related this, please have a look on them first; SQL Server Logical Phases of Query Processing ...

I made a small video that shows Logical Phases of Query Processing and published with the post called  SQL Server Logical Phases of Query ...

We have been writing TSQL codes for a long time but do you know what type of language TSQL is? It is unknown to many or many know the type...

Once I wrote a post titled Enabling Fulltext search in Azure SQL Database discussing Full-Text search in Azure. While using it with one o...

You may experience the below error if you try to connect with latest version of Microsoft Excel using Integration Services; Could not ...

I have been using various third party tools for working with cloud storages and one of the best I have seen is CloudXplorer . It is good a...

Here is how SQL Server process clauses in your SELECT statement;

The Identity property is not something new and it has been widely used with most of table when a surrogate key is required. It can be simp...

When a set of records are being updated, with the default Isolation Level  which is Read Committed , SQL Server makes sure that no one can...

You know that SQL Server uses an Execution Plan for every query you execute and the plan is created using multiple factors. Among the fact...

SQL Server locking mechanism makes sure that database is consistence during a transaction and it makes the database available for as much ...