I have a need to compare multiple different versions of essentially the same SQL Server 2005+ databases and bring the table structures up to that which is in the newest version. It should compare ...

In SQL Server 2014 there were a number of restrictions on memory-optimized tables: you couldn't alter their structure after they were created; many SQL operators weren't supported (Outer Joins, ...

Type cast tables faster. Using the AddColumns function we can type cast each column a lot faster. No looping through data, ...

If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results. This method won't work in SQL Server, but Microsoft's Trans ...

Complexity: In SQL server’s data has to fit into tables anyhow. If your data doesn’t fit into tables, you need to design your database structure that will be complex and, again, difficult to ...