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.
2009-11-09
854 reads
Articles
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.
2009-11-09
6,637 reads
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.
2009-11-06 (first published: 2008-07-02)
40,638 reads
2009-11-06
28 reads
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.
2009-11-06
657 reads
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.
2009-11-06
752 reads
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.
2009-11-06
788 reads
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).
2009-11-06
2,804 reads
Using T-SQL CROSS APPLY and OUTER APPLY
That said, even though my personal focus is pretty much OO, I still miss stuff. SQL Server 2005 came out with the CROSS APPLY and OUTER APPLY operators and I have just started learning how to use APPLY in the last month or so. When I think I have it figured out, I am fortunate enough that some of you are interested in reading about my understanding of the technology.
2009-11-06
7,434 reads
The ADO.NET Managed Providers team wants to hear your opinion
Take this survey and help out the Managed Provider team at Microsoft.
2009-11-05
797 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers