Denormalization in SQL Server for Fun and Profit
Normalization is standard practice in database design, however, an over-normalized database can have issues. This article examines the case for denormalization.
SQLRally Call for Speakers Closes December 15, 2010
The call for speakers is open through December 15, 2010, and I hope many of you will take the chance...
Costing Cool Projects
Can you accurately determine the cost or benefit of a new, cool project up front? Steve Jones thinks not, but coming up with new projects can be a way to set yourself apart from others.
24HOP Needs Women!
“Next 24 Hours of PASS on March 15-16 2011, celebrating Women’s History Month with 24 female speakers!”
Thus goes the announcement on...
Getting Started with Maps in SQL Server 2008 R2 Reporting Services
I noticed a new feature in SQL Server 2008 R2 Reporting Services that allows you to render maps in your reports. Can you provide some details on this new feature and can I take advantage of it even though don't have any spatial columns in my data warehouse?
What happens when a query is submitted?
I know, We cant cover life span of query in short. here is my another try to list some high level information...
Early December 2010 Free Training from PASS Virtual Chapters
The Performance, DBA, and B/I Virtual Chapters of PASS are back with free training.
Elections
Steve Jones found a very fascinating way that might keep elections more secure, verifiable, and also more open.
Managing Data in the Cloud
Crunching data or having access to vast amounts of data is crucial for many applications.
The Basics of Troubleshooting
After seeing several cases in the past couple of months where I felt the basics of troubleshooting were violated, I...
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
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...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
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