A Fine Slice Of SQL Server
Kevin Chant has some links for us:
Last week the January 2023 video of the Azure Synapse Analytics and Microsoft MVP series was released. Where I covered how to do CI/CD for dedicated SQL Pools in Azure Synapse Analytics.
Since the release of that video the most popular question raised has been how to perform CI/CD for serverless SQL Pools within Azure Synapse Analytics?
Read on for links galore.
Comments closedMeagan Longoria gets out of a tricky situation:
I had to do this for a client the other day, and I realized I hadn’t blogged about it. Let’s say you need to include data in a Power BI model, but the only source of the data is a matrix that is output from another system. And that matrix has multiple fields populating the columns. An example of this is below. The matrix has fiscal year and product category on columns, vertical on rows, and the profit metric populating the values.
Read on for a step-by-step guide on how to do this.
Comments closedAndy Leonard has an offer for free training:
My LinkedIn and social media feeds are filled with contacts and friends sharing their availability for a new career opportunity. While some are more gracious than concerned and others more concerned than gracious, it’s normal to be both concerned and gracious. Well, it was normal for me when it happened to me. If you haven’t been laid off before, I hope you never learn what that feels like.
If you have been laid off already, or if you’ve been notified you are about to be laid off, I encourage you to see this as the beginning on your Next Opportunity.
Click through for the details on this generous offer.
Comments closedManan Goel lists what’s been going on with Amazon Redshift:
In 2021, we launched Amazon Redshift Query Editor V2, which is a free web-based tool for data analysts, data scientists, and developers to explore, analyze, and collaborate on data in Amazon Redshift data warehouses and data lakes. In 2022, Query Editor V2 got additional enhancements such as notebook support for improved collaboration to author, organize, and annotate queries; user access through identity provider (IdP) credentials for single sign-on; and the ability to run multiple queries concurrently to improve developer productivity.
Read on for the rest of the highlights.
Comments closedRobert Cain continues a series on KQL:
Back in June of 2022 I covered the
topoperator in my Fun With KQL – Top post. We showed how to create your own top 10 lists, for example what were the top 5 computers ranked by free disk space.What if you needed your top results in a nested hierarchy? For example, you wanted to know which three objects in the Perf table had the most entries? But, for each one of those, what were the three counters with the most entires?
That’s where the
top-nestedoperator comes in. It allows you to create top lists in nested, also called hierarchical levels.
Click through for the normal slew of examples on how to use this operator.
Comments closedDmytro Kostenko enumerates some options:
In Cassandra, a consistency level is the number of replicas responding before returning a reply to a user. Consistency in Cassandra is tunable, meaning that each client can consider what level of consistency and availability to choose. Moreover, it is assigned at the query level and can be configured for different service components. Users can choose different consistency levels for each operation, both for reads and writes. While choosing the consistency level for your operation, you should understand each level’s tradeoff between consistency and availability. Cassandra’s consistency can be strong or weak, depending on your chosen level.
Read on to learn more about strong vs weak consistency in the context of Cassandra, as well as the consistency level options available to us.
Comments closedOlivier Van Steenlandt can’t live in this static world:
When I started to explore and use Database Projects, I ran into a specific situation quite fast where I was required to use SQLCMD variables. In this blog post, I will describe what they are, how you can use SQLCMD variables in Database Projects and where this might become very useful for you.
Click through for a scenario, a primer on using SQLCMD variables, and some basic details on how to use them in database projects.
Comments closedJames Serra explains why you might want multiple data lakes in an organization:
A question I get asked frequently from customers when discussing Data lake architecture is “Should I use one data lake for all my data, or multiple lakes?”. Ideally, you would use just one data lake, but I have seen many valid use cases where customers are using multiple data lakes. Here are some of those reasons:
I’d quibble with a couple of these (and given James’s intro, I’m not sure he’s fully on board with all of the reasons) but this is a good list of reasons why you might see several data lakes in an organization.
Comments closedDenny Cherry diagnoses a problem:
Over the weekend, I was configuring our new VMware servers. I was happily working around when all of a sudden, vCenter started showing the hated “no healthy upstream” message on the vCenter website.
Thankfully, this was not the first time I’d seen this happen, and it usually occurs randomly (at least in my experience). The solution is easier than most people would think.
Click through to learn what you should do if you see that error.
Comments closedChris Webb is spinning in circles:
When working in the Power Query Editor in Power BI or Excel, especially when you’re editing M code, you may run into the following error:
Expression.Error: A cyclic reference was encountered during evaluation.
What does this message mean and what causes this error? In this blog post I’ll explain.
Read on for the answers.
Comments closed