Go Back To Category List
[Databases]
Current Category Entry
Go Back To Category List
[Databases]
SQL Server
SubCategory Entry Date: May 18,2022 @ 02:26:36 / Last Updated On: May 18,2022 @ 02:26:36
Working with data is an essential part of keeping information stored in a safe environment which allows for fast retrieval.

Microsoft® SQL Server© is the industry standard for fast and reliable storage of your customer's critical data.

If it were not for databases, every page you visit online would be an actual page stored on a server's hard drive. The performance would suffer significantly, and the space required to store all the individual pages would be huge. Could you imagine just for one second, a website such as Facebook® having all their pages stored on hard drives? You think their data centers are massive now. They would be even bigger and would have more of them.
  1. Code Articles
  2. Create a Database for Production Servers with Unicode Character Support
    Create a Database for Production Servers with Unicode Character Support.
  3. Create a Database
    Create a Database for learning and testing code before production.
  4. Check if all AOAG Members are in Synchronous mode, and have automatic failover set
    The primary use of AOAG is for syncing multiple SQL Server instances together into a Failover safe environment.
  5. SQL Server How to get the number of Characters from a string in a column
    How do you count the number of characters in a SQL Server database column?
  6. SQL Server Management Studio - Restore database
    How to restore a database in SQL Server Management Studio
  7. SQL Server Management Studio - Change Recovery Model to Simple
    Using SQL Server Management Studio, we can change the recovery model of our database from FULL to Simple.
  8. SQL Server Management Studio - List all tables in a database
    List all tables in a SQL Server database with information about their creation date and last time referenced.
  9. SQL Server Management Studio - How to alter the default value or binding of a table column
    How to alter the default value or binding of a database column in SQL Server Management Studio
  10. SQL Server Management Studio - Change Table Owner
    How do you change a SQL Server Table Owner in SQL Server Management Studio?
  11. How to use SQL Server Database Connection string
    lessons with a SQL Server database connection
  12. SQL Server Core Installation Script
    Using the installation script to Install SQL Server Core 2019