SQL Server Archives

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?

Understanding the difference between Parent Tables and Child Tables and the difference between Primary Keys vs Foreign Keys.

Explore the integer data type: learn how TINY, SMALL, REGULAR, and BIG INTEGER types can optimize data efficiency.

Learn the basics of writing a stored procedure and make your SQL Server code more efficient and reusable with parameters.

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.

Explore my experience with Data Visualization exams and how they contribute to an MCSA in Business Intelligence Reporting.

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.