Holiday Fun with the Advent of Code (2021-12-04 DBW)

Holiday Fun for Your Career

It's the last month of the year, and that results in plenty of "advent" items. I saw Tomaž Kaštrun start an Advent of Spark series and Denny Cherry is working on his advent of whiskey. Many people partake in other advent calendars, marking the days until Christmas. If you are looking for a fun gift for next year, consider an advent calendar of some sort for someone close to you.

When I saw Tomaž' posts, it got me thinking about the Advent of Code, which has been going on for a number of years. I've participated a few times, and last year tried to work through puzzles during the year. I failed miserably, which saddened me, but I decided to give it a try again this year. At least for a few days.

You can log in to track your progress and view the various puzzles that are available. Then try to solve them in your programming language of choice. I've watched Wayne Sheffield solve them in the past, usually with better T-SQL solutions than I come up with. Others have as well, blogging about their thoughts and solutions. To me, this is a fun way to get away from work, but also build some skills you'd use at work.

Spending time on puzzles like this is a good way to exercise your brain, while building practical skills. For example, the first puzzle this year asks you to look at a series of numbers and count how often there is an increase in the number from the previous one. In this case, we have a submarine with depth measurements, but really this is a query issue. The input is a series of text values, so you need to load those into SQL Server. Can't cut and paste them, right? Or can you? There are likely some interesting ETL solutions to load the data, as well as some creative ways to calculate the answer.

If you get stuck, there is a Reddit for the solutions, but try not to look. It is fun to browse the way people solve this in various languages, and I'm always amazed by some of the programming talent out there. The people who build visualizations are especially impressive.

Take a few minutes when you have a break and try to solve the first puzzle. Use T-SQL, PowerShell, Python, C, Pascal, Java, Rust, or whatever strikes you. It's a fun few minutes that will remind many of you why we enjoy this business. And bonus points if you blog about your work. That's an interesting set of posts that might intrigue the next person who runs across your resume or CV.

Steve Jones - SSC Editor

Join the debate, and respond to the editorial on the forums

SQL Monitor allows you to bring your whole estate into a single monitoring landscape that has a consistent interface, whether you have an all-Azure environment, or, more likely, a mixed database environment. Find out more, here!

With 92% of organizations now reported to be multi-cloud, a well thought-out approach to cloud migration is imperative. Download our final insights report in this series on database monitoring to find out how 2500+ of your peers are dealing with the challenge.

Phil Factor presents a useful but slightly flawed 'table report' script as an adventure playground for exploring SQL Code analysis issues. He demonstrates use of the auto-fix feature, to arrive at a pristine script free from wavy green underlines.

Use Flyway to run your database migrations, each time automatically creating a SQL Change Automation release object to provide object-level scripts and a build script for the new version, along with change reports and code analysis reports.

Date: Thursday, February 17th, 2022 Time: 11:00 AM Eastern Standard Time Duration: 1 hour Community-driven threat intelligence is all about the collection of network information from a myriad of sources, open and...

If you’ve been following with the series of demystifying dumps then you’re probably thinking or have thought something along the lines of, “All of these issues seem to be around stalled or non-yielding things…” and you’d be correct. If you revisit the non-yielding scheduler dump post, I explain a little about cooperative scheduling and how things need to place nice, if one piece isn’t playing nice by doing its part in a timely manner or not giving up time to others, that’s going to be a very large problem for the system in general.

The tempdb database in SQL Server holds a little b...

A common SQL Server Security check is to identify if the guest id is enabled.

Heaps get a bad rap but is it justified? Most of the time, I’d say the answer is “yes.” Let’s dive into some heap scenarios. What is a Heap?...

Patch management best practices work only when you apply them.

This is the fourth article in the series of Migrating SQL Server Objects using SSDT 2017. In the third article, we learned how we could transfer SQL logins between...

Regular scans to find enabled guest ids lead to questions of identifying the status

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Dynamic Data Masking is a feature that provides... The...

I need to confess: I’m proud of the article Query Store and Parameterization Problems I wrote. Today it’s no news at all (although some people may not know the details...

Series of Apache Spark posts: Dec 01: What is Apache Spark Dec 02: Installing Apache Spark Today, we will get familiarised with Apache Spark CLI and Web UI. Assuming, that...

Apache Spark is an open-source unified analytics engine for large-scale data processing. It provides an interface for programming entire clusters with implicit data parallelism and fault tolerance. Originally it...

Apache Spark is among the most usable open-source distributed computing frameworks because it allows data engineers to parallelize the processing of large amounts of data across a cluster of machines.

The Bulk Copy Program (BCP) utility can move bulk data between SQL Server instances. You can export SQL Server data into BCP files. You can also use them for...

I will explain how to restore an Azure SQL database in case you need to recover some data, or somebody has deleted your database in this article. Databases restore...

In this article we look at how to use the SQL Server Migration Assistant tool to get sizing recommendations for an on-premises to Azure SQL Database migration.

Azure SQL Database is a cloud database hosted on Microsoft’s Azure platform. It is an enterprise-grade database service that supports a wide range of advanced features, and it can...

Welcome to the November 2021 update for Azure Synapse Analytics! As we reach the end the end of 2021, we're excited show you all the new things that are now available for you.

Is your company hiring for a database position as ...

We’re data people, you and I. We make better decisions when we work off data instead of feelings. It’s time for our annual salary survey to find out what...

I first touched a SQL Server instance back in 1998 during a SQL Server 6.5 course. I hadn’t planned to take the class except that the small company I...

A friend wants to get started and write a blog, an...

Everyone is looking for hybrid solutions in today’s world. SQL Server 2022 comes with built-in capabilities to leverage the power of Azure. Come learn more about how you use...

I am excited to announce the next live and online delivery of Expert SSIS is 17-18 Jan 2022! Use the coupon code LimitedTimeDiscountExpertSSIS and save! Course Description Data integration is the...

Yesterday, I finished setting up my new Apple MacB...

When comparing two values in a programming or scri...

When I write a PowerShell module, it typically inc...

Let's talk a little bit about PowerShell variables and how long they exist within the scopes they're defined. I've encountered some behavior that for me, was unexpected. It's made...

Knowing how to manipulate strings is critical in any language. In this article, Greg Moore explains working with PowerShell strings.

As a result of some struggles trying to automate a process, I've learned some things about PowerShell. After getting to the bottom of a time-consuming problem, I thought it...

Introduction In a previous post, Fun with PowerShell Enums I introduced the concept of Enums. In this post we’ll dive deeper into enums, taking a look at more of its properties...

As IT departments and businesses across all sectors handle larger quantities of raw data, processes have been created to turn this data into useful information. Data mining is the...

Data mining is the umbrella term for the process of gathering raw data and transforming it into actionable information. Due to the dramatic growth of user-friendly data visualization tools,...

As 2021 begins to draw to a close, there are lesso...

A long time ago in a glaxy far far away… ?? … ...

Assume we are in the linear regression context: we have i.i.d. data with and , and we want to do linear regression of on . Assume further that the...

Antoine Soetewey has a handy chart for us: Being a...

Frank and I are on Day 29 of 1,000 days, a new thing we started 02 Nov 2021 to remind us time is not fungible and we should build...

(2021-Nov-30) I heard a story about a young person who was asked why she was always cutting a small piece of meat and putting it aside before cooking a larger... The...

There are new Ubuntu Pro 20.04 images available in the Azure marketplace with SQL Server 2019 pre-installed so I thought I’d run through how to create a three node...

I open up a new MacBook Pro M1 Max and note a few of my initial observations.

Western Digital this week said that its energy-ass...

Supply chain issues could affect response to 'SMART failure detected on hard disk' warnings.

MOD: Returns the remainder after a number is divid...

Learn two different ways to display the difference of two time periods displayed in days, hours, minutes and seconds for Power BI reports.

DIVIDE: Safe divide function with the ability to handle divide by zero cases. https://dax.guide/divide/

I recently ran into a production issue where a SEL...

Paul Randal describes why the optimizer doesn’t use buffer pool contents for plan generation and details the potential dangers if it did. The post Why the Optimizer Doesn't Use Buffer...

If you’re like me, you started your database jou...

In this article, we will learn about the concept of table inheritance, and its use in Azure Database for PostgreSQL. Introduction A database ecosystem is formed of various types...

Database professionals often work with more than one database platform. Grant Fritchey explains setting up and connecting to PostgreSQL database.

It happens that you might have two fields as From and To date (or Start and End date) in your dataset, and you want a date slicer in the report. The date slicer has to filter records in a way that the FROM and the TO dates are in the range of dates selected in the slicer.

Power BI Deployment Pipelines are a strategic feature that allows users to better manage content across their organizations. By leveraging this powerful tool, users can simplify the deployment process...

Not sure what a REST API is? Or what you can do with them in Power BI? Find out how you can easily take advantage of them without having...

The Data God Guide to Power BI Gen2 walks through ...

Tired of all those buttons for navigation in your Power BI reports? Patrick shows you how to use the Page Navigator to easily get going and get rid of...

Some of you might have seen this before – you load some data into Power BI and suddenly the capitalization (uppercase / lowercase) of your text changes on you. Let me explain what is happening here.

In my quest to check out every last bit of obscure Power Query functionality, this week I looked into the ContextInfo option on the Sql.Database and Sql.Databases M functions....

If you’ve visited the Tab order area of the Selection Pane in Power BI in the last couple of months, you might have noticed some new buttons. The hover...

Tony Davis describes a typical database development cycle and deployment pipeline supported by Redgate Deploy. It allows branch-based database development, using disposable databases (clones) and version control tools, promotes...

Updates to Management Packs for SQL Server, Report...

SQL Server IaaS Agent extension license management capabilities are now available for Ubuntu Linux virtual machines.

Azure Monitor logs is announcing a new capability to collect audit logs about query execution

Introduction These are my SQL Server Diagnostic Information Queries for November 2021, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration...

Azure VPN Gateway NAT (Network Address Translation) can be used to connect on-premises networks or branch offices to an Azure virtual network with overlapping IP addresses.

Use the Flexible Server deployment option allowing better control, flexibility, zone-redundant high availability, and cost optimization on Azure Database for PostgreSQL, a managed service running the open source PostgreSQL...

I streamed for a little while today while the junior engineers were home playing games so my bandwidth suffered a little. I recorded it so I could share it...

Updated November 30, 2021: Added launch partner blog links. Amazon Inspector is a service used by organizations of all sizes to automate security assessment and management at scale. Amazon...

We launched the AWS Well-Architected Framework back in 2015 to help you review workloads against architectural best practices, and across pillars such as operational excellence, security, reliability, performance efficiency,...

I find quantum computing fascinating! At its simplest level, it extends the concept of bits, that have 0 or 1 values, with quantum bits, or qubits, that can have...

AWS and AMD have collaborated to give customers more choice and value in cloud computing, starting with the first generation AMD EPYC™ processors in 2018 such as M5a/R5a, M5ad/R5ad,...

I came across the following result recently when googling around for something else: Let be a discrete random variable taking values in , and let be its probability generating...

Theorem: For , let with . Then While the theorem does not give us a single explicit formula for , we can write out an expression for for a...

Introduction Microsoft launched SQL Server 2019 on November 4th 2019, so it has been GA for a little over two years now. The latest Cumulative Update (CU) right now...

Learn how to configure and enable SQL Server Agent for SQL Server 2019 running on a Linux system.

A hacker stole $31 million from the blockchain com...

The breach, which compromised data such as insuran...

A new study of 17 malware frameworks shows threat ...

Tech firm reveals that data on one of its file servers was accessed by attackers.

Test the no-password waters with passwordless authentication solutions from Microsoft.

Agile software development, in which apps are changed incrementally over short timespans, can benefit users and developers. Learn how it works, its advantages and its challenges.

In this article we look at how to use different T-SQL aggregate functions in SQL Server such as count, sum, min, max, avg and more along with examples.

This is part nine in a series on window functions in SQL Server. POC: the Rule of Thumb If you’ve been around the block with window functions, you’ve probably...

Today, I will explain an overview of the SQL MIN (...

This is part eight in a series on window functions in SQL Server. Not All Roses So far, we’ve seen some really cool things we can do with window...

The dire warning in the subject line is not meant to scare you. Rather, it is advice that is going to be useful to those of us who need... The...

I recently had a requirement to load some data from a source table to another destination table. The destination columns were exactly the same as the source columns with the same data types and length. The only difference was that some columns on the destination table must be encrypted.

Developers can work with multiple range values at once using sp_sequence_get_range. Greg Larsen explains how to return multiple sequence numbers with sp_sequence_get_range.… The post How to return multiple sequence numbers...

In this article, we show how to model decisions about time series values based on performance scores using SQL code to manage and process the time series data in...

What is 2048 game? It is a classical puzzle game, that is easy and fun to play. The objective of the game is to move the numbers (tiles in...

This is part seven in a series on window functions in SQL Server. The Road So Far To this point, we’ve looked at five classes of window function in...

Establishing an IT risk management practice can help organizations reduce exposures and maintain regulatory compliance.

Regularly I meet with customers to discuss NUMA technology, and one of the topics that are always on the list is the Cores per Socket setting and its potential...

There are a number of tools for building a hybrid cloud environment, so the challenge is picking the one that is best for your organization. We look at the...

This article will show how to deploy SQL Server 20...