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.
Performance Improvement: Understanding
This article will cover the core understanding of the performance conversation
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.
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
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
extended events to spy on our server between 8 and 9 am
Hi, our peer who owns a remote mysql server from which we extract warehouse...
Restore Job fails in Replication
Dear Folks, Restore jobs in my SQL2022 Standard edition replication were failing on a...
visual studio seems to lose "provider" on pkg imports
hi, just to get this part out of the way, if my intended target...
Question of the Day
Vector Datatype Dimensions
The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?
See possible answers