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

Everybody says that they all have business intelligence applications. Everybody says that they develop business intelligence applications, ...

Every company implements a business intelligence solution for tracking and improving the business performance through reporting and analys...

Well known three functionalities provided by a business intelligence solution are; Drilling down, Drilling through and Slicing and dicing....

In order to improve the loading performance, specifically when a data warehouse or a large table is loaded, it is recommended to disable c...

Everyone asks how to check whether the value is NULL and replace it with a different value if it is NULL because it is something that we c...

We heavily use Dynamic Management Views and Functions for retrieving insight of inner operations of SQL Server and they are very useful. T...

As a part of modulerizing business logic, we create stored procedures and functions with SQL Server databases and in most cases, stored pr...

Let's talk about memory-optimized tables as a part of Brain Basher in this week. This question was raised during one of my workshops an...

We know that SQL Server requires an additional file group that is marked as  MEMORY_OPTIMIZED_FILEGROUP  and a data file associated with i...

While I was writing a code on backing up operation for SQL Server 2016, I noticed that there is an issue with partial backup. As per docum...

I have written a post tilted  When was my SQL Server Database last accessed? that talks about how to find the last accessed date and time ...

You have installed SQL Server and it is up and running without any issue. Later, you need to change some permission given to either SQL Se...

Backup compression is not something new to SQL Server, it has been there with few versions. However, many are unaware on setting the defau...

Determining the backup strategy for a SQL Server database is not an easy task as there are many things to be considered. As per my experie...

SQL Server Agent Jobs are commonly used for automating administrative tasks and other routine tasks. For creating a job as you need, you n...

Who tried to access my Azure SQL Database? Were they succeeded? Can I get more details on attempts? If you are maintaining a Azure SQL...

Initially I thought that runaway   query  is another name for ad-hoc  queries but it is NOT. It actually refers long running queries that...

Unfortunately, many developers are unaware of available templates. SQL Server provides templates for almost all operations you can perform...

Have you noticed two new database roles appeared in master database? You might have, you might have not, because these two appear only wit...

SQL Server 2016 introduced Dynamic Data Masking for obfuscating certain values in records, not exactly as a security measure but for hidin...

You are the Database Administrator and you maintain a database with following characteristics; Database contains sensitive data. Datab...

It was bit funny, could not figure out immediately what has happened, the records related to Audit  are saved with wrong data and time. ...

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...