Stop Food Waste - OS Open Data & SQL Azure
An attempt to use Ordanance Survey OS Open Data, SQL Server and SharePoint in the construction of a system for supermarkets to supply expiring food to nearby homeless shelters.
SQL Server Prefetch and Query Performance
Prefetching can make a surprising difference to SQL Server query execution times where there is a high incidence of waiting for disk i/o operations, but the benefits come at a cost. Mostly, the Query Optimizer gets it right, but occasionally there are queries that would benefit from tuning.
A SSIS Design Pattern for Change Data Capture
The design pattern described in this article can be used to develop very efficient CDC operations in large scale implementations.
We Need to Learn Encryption
With all the recent worms and attacks out there, it's only a matter of time before someone focuses more on databases. With that in mind, Steve Jones thinks it's important we learn and use encryption and better security now.
Developing a SSRS report using a SSAS Data Source
After designing several SSRS reports based on regular relational databases, your boss would now like several new reports to be designed and rolled out to production based on your organization's SSAS OLAP cube. How do you get started with designing a report based on a cube?
SQL Saturday #141 - South Florida
A free day of training in Davie, FL this weekend. Come by if you can
The Danger of Custom Software
Is it worth writing your own software? Steve Jones says you ought to really think about it and perhaps spend time looking to buy something before you build a new application.
A first look at SQL Server 2012 Availability Group Wait Statistics
If you are trouble-shooting an AlwaysOn Availability Group topology, a study of the wait statistics will give a pointer to many of the causes of problems. Although several wait types are documented, there is nothing like practical experiment to familiarize yourself with new wait stats, and Joe Sack demonstrates a way of testing the sort of waits generated by an availability group under various circumstances.
SQL Server Central Webinar Series #19: Proactive Data Growth Management
Our 19th webinar will feature Brad McGehee talking about storage challenges, costs, and potential solutions for better managing your data. Tuesday, June 12, at 4:00pm GMT.
13 Disasters
This editorial that was originally published on Aug 15, 2007. It is being rerun as Steve is traveling. This editorial looks at the issues that happen in production and how you should perhaps plan for disasters.
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Innova Crysta Car Hire Delhi: A Smart Choice for Comfortable Group Travel
Traveling in a busy city like Delhi often requires a vehicle that is spacious,...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers