Dynamically Create Tables Based on an Access Table
Create and Load Sql Server Tables based on Dynamic Access Database
Testing
We know that software testing is important, but we often don't do a great job of executing. Steve Jones talk database testing today.
Exploring Query Plans in SQL
SQL Server keeps the most-used execution plans in cache, so it doesn't need to recompile the same queries every time. How can we benefit from this to find potential performance problems in execution plans?
Data Lakes
An interesting new paradigm popped up in the news this week: the data lake. It examines data as a model for organizational architectures.
SQL Server PCI DSS Security Patching Checklist
PCI DSS has strict requirements about implementing security updates and using only applications which are supported by the vendors. How do you create a patching policy for SQL Servers?
Multiple Backup Files
This Friday Steve Jones looks at your backup system and wonders how many people use striped backups.
Backing up your SQL Server to Amazon's Cloud in Three Easy Steps
John Grover explains how to set up Amazon S3 storage, install and configure the Amazon PowerShell module, and set up a Maintenance plan using SQL native backups and PowerShell.
Two Days Off
Verizon is taking their cloud service offline for maintenance for two days. Steve Jones doesn't think that sounds good.
Archiving Hierarchical, Deleted Transaction Using XML
When you delete a business transaction from the database, there are times when you might want to keep a record of the data for posterity. In this article, Dwain Camps looks at a tidy means of doing just that.
Test Your Situation
One of the important things is to be able to recover your environment. That doesn't mean you need to know everything about SQL Server and potential disasters, but you should know their affect on your situation.
Blogs
Databases and AI Agents
By Arun Sirpal
As part of my wider work exploring Claude Code and AI-assisted database engineering, I...
Creating a Pulsing Conducting Baton - Part 1
By Bert Wagner
Train Wreck The last time I watched a high school band nearly fall apart mid-performance...
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
Forums
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Distance Metric Algorithms
Comments posted to this topic are about the item Distance Metric Algorithms
What Can AI Really Do?
Comments posted to this topic are about the item What Can AI Really Do?
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers