- Each microservice embodies a specific business capability or functionality, ensuring a focused approach.- Microservices operate independently, allowing for flexible and autonomous deployment.- Examples of microservices include User Service, Order Service, and Inventory Service, among others.Database...
May 31, 2024
June 10, 2017
Introduction of Asp.net WEB API
Introduction of WEB API
ASP.NET Web API is a framework for building http based services using .Net Framework. these services reach a broad range of clients, including browsers , mobile devices and desktop applications.
Asp.net web-api is widely used to create Rest full Services but...
June 28, 2016
Convert UTC Time to specific Time-Zone on SQL
Convert UTC Time to specific Time-Zone on SQL
CREATE FUNCTION [dbo].[ConvertDatewithZoneOffset]
(
@DateTimeStamp DATETIME,
@TimeZoneOffset VARCHAR(20)
)
RETURNS DATETIME
AS
BEGIN
RETURN CONVERT(DATETIME,
SWITCHOFFSET(CONVERT(DATETIMEOFFSET,
...
Why is null not allowed for DateTime in C#?
DateTime is a value-type (struct), where-as string is a reference-type (class etc). That is the key difference.
A reference can always be null; a value can't (unless it uses Nullable<T> - i.e. DateTime?), although it can be zero'd (DateTime.MinValue), which is often interpreted as the...
Find dependency of a particular object with all procedures/Objects of a database
There are various methods to finds the dependent objects , there is a system defined procedures sp_depends but it does not give perfect result always as it give results on the basis of creation order, more accurate ways are below
If we need to find paymentdetail table dependency on procedures/objects...
January 22, 2015
Different types of SQL Keys : Key Constraints
Basically only Primary keys and foreign keys are two types of constraints that can be used to
enforce data integrity in SQL Server tables. These are important database objects. Others are the Database Concepts, these are also used to create relationship among different database tables or...
November 5, 2014
Bypass the runonce web page to save Internet Explorer settings
IE7 changes my home page to http://go.microsoft.com/fwlink/?LinkId=74005
Solution 1 :
If Below Registry Exists then Change Values for these Registries to 1
KeyName: RunOnceHasShownKeyType: REG_DWORDKeyValue: 1KeyName: RunOnceCompleteKeyType: REG_DWORDKeyValue: 1
Solution 2 :If Registry not...
November 3, 2014
How to change password of wi-fi Router
Open Internet Explorer and type the 192.168.2.1 (Router Default IP) and press enter.
You will be prompted to login panel, use admin as username and password:
After Login Router DashBoard will open
Go to Wireless...
October 8, 2014
Outlook attachment is not open. Error: Permission not defined
Solution
Outlook 2003
If you are using Outlook 2003, follow these steps:
Click My Computer, and then double-click drive C.
On the File menu, click New, and then click Folder.
Name the folder temp0.
Click Start, click Run, type regedit, and...
September 16, 2014
Get Mobile Number of Sim Card on Android Device
You can use the TelephonyManager to do this:
TelephonyManager tm = (TelephonyManager)getSystemService(TELEPHONY_SERVICE);
String number = tm.getLine1Number();
The documentation for getLine1Number() says this method will return null if the number is "unavailable",...
August 1, 2014
Recover SQL Server Database from Suspect Mode
If your Database goes to Suspected Mode you can try below queries to retrieve the database in normal mode.
Reason for database to go into suspect mode:
1. Data files or log files are corrupt.
2. Database server was shut down improperly
3. Lack...
Subscribe to:
Posts (Atom)