The Unique Identifier datatype in SQL Server has tremendous potential to solve many of the issues one finds with Identity fields, other primary keys, etc. However it also has some drawbacks and limitations. Author Sharad Nandwani looks at some of the pros and cons of this datatype.
2004-06-24
14,019 reads
This short article looks at some mistakes developers should avoid when they also have the task of designing the database, database objects, or TSQL used to access it.
2003-12-16
7,934 reads
By Arun Sirpal
Straight from Microsoft’s documentation “Microsoft Entra authentication is a mechanism of connecting to Azure...
In this post, the fourth in our series, I want to share an example...
By Steve Jones
This post looks at a logic problem asked to an AI, and which is...
Comments posted to this topic are about the item Why you should avoid Implicit...
What started out as an attempt to use the SSIS Project-model combined with deployment...
With no budget for some paid tools to monitor sql server service and sql...
What options do I have in SQL Server 2022 for file and filegroup backups?
See possible answers