A Great Place to Work
Do you enjoy your workplace or employer? Steve does and has a few thoughts on what that is like for him.
Django's ORM vs. Raw SQL: When to Use Which
When it comes to building websites, how you work with your database can make a huge difference in how well your site runs. That's especially true if you're using Django, a popular tool for making websites with Python. Django comes with something called an Object-Relational Mapping (ORM) layer, which is a fancy way of saying […]
SQL WAITFOR Command to Delay SQL Code Execution
One of the most rarely used commands in SQL is the WAITFOR command. It is one option to invoke a delay in program execution in absentia. Because it is sparsely used, how and where it can be applied when needed is often forgotten. For example, we could use this to mimic a user response or input or perhaps to collect data at certain intervals during the day.
State of the Database Landscape 2024: Shifting skills to match constant demands
The key findings from our industry survey reveal how the database landscape has become increasingly complex in recent years. As modern-day business demands and data needs evolve, data professionals and organizations are affected everywhere. Here are the changes coming in 2024 and beyond that you need to know about.
Take A Vote and Accept Your Loss
Learning to make decisions and then get work done is important to Steve. Read his thoughts today on many of the decisions software teams need to make.
Code Visibility: Browsing through Flyway Migration Files
If you can convert a SQL file to HTML, then you can inspect your Flyway migration files in a browser. This is especially useful if your SQL is color-coded with the same conventions as it was in your IDE. It is even better still if your browser can allow you to scan through many files, moving from file to file with a single click. This article will demonstrate how to do this with a few PowerShell scripts.
Configuration of Azure SQL Database Auditing
This article shows how you can configure auditing on your Azure SQL Database.
Understanding the Importance of Data Lineage in Modern Data Management
Data lineage is a component of modern data management that helps organizations understand the origins, transformations, and movement of their data. It is like a road map that shows us where our data has been, how it has changed, and where it is going, just like tracking the journey of a package:
Stairway to Server Management Objects (SMO) Level 1: Concepts and Basics
Learn how to get started working with SMO and PowerShell.
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers