Happy Holidays

Happy Holidays!

Happy Kwanza!

Merry Christmas!

Happy Hanukkah!

Happy Yuletide!

Happy New Year!

Personally, I love this time of year. I like the music, the decorations, pretty much the whole thing. Plus, at my house, we watch Christmas movies. However, we go out of our way to find the Christmas movies that are a little off. Ok, maybe more than a little off. Sure, we watch Miracle on 34^th Street (the one with Natalie Wood & Maureen O’Hara, accept no substitutes), but we also watch The Thin Man (yet another Maureen). A decidedly child un-friendly film that has become a holiday stable is Rare Exports. Great film. Another odd one, again, not entirely child appropriate, is Long Kiss Goodnight. There are a few others. It’s just a fun way to mix things up and toss in some additional, albeit twisted, whimsy to a whimsical time of year.

I hope you have some unique bit of fun or entertainment that you get up to at this time of year. Share it in the comments.

If you’re having a rough time this season, as many are, please, don’t hesitate to reach out. Maybe watch a Christmas film. Die Hard is a great one.

Grant Fritchey

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

Take part in this short exercise (no more than 5 minutes) by letting us know what matters most to you when considering, purchasing, or using database software. As a thank you, you can also enter our prize draw at the end for a chance to win a $150 Amazon gift voucher.

The ability of computers to process tabular and numeric data is unequivocally an essential part of industries today. However, while being able to process massive amounts of numeric data...

Click here to learn more about Golnar Pooya. The benefits offered by artificial intelligence (AI) in the public sector are nothing short of revolutionary. Algorithms powered by machine learning...

Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and talked out new feature. In this post we'll just take a brief look at it,... The...

Series of Azure Databricks posts: Dec 01: What is Azure Databricks Dec 02: How to get started with Azure Databricks Dec 03: Getting to know the workspace and Azure Databricks platform Dec 04: Creating...

Series of Azure Databricks posts: Dec 01: What is Azure Databricks Dec 02: How to get started with Azure Databricks Dec 03: Getting to know the workspace and Azure Databricks platform Dec 04: Creating...

Series of Azure Databricks posts: Dec 01: What is Azure Databricks Dec 02: How to get started with Azure Databricks Dec 03: Getting to know the workspace and Azure Databricks platform Dec 04: Creating...

The PASS organization (and likely SQL Saturday) are shutting down their sites on 15 Jan,  2021. This means that potentially lots of links and data will disappear. There are... The...

We’ve already shared our reflections on seven years with skills maps, and our realization that we needed something more.

I posted a call for questions about SQL Server careers and professional development, and y’all asked a lot of good ones. Here were the questions you upvoted the most,...

Click to learn more about author Tom Clancy. Over the last six months, the pandemic has dramatically changed the way we live and work – forcing organizations to turn...

This afternoon, PASS announced that their operations will cease in January: We are saddened to tell you that, due to the impact of COVID-19, PASS is ceasing all regular...

Introduction Alex is a Data Platform MVP who loves...

This is a very brief post to inform you that PASS has died, killed by the for-profit company behind it. That’s sad beyond words, but we, as a community,... The...

In 2018 I started a new user group called the Calgary Data User Group, and hosted one session called “The Ethics of Machine Learning.” It was well-attended and its...

This year has been difficult for most of us, and it’s almost over. The lives of people throughout the world have been turned upside down. Many of us, myself...

Key Details What: Data Platform Meetup Israel.Where: On the Internet, UTC+2.When: Monday, December 21st.Admission is free. RSVP on Meetup. What I’m Presenting 1:00 PM — 2:30 PM EST —...

I recently had a need to add certificates to SQL S...

Data drop comes ahead of a potential Emergency Use Authorization on Thursday.

December 1 saw the introduction in New Zealand of the Privacy Act 2020 which not only brings increased protection for individuals but also has some new implications for businesses,...

Introduction to data science at Trainline Hello an...

The popularity of Python continues to grow and grow as days go on. As companies begin to adopt cloud first approaches and the move to the Modern Data Warehouse, it’s important that as BI Developers, we are working towards building our skillsets to be ready for when the company gives the greenlight for the cloud. The problem with this is how to learn the skills for the cloud if these skills to work in the cloud are lacking.

Click to learn more about author Joe DosSantos. It was only a few years ago that BI and data experts excitedly claimed that petabytes of unstructured data could be...

When it comes to deploying databases, one of many challenges that arises is dealing with your master data, lookup data, or sometimes even reference data. It’s those tables that...

Whilst carrying out some work for a client using Azure Data Factory I was presented with the challenge of triggering different activities depending on the result of a stored...

The external storage market has shown renewed vigor in recent years, thanks in part to growth fueled by bus-powered flash-based storage solutions. The introduction of 3D NAND, coupled with...

Odor Of Gas One problem with Lookups, aside from the usual complaints, is that the optimizer has no options for when the lookup happens. If the optimizer decides to use a nonclustered...

The Eye UPDATE: After writing this and finding the results fishy, I reported the behavior described below in “Somewhat Surprising” and “Reciprocal?” and it was confirmed a defect in SQL...

At first glance, the question of how many rows are estimated from a table variable is easy. But, is it really that simple? Well, not really. To dig into... The...

Reading execution plans in SQL Server is just hard. There’s a lot to learn and understand. I previously outlined the basics I use to get started when I’m looking...

Introduction The Merge Interval operator reads dynamic seek range specifications, checks to see if their specified ranges overlap, and if so combines the overlapping ranges into one new range....

There were a lot of good questions on our Power BI...

I’m excited to announce that something new is coming to the Power BI community in 2021: Workout Wednesday! Workout Wednesday started in the Tableau community and is expanding to... The...

The moment you've been waiting for! What Marco Rus...

If you’re using DirectQuery mode for one or more tables in your Power BI dataset, the chances are that you will want to see the SQL (or whatever query...

SQL Compare and SQL Data Compare can be used together, from the command line, to provide a complete build process, or to script out changes to both the database...

This book, now in its second edition, aims to teach you Azure in around 20 hours, how does it fare?

Recently I wrote about ignoring comments in SQL Compare. That seems like something I want to do in all my projects, so I went looking for how to set... The...

No matter how much automation you have built, no matter how great you are at practicing Infrastructure as Code (IAC), and no matter how successfully you have transitioned from...

Today, in partnership with Grafana Labs, we are excited to announce in preview, Amazon Managed Service for Grafana (AMG), a fully managed service that makes it easy to create...

Azure Functions is a cloud service that allows you to deploy “serverless” microservices that are triggered by events (timers, HTTP POST events, etc) and automatically scale to serve demand...

The web is a significant source of data in the digital era. All required information is available on the websites. For example, users can browse SQLShack for all useful SQL Server related articles. In the Power BI Desktop articles, we explored the way to fetch data directly from the URL.

The New York Times has more details. About 18,000 private and government users downloaded a Russian tainted software update –­ a Trojan horse of sorts ­– that gave its hackers...

This is interesting: Toward the end of the second incident that Volexity worked involving Dark Halo, the actor was observed accessing the e-mail account of a user via OWA. This...

Life of a Netflix Partner Engineer?—?The case of...

What does coalesce mean? In the English language, it is generally used to convey a coming together, or creating one whole body, mass or system. How does that help us when working with data? We spend a lot of time cleaning our data, surely the last thing we want to do is lump it all together?

Here's a SQL Puzzle for the festive period. 2020 has been a year of many things but amongst it all, it has been the year of chess. The combined... The...

A number of business processes require you to distribute a value over a date range. However, if your distribution keys and values don't add up perfectly or aren't perfectly...

Spell It Out Back in October, I had written a couple posts about how parameterizing TOP can cause performance issues: A Parameterization Puzzle With TOP: Part 1 A Parameterization Puzzle With TOP:...

Backstory I imagine everybody has them – those annoying, bloated, misshapen tables that don’t really belong in the database. I mean, this is an expensive enterprise RDMS supporting a...

Repeat offenses under new rules will trigger action to force divestments.

Amazon offers peek into development of antenna for...

There’s a long-running column in Cook’s Illustrated called “What is it?” where we track down the origins of kitchen gadgets that our readers find in their attics or on...

It’s like playing in a multiverse “but the different boards are connected to each other.”