A Fine Slice Of SQL Server
John MacKintosh troubleshoots an issue:
I recently updated my R installation, and then realised that I’d broken my VSCode/ R set up in the process – I could not launch an R terminal either directly or via radian.
I have a repo where I’ve collated various blog posts relating to setting up VSCode for R, but that didn’t solve all my problems.
I did get it resolved eventually, and here’s how.
Read on for that resolution. H/T R-Bloggers.
Comments closedIf you’re like me, Plan Explorer has always been a must-have tool in your performance tuning arsenal. And one of the things that made it so useful was a simple little SSMS Integration that would allow you to right click on an Execution Plan and see “View with […] Plan Explorer.”
Unfortunately, I started hearing reports of that no longer being available in SSMS v19. But I know a thing or two, so was willing to bet 30 minutes of time that I could get it back.
Andy won that bet, so shower him with accolades.
1 CommentI wrote a blog post a few months ago about the tools I use on my jumpbox you can read here. Since then, I have automated most of the install with Chocately and so I’ll have the script later I’m going to blog it here. First, we need to install Chocately on the jumpbox by opening PowerShell as the adminstrator.
Read on to see how to do that, the installation of a slew of tools via Chocolatey, and then several Powershell modules.
Comments closedMarco Russo and Alberto Ferrari try out some templates:
Thanks to Bravo for Power BI, creating a Date table and applying time intelligence calculations to existing model measures has never been easier. With a few clicks, the Power BI model gets the required updates, and you can further modify the code generated.
Bravo provides several ready-to-use templates based on the Time Intelligence patterns published on the DAX Patterns website. However, the pattern may not provide all the features required. There could be columns and measures you want to remove, or you might need additional columns or time intelligence calculations that are not part of the template.
Read on to see two ways you could resolve this.
Comments closedNicola Rennie and Colin Gillespie provide an overview of Quarto:
Earlier this year, Posit (formerly RStudio) released Quarto. Quarto is an open-source scientific and technical publishing system that allows you to weave together narrative text and code to produce high-quality outputs including reports, presentations, websites, and more.
One of the main features of Quarto is that it isn’t just built for R. It’s language-agnostic. It can render documents that contain code written in R, Python, Julia, or Observable. That makes it incredibly useful if you work in multilingual teams, or collaborate with people who write in a different programming language from you. But what if you don’t use any other programming languages? What benefits does Quarto bring to people who only use R?
Read on to learn why you might want to use it over R Markdown.
Comments closedUst Oldfield provides an introduction to dbt:
dbt is an abbreviation for data build tools. It is primarily a SQL based transformation workflow, supported by yaml, to allow teams to collaborate on analytics code whilst implementing software engineering best practices like modularity, portability, CI/CD, testing, and documentation.
dbt is available using a CLI in the form of dbt core, or as a paid-for SaaS product in the form of dbt cloud.
Click through to see how the product works, including an example.
Comments closedChad Callihan tries out schema comparison in Azure Data Studio:
Do you need a tool for comparing database schemas? Azure Data Studio can be your answer. Let’s walk through using Azure Data Studio’s Schema Compare extension.
Read on for an overview of the product.
Comments closedKoen Verbeeck does a bit of installation:
For those of you that have been working on an older version of SSIS/SQL Server (2014-2016, something like that), the BI components (SSIS/SSAS/SSRS) are now extensions in Visual Studio. SQL Server Data Tools (SSDT) is no longer available as a separate download.
So you’ll need a full-blown version of Visual Studio (make sure you only install the workflows you actually need). The good news is that you can use the community edition of VS if you’re just using it for BI development. Anyway, install VS 2022 on your machine and download the SSIS extension here.
Read on for the full installation process and a couple of warnings.
Comments closedMike Cornell announces MLflow 2.0:
Today, we are thrilled to announce the availability of MLflow 2.0. Building upon MLflow’s strong platform foundation, MLflow 2.0 incorporates extensive user feedback to simplify data science workflows and deliver innovative, first-class tools for MLOps. Features and improvements include extensions to MLflow Recipes (formerly MLflow Pipelines) such as AutoML, hyperparameter tuning, and classification support, as well modernized integrations with the ML ecosystem, a streamlined MLflow Tracking UI, a refresh of core APIs across MLflow’s platform components, and much more.
I like a lot of what MLflow does; it’ll be interesting to see how quickly different products adopt 2.0.
Comments closedLukas Vileikis continues a series on MySQL backup options:
There are many tools we can use to back up our MySQL databases. Some are well-known and used by the best technology companies out there (
mysqldumpcomes to mind), and some are a little less famous, but still have their place in the MySQL world. Entermydumper– the tool is built by the engineering team over at Percona and it‘s supposedly created to address performance issues caused bymysqldump.
Read on to see what it is and how it works.
Comments closed