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

If you are interested in #covid-19 statistics, check this #dashboard out. This has been developed using #powerbi, #azuresqldatabase and #az...

This video focuses on sending emails for operations related to Azure SQL databases. Following are discussed and demonstrated; Possibilit...

You know that we can create multiple administrator accounts in SQL Server if it is a on-premises instance or an instance configured in a V...

Unless it is a contained database, we must create a login for connecting with SQL Server in order to access a database. Databases are acce...

Yesterday I wrong a post on splitting string values using an Extended Function. The biggest issue with it was, unavailability in Azure SQL...

Here is the Brain Basher of this week. During interviews, questions on deciding the hosting place for a planned database is very commo...

Will there be differences if I create my Azure SQL Database using Management Studio instead of Azure Portal? Yes, there are. One major di...

Somewhere in 2011, I wrote an article titled Isolation Level in SQL Server that explains different Isolation Levels in SQL Server. It is ...

Has your database been attacked by someone? Most of our applications are data-driven applications and attackers can use various techni...

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

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

We have been implementing on-premises data warehouses for years and everyone is well aware on difficulties-faced at the first phase of the...

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

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

I am sure that everyone is well aware on SELECT INTO statement. This statement allows us to create a table using a SELECT statement just li...

There are two new free eBooks available for downloading those who want to learn Power BI and Azure SQL Database. Here are the links, worth ...

Are you experience this error when trying to connect with your Azure SQL Database? TITLE: Connect to Server ----------------------------...

Once I wrote a post on how to take a copy of Azure SQL Database into on-premise server:  Taking backups of Azure SQL Database and restorin...

Please note that there is an issue with connecting to Azure SQL Server using latest RC3 build. If you are experiencing the following error...