VARCHAR and NVARCHAR Data Types in SQL Server
Relational databases represent an organization’s data in tables that use columns with different...
SQL Server System Databases Maintenance
SQL Server Installation by default creates several system databases per instance to maintain and administer that instance. In this article,...
How to Change Server Level Collation of Running SQL Server Instance
In my previous article I have explained the basics of SQL Server Collation. I would suggest you first read that article (if you haven’t...
SQL AS: Usage, Examples, and How it Can Benefit You Best
What is the AS statement in SQL? The AS keyword in SQL is used to create a temporary alias for a...
How to Change Database Collation in SQL Server: Step-by-Step Guide
When you develop an application or write a code in the SQL database system, it is crucial to understand how data will be sorted and...
SQL Server Transactional Replication Issues
We started talking about SQL Server Transactional Replication issues earlier. Now, we are going to continue with a few more hands-on demos...
Oracle Live SQL: Pros and Cons, and What You Miss Out if You Don’t Try It
Oracle Live SQL is a new feature in Oracle Database 12c that allows the developers to easily create...
How to Get SQL Server Statistics Information Using System Statistical Functions
Often, we need to gather system statistics regarding running SQL Server Instances, such as the number of total connections attempted to SQL...
SQL Server RAISERROR Statement with Simple Examples
The SQL RAISERROR statement is used to send a custom message to the client application. It also can be used to debug the application and...
Stored Procedure to Delete Duplicate Records in SQL Table
Sometimes during our run as DBAs, we come up across at least one table that is loaded with...
