SQL

Posted February 01, 2018 02:16:03 When you think of Microsoft SQL, what comes to mind?You may be familiar with the classic Microsoft SQL server.Or you may be unfamiliar with the newer SQL Server 2016, which is an open-source, multi-tenant relational database.But you’ve probably never heard of Microsoft’s latest version, Microsoft SQL Database.And that’s a shame,…

The latest version of Microsoft SQL Server is finally here, and it looks like you’ll be able to use it to connect to your local SQL server, and run SQL Server code on it.SQL Server 2016 is a major update to SQL Server, which was released in 2007.This update is a massive upgrade over previous…

SQL Server 2016 (previously SQL Server 2013) has been updated to use SQL Server 2012.That makes sense, as the two operating systems share the same database, but they use different ways of handling certain data types.The database is not a single file; it’s a collection of objects.You can have multiple databases, and they all have…

When it comes to SQL, there’s a lot to learn and there are lots of different ways to do it.For example, there are several different ways you can declare a query that will execute a specific query or group of queries.And as you can see, declaring a query in the language of your choice can…