SQL and Database Wrapup 2020 (3 Part Series)
At the end of each month, I'll be showcasing some of the great posts, projects and insights from the data community.
First up, how data modelling works in the real world. Using SQL Server Kiron shows us how to create tables, identify a primary key and link the tables together. If you've ever been curious what's happening behind the scenes in SQL Server this is a good place to start.
The most popular post in the Data world this month, this post from Trevor is a list of tools to help with ETL, documentation, modelling and inspecting logs. Check it out for tools that might help make your work more streamlined in 2020.
Next, we have Joy who is aiming to turn you into the SQL Savant with this article on JOINs. Through a straightforward and easy to digest example you can tackle INNER and OUTER joins with ease.
Tariq is back, this month with ElasticSearch and three approaches to pagination. If you've enjoyed the series so far check this one out as well.
If you've ever heard your DBA chatting about performance, statistics and query plans this post is for you. Rion tackles tweaking a slow query in SQL Server and demystifies the tools to get it done.
Bill has some great advice on dates, timestamps and why you should be careful with BETWEEN when dealing with dates. Check out the post for some top tips.
Our next post from Edwin spoke to me. Dropping tables that look like they are unused is easy to do, but not so easy to get back if it needs to be recovered. Work through the steps in this post to make sure you do it the right way.
Indexes are a technique to make your queries go faster, by telling the engine where to go to. To find out more about how to get started and some of the drawbacks check out this post from Islam.
Lastly we have SeattleDataGuy with a great long read on setting up a data pipeline when you don't have a data pipeline. With a few tools you can get your data loaded and ready to query in no time at all.