Unlimited PTO
A guest editorial from Andy Warren looking at the unlimited amount of vacation time from his company.
Estimated and Actual Plans Can Have Different Shapes.
Hi Brent, What is your take on Hugo Kornelis’s explanation of execution plan naming. As her his explanation, estimated exec plan is simply an execution plan whereas actual execution plan = execution plan+run-time stats. Do you agree that the naming is flawed and confusing? – Yourbiggestfan
How to use fn_builtin_permissions SQL Server Security Function
Learn how to find all securable objects in SQL Server and the permissions for each securable object using the system function fn_builtin_permissions.
Learning through Puzzles
Different people respond to different types of learning techniques. Maybe a puzzle is the way that you learn.
Understanding the Metadata Function DATABASEPROPERTYEX()
Learn how to use the DatabasePropertyEX() function to query your database for settings.
Performance Testing Databases with Flyway and PowerShell
Performance tests are central to the quality of the database changes we deliver because they ensure that any business process that accesses the database continues to return its results in an acceptable time. When Flyway creates a new version of the database, it is the ideal time to run these performance checks.
The ultimate guide to web accessibility
Accessibility ensures that everyone has a great experience on your site. Bikkani explains how to achieve web accessibility.
Pick a Database, any Database…
All sorts of project and organizational analysis go into selecting the right database system for the requirements....or so you'd think.
Getting Started with Python Pandas and Dataset Profiling
This article will focus on reading and profiling data with the pandas package when using Python as well as show how to build charts based on this data.
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
When the Token Meter is Zero
Comments posted to this topic are about the item When the Token Meter is...
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...
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