SQL Server Archives

How to use the WHERE statement to filter records when the value is a number or integer data type in a T-SQL statement.

How to use the ORDER BY statement to sort records in a T-SQL statement in both ascending and descending order.

Restricting data by using Table Constraints in SQL Server. What are the different table constraints in SQL Server?

Learn about Transaction and Errors in SQL Server. Understand Auto-Commit vs Explicit Transactions for better error handling.

John Deardurff passed 70-765 Provisioning SQL Databases 2016 Stretch Database MCSA, MCSE Exam Microsoft Certifications

Unlock faster performance with In-Memory OLTP by downloading the free SQL Server Internals eBook today.

Discover the features of SQL Server 2017 released, empowering organizations with AI for better data management and innovation.

Earn your credential and get certified on SQL Server to thrive in a cloud-focused environment with essential skills.

Learn how I passed the Exam Passed – 473 certification effortlessly with Microsoft Virtual Academy and Azure Documentation.

Explore the SQL Service Pack released six months after SQL Server 2016, featuring new capabilities for all editions.