Sandeep Pawar has a script for us:
Sharing a function I have been using to get all the Fabric tenant settings and the description of each setting.
Read on for a quick note and the Python function that does the job.
Comments closedAuthor: Kevin Feasel
Eduardo Pivaral does some work:
Healthy code should not include passwords, keys, or secrets in the source code. Sometimes, developers hard-code sensitive information while testing new features but forget to remove it afterward.
How can we validate code without including sensitive information so we can take action before we publish or share code?
Click through for a couple of options. If you do have GitHub Advanced Security (part of GitHub Enterprise Cloud), you can also create a custom pattern for secret scanning that can include passwords, database connection strings, and the like.
Comments closedSemab Tariq takes us through a pair of replication options:
In the world of database replication, choosing between synchronous and asynchronous methods can have a big impact on how reliable, consistent, and fast your data is.
This blog dives into what these methods are, how they work, and when you might want to use one over the other. Whether you’re trying to keep your data super safe or just want it to move quickly, we’ll break down everything you need to know about synchronous and asynchronous replication in PostgreSQL.
Read on for a quick overview of streaming replication and the differences between asynchronous and synchronous options.
Comments closedAndrew Pruski doesn’t want to run a script:
This all seems a bit manual, doesn’t it?
What if we could automate the building of the image and the push to the container registry when we commit to the Github repository?
Thankfully, with Github Actions…we can do just that!
No more George Jetson-style button-pressing finger injuries for Andrew!
Comments closedErik Darling gives us an overview:
We can surmise a few things from this plan:
- If there are good indexes, SQL Server isn’t using them
- That hash spill is some extra kind of bad news
- Spools remain a reliable indicator that something is terribly wrong
Okay, so I’m kidding a bit on the last point. Sorta.
Read on for the scenario and how Erik would handle this case.
Comments closedSteven Sanderson counts the ways:
Counting words in a string is a common task in data manipulation and text analysis. Whether you’re parsing tweets, analyzing survey responses, or processing any textual data, knowing how to count words is crucial. In this post, we’ll explore three ways to achieve this in R: using base R’s
strsplit(), thestringrpackage, and thestringipackage. We’ll provide clear examples and explanations to help you get started.
I, of course, would commission a 128-node Hadoop cluster and write a few dozen pages of Java code to get the answer.
Comments closedManvendra Singh talks about backups:
This article will explain backup storage redundancy for Azure Cosmos DB. Backups are a critical feature to keep copies of our data to ensure data protection and recoverability in case of any accidental deletion, updating, or any kind of disaster. But this is not enough to run backups only to save its copies. We must also protect those backup copies from accidental deletes or corruption and ensure their proper resiliency should be in place to keep backups safe from any unforeseen circumstances. It depends on the criticality of your data whether you want to keep them locally to want to replicate them in other locations or regions to ensure their resiliencies.
The backup process isn’t the same as with a relational database, but it’s still critical to back up your data, for the same reasons that you’d take backups of relational data.
Comments closedHugo Kornelis digs into one type of cursor:
I have used the GLOBAL scope option, so that it is possible to step through the code one statement at a time. This option does not affect the execution plans used. The FORWARD_ONLY and READ_ONLY options are probably the most commonly used options with cursors, especially with static cursors. We will briefly look at the effect of other options for read direction and concurrency at the end of this post.
Click through to learn more about how cursors show up in execution plans and how you can tell, based on the execution plan of a static cursor, why it’s either really fast (relative to other cursor types) or really slow.
Comments closedMike Robbins wants to know your terminal:
In the evolving landscape of software development and system administration, understanding your environment is essential for ensuring that scripts and commands run as expected. One useful PowerShell function that helps identify whether a script is running within Windows Terminal is my
Test-IsWindowsTerminalfunction. This function is valuable for developers and system administrators who must tailor their scripts based on the terminal environment.
Click through for a PowerShell function that does just that.
Comments closedI’ve spent a bit of time with Microsoft’s new database watcher tool for Azure SQL recently.
There are a lot of things I like about database watcher– which is currently in preview and which refuses to Capitalize Its Name– but it does one big thing that I really, really like: it collects data from Query Store. You can access that Query Store data from built-in database watcher dashboards, query it using KQL, or (something something) in Microsoft Fabric if you’ve got money to burn on your monitoring data.
Query Store has been available since SQL Server 2016, but I haven’t yet heard of monitoring tools that truly take advantage of it. It’s about time.
This is where I’d also plug QDS Toolbox for on-premises environments. A good amount of the reporting information comes out of Query Store and it helps manage Query Store to boot.
Comments closed