SQL Server Data Tools (SSDT) is a toolset which provides an environment for you to carry out all your database design work in SQL Server. It can be used to build to build SQL Server relational databases.
In the second part of his series, Nicolas Prigent describes in detail how to automate the login process using PowerShell and Azure CLI. Nicolas also explains how to retrieve information about your Azure subscription.
If you can understand the data model then you can understand the intent of the application developers.
The use of NULL values in a database can be controversial. Today Steve talks about his views on this concept.
Either you've got too many indexes, or not enough. Here's how to tell.
This is the first article in a short series of SQL Server query challenges to test and expand your SQL Server querying skills
One of the benefits of SQL is the ability to write a query and use parameters to dynamically act upon the resultset. Depending on the situation, there can be benefits to parameterizing queries, but it is not always clear when or how to do this. In this tip we look at different ways to pass in values as parameters to queries and the advantages and disadvantages.
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
Comments posted to this topic are about the item Lots of FKs
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Comments posted to this topic are about the item Can You Let Go of...
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers