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.
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Comments posted to this topic are about the item Removing TDE
Comments posted to this topic are about the item The day-to-day pressures of a...
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
How do I remove TDE encryption of data from database xxx?
See possible answers