Refreshed in Tuscany
I returned last Sat, 15 Jun, from 9 weeks of crazy travel. It wasn’t all for work, but it was a long stretch. I spent a good portion of...
2024-06-19
5 reads
Blog Posts
The Community is YOU, Not Any Organization
As I type this, we’re leaving behind spring, and all the amazing events that take place then, and entering the quiet time of summer. After that, we’ll go into...
2024-06-18
16 reads
Copilot Reminded Me How To Find a File Handle
Recently I was trying to delete a folder and kept getting the “something is using this, try again” dialog. It was annoying, but I couldn’t figure out what process...
2024-06-17 (first published: 2024-05-27)
557 reads
Six Months!
Oh good gosh. Six months without a single blog post. Most important information: I’m not dead. Apologies. The issue is pretty simple. I’m getting old. Ha! Seriously though, I...
2024-06-17
23 reads
Speaking at dataMinds Connect 2024
I’m very excited to announce I’ve been selected as a speaker for dataMinds Connect 2024, Belgium’s (and maybe/probably/most likely mainland Europe’s) best and greatest Microsoft data platform conference. My...
2024-06-17
5 reads
Why the masters and what lies ahead
I recently graduated with a Master’s in Strategic Communication from the University of Delaware. Attending the graduation ceremony with my sister made it a truly memorable experience. Here’s a...
2024-06-17 (first published: 2024-05-28)
292 reads
Level Up Your SQL Skills: The Best Intermediate to Advanced Courses
In the data-driven landscape of 2024, advanced SQL isn't just a nice-to-have, it's a career game-changer. Companies crave professionals who can wrangle data, uncover insights, and drive decision-making. If...
2024-06-16
55 reads
Extracting Data from the Planview Portfolios REST API using ADF – Introduction
I have a client using Planview Portfolios to manage their PMO. As part of the data warehouse, we want to extract the project data from the Planview REST API....
2024-06-14 (first published: 2024-05-26)
242 reads
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...
2024-06-14 (first published: 2024-05-20)
324 reads
ERD Your Existing Databases
There are several tools out there to make your life easier by creating an ERD for your existing db. Everything works pretty well when you have a small number...
2024-06-12 (first published: 2024-05-23)
556 reads
Blogs
A New Word: Immerensis
By Steve Jones
immerensis – n. the maddening inability to understand the reasons why someone loves you...
Deploy a Dockerized Python TODO App to Azure Container Apps Using Pulumi and Azure Key Vault
In this post, I will guide you on how to deploy a dockerized simple...
Using a Local Large Language Model (LLM): Running Ollama on Your Laptop
You can now run powerful LLMs like Llama 3.1 directly on your laptop using...
Forums
SQL Server is terminating in response to a 'stop' request from Service error
Dear All, In one of the server its repeatedly restarting sqlserver services and not...
Understanding CROSS APPLY and OUTER APPLY in SQL Server
Comments posted to this topic are about the item Understanding CROSS APPLY and OUTER...
Database Files on Shares I
Comments posted to this topic are about the item Database Files on Shares I
Question of the Day
Database Files on Shares I
I want to store database files on a file share for a SQL Server 2017 instance. Can I use \\fileserver\D$ as a location?
See possible answers