PASS Data Architecture Virtual Chapter presents Data Warehouse Architecture
On Thursday August 18th, John Racer will discuss some common architects and practices for Data Warehouses.
2011-08-18
754 reads
Articles
2011-08-18 (first published: 2009-08-12)
9,507 reads
The Pencil Analogy
Today we have a guest editorial from Brad Wallace that is an attempt to answer the question 'Why is database engineering so expensive?'
2011-08-18
665 reads
When Did Merge Replication Subscribers Last Sync?
The article presents an automated process to see when remote servers last synced to publisher and send notification reminders.
2011-08-18
2,107 reads
SQL Server Index Maintenance Performance Tuning for Large Tables
If you think about it carefully, you’ll realise, that index maintenance is necessary and that it makes sense, and that SQL Server is not doing this task automatically according to the book.
2011-08-18
5,492 reads
My Experiences at SQL Saturday 64
A commentary of the experiences of James Dimauro at SQL Saturday #64 in Baton Rouge, LA in August 2011.
2011-08-17
517 reads
Using SQL Monitor in the Real World Webinar
On Tuesday August 23rd, Brad McGehee will take you through real-world examples to show what Red Gate SQL Monitor can do for you.
2011-08-17 (first published: 2011-07-20)
1,729 reads
Configuring the Storage Subsystem
The storage subsystem for a SQL Server can prove to be a bottleneck if the best choices of hardware aren't made, but there are ways to relieve the I/O bottlenecks if the causes are well understood. This requires benchmarking. Glenn Berry gives expert advice on getting to grips with the disk subsystem.
2011-08-17
2,286 reads
2011-08-16 (first published: 2009-08-05)
9,028 reads
Total Database Information At Your Fingertips Part I
This article will help to get some basic information from your databases that may help you in different situations.
2011-08-16
9,292 reads
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
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers