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
  13. Difference between UNION ALL and UNION
    The difference between using UNION ALL and UNION to display records correctly.
  14. How to perform a Backup of SQL Server Transaction Logs and SQL Server Databases.
    How to schedule a backup of SQL Server Transaction Logs and Databases.
  15. Schedule to Backup SQL Server Transaction Logs
    How to schedule a backup of SQL Server Transaction Logs.
  16. Backup SQL Server Transaction Logs
    How to schedule a backup of SQL Server Transaction Logs.
  17. Windows 2016 Server How to reset the maximum rearm count.
    Windows 2016 Server Remaining Windows rearm count 0. How to reset the maximum rearm count.
  18. SSMS - Get Statistics and View Showplan and Actual Execution Plan of your data
    What are the different features in SQL Server Management Studio that can make my Queries look and work better? How to view the Actual Execution Plan in SSMS?
  19. SQL Server Select Statement and Delete
    How do you delete an IS NULL value from a Select Statement in SQL Server?
  20. SQL Server - SELECT UNION Will not retrieve proper records
    SQL Server Union Statement will only work if you specify a WHERE clause.
  21. SQL Server - Return only records where the count is not 0
    SQL Server - How to get only records that have content?
  22. SQL Server - Get Time from DateTime
    SQL Server - How to format DataTime
  23. SQL Server Replace Text within a long string
    How do you replace a word or characters in a string in SQL Server?