Write for SQLServerCentral
We are looking for new content here for the site, based on your experiences in the real world. Submit something and get yourself published.
Producing JSON Documents from SQL Server queries via TSQL
Although SQL Server supports XML well, XML's little cousin JSON gets no love. This is frustrating now that JSON is in so much demand. Maybe, Phil Factor suggests, it is possible to leverage all that XML, and XPath, goodness in SQL Server to produce JSON in a versatile way from SQL Queries? Yes, it so happens that there are plenty of alternatives.
Balancing Learning
How do you determine when you use a new technique or stick with a tried and true method? Steve Jones notes that we try to teach you new things at SQLServerCentral, but do you use them?
Extract and convert all Excel worksheets into CSV files using PowerShell
Can PowerShell provide an easy way to export Excel as a CSV? Yes. Tim Smith demonstrates that whether you have multiple Excel files, or just multiple worksheets in Excel, PowerShell simplifies the process.
The Development Backup
Backing up your development environment can be important. After all, aren't your developers producing products that you use?
What is DevOps really?
Ops and Development people have plenty of ideas for improving the whole software delivery process, but the task of developing, maturing and communicating these ideas isn't often in their...
Comparing Different Data Types
Comparing columns of different data types can be a drain on resources, as well as our sanity. This is a look into a few strategies for dealing with implicit conversions.
Patching Problems
Problems with SQL Server after applying the Windows 8.1 update have Steve Jones concerned about software updates.
Introduction to the SQL Server Analysis Services Neural Network Data Mining Algorithm
In data mining and machine learning circles, the neural network is one of the most difficult algorithms to explain. Fortunately, SQL Server Analysis Services allows for a simple implementation of the algorithm for data analytics. Dallas Snider explains
Failure
This week Steve Jones has a poll to make you think based on Tim O'Reilly's look back at how he succeeded and failed with his company.
Blogs
Databases and AI Agents
By Arun Sirpal
As part of my wider work exploring Claude Code and AI-assisted database engineering, I...
Creating a Pulsing Conducting Baton - Part 1
By Bert Wagner
Train Wreck The last time I watched a high school band nearly fall apart mid-performance...
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
Forums
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Distance Metric Algorithms
Comments posted to this topic are about the item Distance Metric Algorithms
What Can AI Really Do?
Comments posted to this topic are about the item What Can AI Really Do?
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers