A Fine Slice Of SQL Server
In this video, explain what Sixth Normal Form (6NF) is and why it slots in as the third most-important normal form. We look at two separate use cases in which 6NF can make sense and I provide some guidance on when 5NF is good enough versus when 6NF is better.
6th Normal Form doesn’t necessarily make sense all the time, but there are some really good use cases for it.
Comments closedSoheil Bakhshi lays out the options:
Microsoft Fabric is a SaaS platform that allows users to get, create, share, and visualise data using a wide set of tools. It provides a unified solution for all our data and analytics workloads, from data ingestion and transformation to data engineering, data science, data warehouse, real-time analytics, and data visualisation. In a previous blog post, I explained the basics of the Microsoft Fabric data platform. In a separate blog post, I explained some Microsoft Fabric terminologies and personas where I explained what Tenant and Capacities are.
In this blog post, we will explore the different types of Fabric capacities, how they affect the performance and cost of our Fabric projects, and how you can control the capacity costs by pausing the capacity in Azure when it is not in use.
Click through for more information. The costs are in New Zealand Dollars, so translate as needed.
Comments closedChad Callihan finds the DDL for a view:
I recently faced a situation where I had to track down the definition of a particular SQL view for various databases. I didn’t want to click through each database in SSMS to gather the information. I thought I would write a query that I could use to save some clicks and gather what I needed for each database.
The first part of that task, querying for the view definition, may be a bit tricky. I would venture to guess it may not be in the first couple of places you would think to look. Let’s walk through how we can use a query to retrieve the definition of a view.
Just make sure that you have newline retention on or else your view definition is all going on one line.
Comments closedSean Gallardy has a video for us:
The first video olved stery! In this one we look at an FCI node that will not come online after patching.
Click through for that video, which is a great learning instrument for in-depth analysis of a SQL Server problem.
Comments closedDan English continues a series:
This is a bit overdue and a follow up to a few other posts I have regarding using Service Principal authentication with Power BI reports Power BI using Service Principal with Synapse SQL Pool and Power BI using Service Principal with Synapse Data Explorer (Kusto) Pool.
With the other two posts I did last year I had to use the SQL Server ODBC driver to get that to work and the big downside to that is that you need to use a gateway with that. Well in this case we are going to take a look at the new Shareable Cloud Connections that were announced earlier this year Streamlining cloud connection management for datasets, paginated reports, and other artifacts | Microsoft Power BI Blog | Microsoft Power BI
Click through to see what you need to get it working.
Comments closedHugo Gruson draws some comparisons:
The debate regarding the use of
forloops versus theapply()function family (apply(),lapply(),vapply(), etc., along with their purrr counterparts:map(),map2(),map_lgl(),map_chr(), etc.), has been a longstanding one in the R community.While you may occasionally hear that
forloops are slower, this notion has already been debunked in other posts. When utilized correctly, aforloop can achieve performance on par withapply()functions.However, there are still lesser-known reasons to prefer
apply()functions overforloops, which we will explore in this post.
Read on for an important caveat, and then several reasons to prefer apply() (or purrr’s counterparts). H/T R-Bloggers.
Sebastian Sauer draws a graph:
Let’s visualize the quantiles of a normal distribution.
Not much to snag in the graf, as Sebastian goes straight to code. Read on to see how to set this up in R, how to draw randomized data points from a normal distribution, and then how to plot and animate the solution.
Comments closedMarco Russo and Alberto Ferrari show off their intelligence:
Time intelligence functions such as month-to-date (MTD), quarter-to-date (QTD), and year-to-date (YTD) in DAX operate relative to the current filter context. Their outcome depends on the filter applied, making them both adaptable for various periods and useful for comparisons. But, if you wish to showcase the most recent data – for the “current” period – there is a complication: without the proper filter, you may not get the data you aim for.
Read on to see what they mean and how you can avoid this issue.
Comments closedSo what’s up this time. Our client has moved to Azure in classic lift and shift scenario. Well, almost. They’ve deployed new VM’s and installed SQL Server 2019 Standard in nice DTAP setting. The VM’s are standard E16-4as-v4 SKU. 4 vcpus and 128 GB memory. The disks are Premium SSD LRS ones with 2300 Max IOPS.
Their on-premises environment was a SQL Server 2016 standard edition running on a virtualisation layer with 128 GB of memory and 8 cores.
In both cases there are 2 numa nodes dividing the amount of cores between them.
Read on to learn more about the problem and what Reitse & co did to resolve it. Also check out the comments—Daniel Hutmacher, in particular, I think has the reason nailed.
Comments closedSteve Jones links to Steve Jones talking about Steve Jones:
I had written about a FK in a CREATE TABLE statement recently, but the second half of this was that after the original question, the person asked if this would also work for a self-referencing FK. It does, and I wrote this to show that.
Click through for an example of how to do this.
Comments closed