SQL Server System Databases Maintenance
SQL Server Installation by default creates several system databases per instance to maintain and...
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 table or column. This alias can be used...
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...
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 and run SQL scripts against Oracle...
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...
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 duplicate records. Even if the table has a...
SQL VARCHAR Data Type Do’s and Don’ts for Faster Databases
This post has “strings attached: for a good reason. We are going to explore deep into SQL...
