New releases of SQL Server arrive at a quick pace, and it's difficult to keep up with the many features introduced in each version. In this article, Phil Factor reviews a feature you may have missed, inline indexes. He covers the syntax and the many ways they can be used and then performs some performance tests to see if they can make a difference with table variables.
Learn how to use Power BI to retrieve data from an Azure SQL Database.
A SQL Server monitoring tool is warning you that you’re getting memory dumps, and you’re wondering what that means.
In a followup, this article includes discussion of more advanced features of using stored procedures.
SQL Server supports partially contained databases. This gives you the option of adding database users with a password inside the database. This makes the database easier to move to another instance or participate in an Always On Availability Group. In this article, Robert Sheldon explains how to work with users in contained databases.
Database encryption is hard, and somewhat controversial. Steve thinks we ought to do a better job of it.
In the next level of the Stairway to SQL Server on Linux learn about the client tools available to connect to your instance.
In this tip we cover how you can implement SQL Server cross database referential integrity using triggers.
Technical debt can cripple software development, much like financial debt hurts individuals and organizations. Steve wants to know if you measure your debt today.
A RAG pipeline that answers questions in the demo is not the same thing...
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Comments posted to this topic are about the item Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers