Press "Enter" to skip to content

Day: September 23, 2022

Tips on Logging in R Packages

Published 2022-09-23 by Kevin Feasel

Jamie Owen continues a series on building a package around an API:

Part 1 of this series laid out some ideas for how one might structure a {plumber} application as an R package, inspired by solutions such as {golem} and {leprechaun} for {shiny}. In this installment of the series we look at adding some functions to our package that will take care of logging as our application runs. If you haven’t already, we recommend reading the first installment of this series as the example package created for that post will form the basis of the starting point for this one.

Read the whole thing.

Comments closed

Parameter Reloading in RMarkdown

Published 2022-09-23 by Kevin Feasel

Thomas Williams wants to improve the user experience:

Recently I needed to reload a parameter, without reloading the page. The parameter was bound to a data frame, where end-users selected a value and then I looked up other fields in the data frame further down the page (for example, a name was selected, but I wanted the identifier from the same record). It wasn’t exactly intuitive, so here’s how I did it.

Click through for code and explanation.

Comments closed

Maximizing Productivity in a Meeting-Filled World

Published 2022-09-23 by Kevin Feasel

Andy Levy just wants to get things done:

We need to have these meetings. They’re where consensus is reached on cross-team projects and decisions are made about timelines. They’re where we communicate to people outside our teams what’s happening. And sometimes, they’re critical for transferring knowledge to others. These are all part of the job. For better or worse, they are a nontrivial portion of The Work.

Read on for some of Andy’s tips around scheduling meetings.

Comments closed

Rebuilding a Dedicated SQL Pool via Azure DevOps

Published 2022-09-23 by Kevin Feasel

Sarath Sasidharan clones an Azure Synapse Analytics dedicated SQL pool:

There are many scenarios where you want to create a new Synapse dedicated SQL pool environment based on an existing Synapse dedicated SQL pool environment. This may be required when you need to create a development or test environment based on your production environment by copying complete schemas and without copying data.

Note that this process won’t move the data itself—given that you’re starting with terabytes for an effective dedicated SQL pool, trying to create a bacpac would be an exercise in misery.

Comments closed

Improving SQL Server Backup Performance

Published 2022-09-23 by Kevin Feasel

Glenn Berry makes some recommendations:

Does making your SQL Server database backups twice as fast sound interesting? SQL Server 2022 has new options to help you improve SQL Server database backup performance. If you are on an older version of SQL Server, you still have options for Improving SQL Server Database Backup Performance.

In order to improve your database backup performance, you need to understand what is happening during a database backup and what your bottleneck(s) are.

Read on for an overview of the key considerations.

Comments closed

Parameterizing Stored Procedures from Power Query

Published 2022-09-23 by Kevin Feasel

Soheil Bakhshi calls a stored procedure:

From time to time, Excel users require to get the data from a SQL Server stored procedure. The stored procedures usually accept some input parameters and return the results. But how can we dynamically pass values to the stored procedures from cells in Excel to SQL Server?

Read on for two approaches to the problem. Like Soheil, I think the second approach is much smoother, in part because it isn’t 30-something steps long.

Comments closed