Jun 7, 2024 | General, Introduction to SQL Server |
Understanding Indexes in SQL Server This post is part of the series I’m writing called an “Introduction to SQL Server.” This post simply raises the topics of indexes. It is definitely not a comprehensive guide to them, and there is much more...
Jun 6, 2024 | General, Introduction to SQL Server |
This post is part of a series titled “An introduction to SQL Server”. The series is intended for people new to SQL Server, to try and provide a place to start. If you have been following along with the series the last few posts have been related to...
Jun 5, 2024 | General, Introduction to SQL Server |
Understanding Foreign Keys in SQL Server In yesterday’s “Introduction to SQL Server” post, we looked at primary keys and how they are used to uniquely identify a record in a table. In this post, we’ll take that a stage further and introduce...
Jun 4, 2024 | General, Introduction to SQL Server |
Understanding Primary Keys in SQL Server In my last post, I discussed creating tables, continuing the theme of constructing databases. As part of my series ” An Introduction to SQL Server,” I wanted to take time to discuss primary keys, which we mentioned...
Jun 3, 2024 | General, Introduction to SQL Server |
Creating Tables in SQL Server This post is part of my series on an “Introduction to SQL Server”. A note before you start reading, this is not a modelling post. data modelling falls outside the scope of this post and probably this series. However, if...
Jun 2, 2024 | General, Introduction to SQL Server |
How to grant permission to use the SQL Server Agent? This post is part of a series I have called “An Introduction to SQL Server.” The material is for people who new to SQL Server and need to get up to speed. I got asked this question while delivering a...
