Explore
-
Featured
Set up SQL Server Express on Mac
Many businesses use Microsoft SQL Server…even more utilize Macs. For those projects that you don’t want to push to a production server, Microsoft SQL Server Express is a wonderful tool that can be leveraged right from your local Mac using Docker and Microsoft Azure Data Studio. Download Docker for Mac Docker is available for download… Read more
-
Import Data from Google Sheet to R
R is a great tool to aggregate data across different sources and with the growth of Google Suite in business and academics, being able to import from a Google Sheet can be quite useful. Thanks to a few powerful packages, googlesheets and googledrive, Google Suite objects can easily be referenced in R scripts. Sign into… Read more
-
Automatically Connect to SQL Using Windows Credential Manager and R
The Windows Credential Manager can be used to securely store user id’s and passwords, so they can be referenced in code without being written in your code when automating a sign in process. This opens up the door to access secure objects, such as a Microsoft SQL Server databases, as shown below. To see how… Read more
Follow My Blog
Get new content delivered directly to your inbox.
Realms of Pearl 