Free Advanced SQL Course for June: Don’t Miss Out!
Summer is here, and it's the perfect opportunity to enhance your SQL expertise with LearnSQL's special offer. For the entire month of June 2024, they are giving away their...
2024-06-04
59 reads
Blog Posts
Large System Databases on SQL Server
This one is an oldie in my blog drafts, but a goodie! So, I will finally post it after nearly three years of sitting around. Thank you, past self,...
2024-06-04
76 reads
Automating Container Image Builds with Docker Build Cloud and Github Actions
In a previous post we went through how to use Docker Build Cloud to remotely build a Docker container image from a Github repository. In that example, we kicked...
2024-06-03 (first published: 2024-05-17)
234 reads
Power BI: Refreshable Excel Files in PBI Service
Ever since Excel made its debut in the 1980’s, it has been used as a quick way for end users to input and manipulate data on their own without...
2024-06-03 (first published: 2024-05-14)
386 reads
Sharpen Your SQL Skills: June’s Challenge Awaits!
This June, LearnSQL is throwing down the gauntlet with a fresh SQL Practice challenge. Dive into a real-world gym database and help Christine, the gym's manager, wrangle her data....
2024-06-01
60 reads
A New Word: desanté
desanté – n. the brooding delirium of being sick, which makes time slow to a trickly and turns even the most pathetic of tasks into monumental struggles, until the...
2024-05-31
11 reads
Denver Dev Day – Best Practices for Database Deployments Resources
I delivered a talk today on database deployment best practices at the Denver Dev Days 2024. This is a great event, and I have been lucky enough to attend...
2024-05-31
25 reads
Friday Basics: RPO and RTO
I did a post last month titled RTO and RPO are myths unless you've tested recovery, but I only briefly covered what RPO and RTO are. This post goes...
2024-05-31 (first published: 2024-05-10)
499 reads
T-SQL Tuesday #174: Your Favorite Job Interview Question
My blog has been quiet lately. I recently wrapped up a master’s program (more details on that soon, once the formal graduation is behind me) and have been immersed...
2024-05-31 (first published: 2024-05-14)
488 reads
Full-Text Search in SQL Server: A Comprehensive Guide
Introduction Full-Text Search in SQL Server is a feature that provides linguistic search capabilities against text data in SQL Server tables. It allows for searching of character-based data types...
2024-05-29 (first published: 2024-05-13)
414 reads
Blogs
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers