A Fine Slice Of SQL Server
Laetitia Avrot shares some advice:
This month’s PGSQLPhriday event is about UUId thanks to my post calling for a
fightdebate on the topic.I will answer a question a friend developer asked me: “What is the best when we need a primary key? UUID, CUID, or TSID?”
I hadn’t heard of two of these, but Laetitia provides some links to learn more about them and then offers up some advice on whether to use any of them. And the advice sounds a lot like the advice for SQL Server.
Comments closedJaime Garcia de Alba becomes the machine:
In this guide, I am going to outline the steps on how to connect to an Azure SQL database using Entra SPN with tools such as SSMS and PowerShell. This demo covers detailed steps for using an existing user when the token is received correctly. Additionally, the steps cover creating a new user from scratch in case there are issues with the existing user.
I’ve used service principals and managed identities in the past in application code, but it wasn’t until this post that I learned you could also use them directly to connect to an instance.
Comments closedI don’t have anything against the use of calculated columns in Power BI semantic models in general but you do need to be careful using them with DirectQuery mode. In particular when you have a DirectQuery connection to another Power BI semantic model – also known as a composite model on a Power BI semantic model – it’s very easy to cause serious performance problems with calculated columns. Let’s see a simple example of why this is.
Read on for Chris’s example.
Comments closedStephane Laurent does a bit of work:
The ‘RowReorder’ extension of datatables is available in the DT package. This extension allows to reorder the rows of a DT table by dragging and dropping. However, if you enable this extension in a Shiny app for a table using the server-side processing (option
server=TRUEinrenderDT), that won’t work: each time the rows are reordered, they will jump back to their original locations.
Read on to see what you need to do in that case, as well as an example of how to do it. H/T R-Bloggers.
Comments closedSebastian Sauer bridges the gap:
However, a disadvantage of Bayes analysis, at least at its current state, is that it has higher technical and computational demands. For beginners in particular, this may present a substantial (entry) burden. Teaching statistics, I have found that students (and many colleagues) have had difficulties installing Stan (particularly the C++ compiler needed in order to run Stan); Stan is the probabilistic programming language which many front-end Bayes engines use such as
brmsin R.Thus, the installation process being not so user-friendly, a burden is placed for beginners which may prevent using Bayes methods.
In that light, this post explores the numerical simarilities of Bayes regression models and Frequentis models. The idea is to use a Frequentist regression model as a proxi for a full Bayesian analysis. The value added is the quick computation and the simple technical setup.
Click through for the conditions where you’ll find very similar results, as well as a few examples of it in action.
Comments closedErik Darling has started a new podcast:
In the inaugural episode, Joe Obbish and Erik Darling talk about how developers use and abuse transactions, and some surprises you might run into for them.
Click through for the video.
3 CommentsChad Callihan doesn’t need solo rows; he needs team players:
SQL Server can be pretty smart when it comes to avoiding work it’s not required to do. One instance of this is the concept of join elimination. Join elimination occurs when queries involving joins may only need to check one table instead of two (or more) based on foreign key constraints.
Let’s take a look at join elimination in action.
Read on for one example of join elimination and one more reason why those foreign key constraints are so useful.
Comments closedAaron Bertrand diagnoses a problem:
We came across a new error during SQL Server setup that returned zero useful search results:
The setting ‘COMMFABRICPORT’ specified is not recognized.
I did not find too many mentions of this argument at all, never mind in that specific phrase – though now that I wrote this, it might start returning this post. Most mentions came from probably a single sample copy of
ConfigurationFile.inioffered on a blog post from the ~2017 timeframe.
Read on to learn more about this, as well as short-term and long-term fixes for managing your installation config files.
Comments closedDavid Fowler updates an older procedure:
Presenting you with an updated version of our sp_snapshot procedure, to easily create database snapshots.
This new version adds more flexibility to the procedure, allowing you to specify the snapshot’s suffix, add a timestamp and alter the path that the snapshot files are taken to.
Read on for the procedure text and an example of how to call it.
Comments closedRod Edwards enumerates the list:
This is one that I should have learnt way earlier than I actually did if i’m being completely honest. One of my colleagues wrote a cool function for multithreading, and although this isn’t it, it did made me look into how it all worked.
Some of the techniques can be quite complicated, especially for a DBA who’s not as experienced with Powershell yet (and a ForEach loop just works right?) so I thought i’d post about the simplier methods that can be employed, and tweaks to get most of the benefits, without the complexity.
So, lets jump straight into it.
Rod does focus on Powershell jobs and thread jobs, so check out how those work. A while back, I had a comment here talking about the various options though Rod has definitely put a lot more effort into this task.
Comments closed