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
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
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
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
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)
486 reads
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
Test Data Management (TDM) is essential in software development to ensure your application runs smoothly and reliably across different environments. When deploying applications in Azure, Test Data Management can...
2024-05-29 (first published: 2024-05-13)
249 reads
This article was initially posted on SQLServerCentral @ 2024-04-26.
Short answer: The column is marked as ‘deleted’ and will stop being visible/usable.
But, most importantly - The record/table size will remain...
2024-05-29
253 reads
In the introduction of this blog post series, I explained the use case: extracting data from the Planview Portfolios RESET API using Azure Data Factory. Any tool that can...
2024-05-28 (first published: 2024-05-26)
31 reads
In the introduction, I explained the setup of the use case and why we need to use the OData feed: to get the list of Project IDs, because the...
2024-05-28 (first published: 2024-05-26)
29 reads
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Team, I'm trying to figure out what will be the best recommendation to configure...
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers