How to Enable ‘sa’ Login in SQL Server
If you select Windows authentication mode during SQL Server installation then ‘sa’ login is not enabled and you have to enable it manually if you want to use it. Due to security reasons it...
Category: Articles
SQL Server Authentication Modes
Authentication is the process of verifying the credentials and if it is correct then allowing to access the database and its components. Only valid identity will be granted the access to the database server....
SQL Server Recovery Models Overview – Simple, Full, Bulk-logged
835viewsRecovery model plays very important role when it comes to data recovery or to minimise data loss. You need excellent understanding of your business requirements and importance of data. Depending on scenarios you have to decide whether you...
How to Set Backup Compression in SQL Server
Microsoft has introduced backup compression feature from SQL Server 2008. This feature is very useful to save the time, reduces device I/O and storage cost and it is also a good backup strategy option. You...
How to Create Database in SQL Server
You can create database by SQL Server Management Studio (SSMS) or by T-SQL both methods are quite simple and takes very less time to create. But before creating any database you must analyse your...
Introduction to System Databases – master, model, msdb, tempdb and resource
301viewsYou may have observed after installing SQL Server that some databases are automatically created under system databases node. These are five system databases as master, model, msdb, tempdb and resource. Resource database is hidden...
