Bad Database Design
A guest editorial from Andy Warren looks at a bad database design he recently ran across.
Default trace - A Beginner's Guide
This article is the beginner's guide to Default Trace. The article outlines how to query the default trace for key trace events, with a focus on DDL history.
How to Conduct Effective Data Warehouse and Business Intelligence Software Evaluations
Denise Rogers discusses the essential tasks in conducting effective software evaluations revolving around data warehousing and business intellegence. Each step has a dependency on the previous one, starting with establishing the framework of the evaluation and adding progressively elaborate data that facilitates a decision making process that is resolute.
Make a 100+ Server Inventory in 30 minutes
Learn how you can generate a server inventory in 30 minutes for all of your servers with this new article from Stanley Chan.
Who Wants to Lead the Community?
Steve Jones talks about the PASS Board of Directors election coming up this fall and hopes some of you will apply.
Exploring Derived Column Transformation in SQL Server Integration Services
Marcin Policht examines SQL Server Integration Services' component, Derived Column Transformation,and how its usefulness is enhanced by its ability to implement fairly elaborate mathematical, logical, and string operations.
Is the MVP Worth It?
The MVP award is coveted by many people and there are constant questions about how to get it. Is it worth it? Steve Jones talks about that today.
Speeding Up Incremental ETL Processes in SSIS by Using MD5 Hashes
Speeding up incremental ETL processes in SSIS by tracking changes to records in an MD5 Hash
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers