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

Can this be happened? The functions TRY_CONVERT and TRY_CAST have been designed for handling errors and they should return NULL when the...

Let's talk about another Interview Question  related to SQL Server development. This is about one of the aggregate functions that is A...

You may continuously experience the following error with your application; Unhandled Exception: System.InvalidOperationException: Time...

Do you know that you can call set of ODBC Scalar functions inside SQL Server? Yes, it is possible and they can be used with ad-hoc stateme...

SQL Server uses 3 protocols to make the communication between client and the server. Initially there were 4 protocols but now it supports ...

We use either Checksum or Hashbytes  for generating a value for finding changes of records when need to transfer records from one source t...

I had a requirement for getting the record count of all tables in one of client databases that had many tables with over 10 millions recor...

Here is a useful script. If you need to find out tables that have Identity property enabled, you can simply query the sys.tables  Catalog ...

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

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

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

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

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

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