-
Modal Popup Window in Blazor WebAssembly
Introduction Sometime in our web application we may need to display contents in Popup Window. A popup window is a web browser window that is smaller than standard windows and without some of the standard features such as toolbars or status bars. Popups are one of the trickiest effects in web development, but in Blazor WebAssembly we can create it in…
-
Difference between CURRENT_TIMESTAMP vs GETDATE() vs SYSDATETIME() vs GETUTCDATE() in SQL Server
Introduction In this article, we will discuss the difference between CURRENT_TIMESTAMP , GETDATE() , SYSDATETIME() GETUTCDATE() in SQL Server. Even though all four SQL Server function returns the current date-time in SQL Server, there are some subtle differences between them. The main difference between GETDATE() and SYSDATETIME() is that GETDATE returns current date and time…
-
Change Schema Name Of Table In MS SQL Server
Introduction In this article we will learn the trick to Move a Table from One Schema to Another Schema. Sometimes accidentally we might have given the incorrect name of a schema for the table while creating. But we can move the newly created table from one schema to another schema. Syntax Example Here Details is…
-
What is Blazor and How does it works
Introduction In this article, we will discuss about the amazing technology called Blazor. Personally after working on this amazing technology, it increased my development works so much productive and interesting. In this article, we will cover the overall features of Blazor like as, What is Blazor Why should we use Blazor Getting started with Blazor…
-
5 Tips to Improve SQL Query Performance
Introduction In this article, I will share few SQL Tips for Boosting our SQL Query Performance. We nobody likes delay in response, right !!. Here are some simple changes that we have to make our query perform faster. The following is the flow of this write-up, Use Schema Name Always Select ONLY required Columns Use…
-
Identifying object dependencies in SQL Server using SP_DEPENDS
Introduction When developing components for SQL Server one change may affect another database object. Finding these dependent objects should be straightforward, but in most cases it is not as easy as we would think. There are several methods of getting this information, in this article we will have a look using SP_DEPENDS a System Stored Procedure.…
Subscribe
Enter your email below to receive updates.
