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

Few days back, I wrote a post titled as  SQL Server Default and Rule objects - Should not I use them now? that discussed two objects that...

While we were discussing on data types to be used and null-able columns, a question was raised, asking whether the space is used for NULLs...

Here is a modern interview question on SQL Server. In addition to general questions on administration and maintenance, Azure based questio...

In order to make sure that the database contains high quality data, we ensure data integrity with our data that refers to the consistency ...

Temporal table was introduced with SQL Server 2016 and it is designed to capture and store changes of data in tables. In other words, simi...

When we have to store a datatime value (or date), in most cases, application accepts the value as a datetime and send the value to SQL Ser...

Fill Factor is a setting that uses with Indexes for determining how much free space remains on each leaf-level page for future operations ...

Have you faced this? Assume that you have created a Sequence object for generating values sequentially for tables which data type is set a...

Temporary tables are nothing new and we have been using this for long time. There are two types of temporary tables; Local that starts wit...

I had a requirement today to change the schema of set of tables to new schema but I did not find a direct method to change the schema of a...

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

As a part of my presentation, I had to show the integration between Azure Data Lake Store (ADL) and Azure SQL Data Warehouse (Azure DW), h...

Let's talk about something common for all database management systems without talking something specific to SQL Server. This is the in...

Microsoft has made the latest version of Azure Feature Pack for Integration Services (SSIS) and it is available for downloading. This was ...

While trying to create a new SSIS project with default values for Project Name, Location and Solution Name , I experienced the following l...

When there is an updated data set that needs to be sent to a Stored Procedure for updating all records in the data set, what most do is, i...

If you need to execute a Stored Procedure  that implemented with varchar(max) parameter, using .Net Application , how do you set the size ...

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

Challenges are interesting and finding various ways to solve is a thrilling adventure. One of the codes I had to write today was, spli...

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

I was confused with this too, but added the most common one to my slides when presenting my session;  Getting Ready for Azure SQL Database...

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