TSQL Challenge 30 - A Matrix Transposition challenge in TSQL
This is a matrix transposition challenge. Your job is to change the position of the numbres in a 5x5 matrix.
Generating Insert Statements
This article from new author Oleg Netchaev describes the cursor-less script used to generate insert statements. This allows you to efficiently and easily add data generation statements to your project deployments.
More, More, More
This Friday's poll asks what changes the community might like to see at SQLServerCentral.
Business Intelligence is a Growing Field
How do you, as a database administrator, display the wealth of knowledge in your Database to the organization in a meaningful way -- Business Intelligence.
Backup SQL Server to Amazon S3 with CloudBerry Backup
In this sponsored article from Cloudberry, learn how you can backup your SQL Server data to the Amazon EC3 cloud.
Free Advice or Free Consulting
A guest editorial from Grant Fritchey today talks examines the free advice that is often given in the forums. It's not free consulting and you shouldn't expect that.
SSIS object search using T-SQL
Easily determining what objects are located in all your SSIS packages can be a challenging endeavor. James Greaves brings us a technique that can help you determine which packages might need to be changed based on objects you alter in your database.
Working with Spatial Data Part II - Plotting Shapes and Storing Geocoded Data
Continuing from Part I of the Spatial Data series we model an in-memory/persistent data repository for storing geocoded data and plot the data.
The ORM Dilemma
Steve Jones talks about ORM frameworks and the dilemma of using them. They save time, but might not solve all your problems.
Efficient SQL Server Indexing by Design
Having a good set of indexes on your SQL Server database is critical to performance. Efficient indexes don't happen by accident; they are designed to be efficient. Greg Larsen discusses whether primary keys should be clustered, when to use filtered indexes and what to consider when using the Fill Factor.
Blogs
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Forums
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Secure Communications
Comments posted to this topic are about the item Secure Communications
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers