How to Create Login, User and Grant Permissions in SQL Server
In database environments, data rights assign permissions, and privileges management is essential for preserving security. The article...
top of page
Learn T-SQL
mike92980
- May 6
- 7 min
SQL Server Restore Database From Backup
Can I restore from one SQL Server database version of SQL to another? It is possible to restore a database from one version of SQL Server...
mike92980
- May 6
- 19 min
Instance And Database Settings In SQL Server
SQL Server Instance Settings refer to the configurations that are applied at the server level and affect the behavior of all databases...
mike92980
- Apr 19
- 9 min
Automate SQL database backups, Indexing and DBCC Check DB Using SQL Maintenance Plans
A SQL Server Maintenance Plan is a set of automated tasks that are designed to help manage and maintain a SQL Server database. The...
mike92980
- Apr 17
- 5 min
SQL Instance Aliasing In SQL Server.
A SQL Instance alias is a name that is used to refer to a specific SQL Server instance. It is a user-defined name that can be used in...
mike92980
- Apr 16
- 6 min
SQL Server Error Logs
These logs are important because they enable and provide a detailed record of process events that can be used for troubleshooting,...
mike92980
- Apr 16
- 17 min
Learning About and Implementing Isolation Levels In SQL Server:
SQL Server has your back with various transaction isolation levels. Each level provides a unique balance between consistency and concurrency
mike92980
- Apr 11
- 8 min
Power BI Dashboards vs. Reports – Which One Should You Use?
What is the difference between a Power BI Dashboard and a report When it comes to data analytics, the terms dashboard and report might...
mike92980
- Apr 10
- 8 min
Views in SQL Server
This article provides an overview of the basic views in SQL Server. The way to view definition, create or replace view view or replace...
mike92980
- Apr 9
- 4 min
The SQL Server Query Store
The SQL Server Query Store is a feature introduced in SQL Server 2016 that helps database administrators troubleshoot query performance...
mike92980
- Apr 9
- 5 min
The SQL Server Resource Governor
The SQL Server Resource Governor is available in the Enterprise and Developer editions of SQL Server. It is not available in the...
mike92980
- Apr 9
- 10 min
SQL Encryption
SQL Server Encryption is a feature in Microsoft SQL Server that enables you to encrypt data to protect it from unauthorized access. SQL...
mike92980
- Mar 26
- 14 min
Table Optimization Strategies in SQL Server
Are you looking for ways to improve the performance of your database tables? If so, then table optimization in SQL Server is an important...
mike92980
- Mar 25
- 8 min
A Guide to the System Databases in SQL Server
Blog Introduction: SQL Server is a powerful database system that provides an array of features and capabilities. One of these features is...
mike92980
- Mar 25
- 13 min
Configure A SQL Instance
SQL Server Mistakes to Avoid Blog Introduction: As a database administrator (DBA), there are certain mistakes that you should be aware of...
#6 - Test Environment *
#12 - Delete Command
#13 - Group By - Part 1
#14 - Group By - Part 2
#15 - Looping
#16 - Aliasing In T-SQL
#20 - Stored Procedures
bottom of page