How to exit from single-user mode in SQL Server database?
Exiting from single-user mode in SQL Server involves resetting the database to multi-user mode. Here’s how to exit single-user mode.
Microsoft
Articles about Microsoft technologies like Windows, SQL server, MS Office, Sharepoint, IIS, Dot Net, etc..
How to group by datetime column without considering time?
Learn how to group datetime data by date without considering the time component in SQL. Discover practical SQL queries using CAST or CONVERT functions for effective data aggregation.
How to decode ASCII to text in C#?
Learn how to decode ASCII to text in C# with an example. Understand the process of converting ASCII-encoded data back into readable text using the Encoding.ASCII.GetString() method.
How to encode a string to ASCII in C#?
In C#, developers have access to a wide range of encoding options, including the popular American Standard Code for Information Interchange (ASCII). In this article, we will see how to encode a string to ASCII in C#.
Advantages and disadvantages of cursors in SQL Server
While cursors can be useful in certain scenarios, they also come with both advantages and disadvantages. Let’s explore the advantages and disadvantages of cursors.
What is hosts file and how to use it to override DNS?
Discover the functionality of the hosts file and learn how to effectively override DNS using this comprehensive guide. Gain control over DNS resolution with the hosts file to customize domain mappings on your machine.
In SQL Server how to backup the database to a SQL script file?
To backup a SQL Server database to a SQL script file, you can use the SQL Server Management Studio (SSMS). Here is the step-by-step instructions.
IIF vs CHOOSE in SQL Server
IIF and CHOOSE are two logical functions in SQL Server used for different purposes. Here we will see the competition of IIF vs CHOOSE.
How to insert multiple records with a single SQL query?
Here is a simple tip to insert multiple records in an SQL Server database table with a single SQL insert query.
How to drop all the tables from a database in SQL Server?
In rare situations like database level permission issues, you may need to drop all the tables from a SQL Server database and recreate them.
How to use CHOOSE in SQL Server
CHOOSE is a Transact-SQL function used to return a single value form a list based on the specific index. Let’s see how to use CHOOSE function.
How to make SQL script to sleep?
In this article, we will see how to make an SQL Script to sleep for some time with examples.
The Benefits and Drawbacks of .NET Development
This article intends to provide helpful information to make your search for a suitable development environment easier by describing the benefits and drawbacks of using .NET as a software development platform.
How to prevent connection pool problems between ASP.NET and SQL Server?
If you are not taking precautions while using connection pooling, you may encounter errors. Here are a few of the common errors and ways to prevent connection pool problems.
What is SQL, and why is it important to learn it?
What is SQL, and why is SQL important? let’s figure it out. All valuable information is organized and entered into databases managed by database management systems and the SQL language.
How to calculate mode in C#?
Here is the sample code to calculate mode in C# for a set of numbers in an array. This method will get you single mode or multi modes.
How to calculate mean In C#?
It is easy to calculate mean in C#, as arithmetic mean is just the average of the collection of numbers. Here is the sample code.
How to calculate median in C#?
In this article we will see how to calculate median in c# .Net by coding the median algorithm by yourself and by using a 3rd party library.
How to calculate statistical mode in SQL Server?
Let us see with example on how to calculate the mathematical statistical mode in SQL Server.
How to calculate mean in SQL Server?
Here you will see with a simple example on using an existing TSQL function to calculate the mean in SQL Server.