Ask SQLServerCentral
A new feature is available on SQLServerCentral, and Steve Jones talks a little about how it fits in with your strategy here at the site. Visit ask.sqlservercentral.com and let us know what you think.
Using XML to pass and return values to procs
Tips on parsing and sculpting XML from within a SQL 2005 stored procedure
Ask SQLServerCentral
A new feature is available on SQLServerCentral, and Steve Jones talks a little about how it fits in with your strategy here at the site. Visit ask.sqlservercentral.com and let us know what you think.
Ask SQLServerCentral
A new feature is available on SQLServerCentral, and Steve Jones talks a little about how it fits in with your strategy here at the site. Visit ask.sqlservercentral.com and let us know what you think.
Ask SQLServerCentral
A new feature is available on SQLServerCentral, and Steve Jones talks a little about how it fits in with your strategy here at the site. Visit ask.sqlservercentral.com and let us know what you think.
Causation, Correlation and Crackpots
Joe Celko explores the dangers of muddling correlation and causation, emphasises the importance of determining how likely it is that a correlation has occurred by chance, and gets stuck into calculating correlation coefficients in SQL. Along the way, Joe illustrates the consequences of leaping to the wrong conclusion from correlations with tales of Pop Dread.
Generate Lots of Test Data with CROSS JOIN
“Joe Test”
“Joe Test2?
“Joe Test3?
“Arrgh! There has got to be a better way to create some test data!”
Ever had that conversation...
How to Dynamically and Iteratively Populate An Excel Workbook from SQL Server
Integration Services is a great ETL tool, allowing you to build complex and dynamic transformations. New author Marie Deschene brings us a
The Future of Bits
Feel like making a prediction this Friday? Steve Jones looks to the future with information workers and a knowledge economy. Answer this Friday poll and give us your guess about the future.
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
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...
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