Tables and Relationships
Understanding the difference between Parent Tables and Child Tables and the difference between Primary Keys vs Foreign Keys.
SQL Server
Integer Data Types
Explore the integer data type: learn how TINY, SMALL, REGULAR, and BIG INTEGER types can optimize data efficiency.
Writing a Stored Procedure
Learn the basics of writing a stored procedure and make your SQL Server code more efficient and reusable with parameters.
70-765 SQL Admin Exam
John Deardurff passed 70-765 Provisioning SQL Databases 2016 Stretch Database MCSA, MCSE Exam Microsoft Certifications
In-Memory OLTP
Unlock faster performance with In-Memory OLTP by downloading the free SQL Server Internals eBook today.
Data Visualization Exams
Explore my experience with Data Visualization exams and how they contribute to an MCSA in Business Intelligence Reporting.
SQL Server 2017 Released
Discover the features of SQL Server 2017 released, empowering organizations with AI for better data management and innovation.
Get Certified on SQL Server
Earn your credential and get certified on SQL Server to thrive in a cloud-focused environment with essential skills.
INDY PASS: Get Certified
Join the Indianapolis SQL Server User Group meeting to learn how to get Microsoft Certified. Learn from industry experts.
MCSA: SQL 2016 Development
I earned my MCSA: SQL 2016 Development certification unexpectedly. Discover my journey and upcoming goals in SQL development.