A Bad Litmus Test
A litmus test is a way of determining your answer to a question based on a single issue or response. Steve Jones sees this as a bad idea, especially when looking to hire technical people.
A Bad Litmus Test
A litmus test is a way of determining your answer to a question based on a single issue or response. Steve Jones sees this as a bad idea, especially when looking to hire technical people.
What a Data Warehouse is Not
Recently, I was at a conference, and I heard the following discussion about what a data warehouse was. One person suggested that a data warehouse was really all the old legacy systems connected by software that could access the data. By calling such a contraption a data warehouse, the organization could avoid having to do the hard and complex work of integration. There are so many problems with this federated approach to a data warehouse that they are almost not worth repeating here. But (once again!) here goes.
Introduction to the Transaction Log
The transaction log is a fairly complex construct in SQL Server and present in every database installation. New author James Rea brings us a great introduction to how the log works and how to maintain it.
Is The PASS Summit Worth It?
Steve Jones has attended the PASS Summit annually, and found value. But for this Friday's poll, did you find value this week? Or have you in the past? Let others know.
Is The PASS Summit Worth It?
Steve Jones has attended the PASS Summit annually, and found value. But for this Friday's poll, did you find value this week? Or have you in the past? Let others know.
Is The PASS Summit Worth It?
Steve Jones has attended the PASS Summit annually, and found value. But for this Friday's poll, did you find value this week? Or have you in the past? Let others know.
Is The PASS Summit Worth It?
Steve Jones has attended the PASS Summit annually, and found value. But for this Friday's poll, did you find value this week? Or have you in the past? Let others know.
Troubleshooting Reporting Services Performance Issues
The conclusion of our coverage of the Reporting Services component available in SQL Server 2005 Express Edition discusses systematizing the troubleshooting approach by focusing specifically on performance problems (as opposed to those impacting functionality).
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Tmn. Harapan Indah TLP/WA 08216977701
Komp. Taman Harapan Indah Blok EE No.1, Jelambar Baru, Daerah Khusus Ibukota Jakarta 11460
BCA KCU BEKASI CSTelpon : 0853-73737551
Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks, Jawa Barat...
BCA KCP WTC Mangga Dua TLP/WA 08216977701
Gedung WTC Mangga Dua Lantai Ground Lobby Selatan dan Lantai Upper Ground (UG) PCL001,...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers