So many days of Advent! So many chances to practice SQL! Today, we’ll be working on the next in the series using the data and processes that we found yesterday in Day 2 Part 1 – found here. Thankfully, we were smart when we began working through the data and we have the data for…… Continue reading Walking Through the Advent of Code Day 2 Part 2
Tag: SQL
Walking Through the Advent of Code Day 2
Time to celebrate my friends! We’ve made it all the way to Day 2! On day 2, we are asked to gather data from a series of games and to see which of those are possible given a specific number of dice for a few colors. Fun times! As always, the first thing we have…… Continue reading Walking Through the Advent of Code Day 2
Walking Through the Advent of Code Day 1 Part 2
Hopefully, you’ve read Walking Through the Advent of Code Day 1 – otherwise, this post is going to be like walking into a 4″x4″ post – rather jolting. I also hope that you’re making progress on the #AdventOfCode series. I’m sure some of you are on the Overall Leaderboard. Be sure to check on the…… Continue reading Walking Through the Advent of Code Day 1 Part 2
Walking Through the Advent of Code Day 1
Sometimes you need to step back, walk through various coding adventures, and rebalance yourself. Thankfully, I have found one set that I like – and has been running for several years. And it’s all about our actual season – the Advent season. (If you’re reading this long after it’s published, you can also figure out…… Continue reading Walking Through the Advent of Code Day 1
Checking if your XML is actually well-formed
Sometimes you’ll find that you will have XML in your database. This could be for various reasons – from storing the XML after receiving an API response to keeping it in a table because a web developer couldn’t figure out another way to store their data. Sometimes – no matter how much you trust your…… Continue reading Checking if your XML is actually well-formed
Transactions should (never) be distributed
For the last few blog posts, we’ve been talking about transactions. If you’ve missed any, be sure to click on the links below: Using Save Points with Transactions to Get BetterHow about we TRY and CATCH some Transactions?Setting up a Friendly TRANSACTION In the version of transactions that we going to discuss today, we’re going…… Continue reading Transactions should (never) be distributed
Using Save Points with Transactions to Get Better
When we last conversed, we talked about the TRY/CATCH block and how it works with transactions. If you somehow missed that, you can read about it here – How about we TRY and CATCH some Transactions? We’ll wait for you… All right, now that everyone’s back with us, we’ll talk more about everyone’s favorite -…… Continue reading Using Save Points with Transactions to Get Better
How about we TRY and CATCH some Transactions?
In our last post, we started talking about transactions and how they can help your databases have data integrity. Let’s continue that today with our friends TRY and CATCH. TRY is just telling SQL Server that we want to try out something. CATCH tells SQL Server what to do if it completely messes up. BEGIN…… Continue reading How about we TRY and CATCH some Transactions?
Setting up a Friendly TRANSACTION
The last time we were together, I discussed DCL and TCL. That post ended with a quick paragraph on transactions and how they can help with data integrity. Today, I want to go more in-depth on this very important topic. Transactions always – and I do mean always – start with the phrase BEGIN TRAN.…… Continue reading Setting up a Friendly TRANSACTION
Accessing and Transacting Languages in SQL Server
Over the last few posts, we’ve discussed DDL and DML. This week I want to actually discuss the other 2 types of languages with SQL Server – DCL and TCL. DCL is the Data Control language. These are the commands that give security permission to a person – or group – to get things done.…… Continue reading Accessing and Transacting Languages in SQL Server