Tag Archives: SQLNewBlogger

Resetting Git and Abandoning Changes–#SQLNewBlogger

I recently had an issue in one of my Git repos, and decided to drop all my local changes and just pull down from the remote. This post looks at what I did. Another post for me that is simple … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Resetting Git and Abandoning Changes–#SQLNewBlogger

Writing Parquet Files – #SQLNewBlogger

Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it, and perhaps building a data warehouse of sorts. The modern view of data warehousing seems to be built on using a Lakehouse architecture where data moves … Continue reading

Posted in Blog | Tagged , , | 3 Comments

Reading JSON Data with Python

Recently I’ve been looking at archiving some data at SQL Saturday. As a start, I needed to read some of the archive data I have in Python. This post looks at the basics of reading in JSON data in Python, … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Deleting Stale Local Database Git Branches with SSMS–#SQLNewBlogger

I wrote a post recently about pruning branches in git. That’s part of the job, but the other part is removing local branches. This post looks at one way to do that in a semi-manual fashion. This could be automated, … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Deleting Stale Local Database Git Branches with SSMS–#SQLNewBlogger