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
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers