Prerequisites Have an Azure subscription. Have an Azure SQL Server in that subscription. Have an Azure SQL database named “Logbook” hosted by that Azure SQL Server. Install the Az PowerShell Module. Install the latest version of SQL Server Management Studio (SSMS) (currently v18.5). Background Information https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication https://docs.microsoft.com/en-us/azure/app-service/configure-authentication-provider-microsoft https://docs.microsoft.com/en-us/aspnet/core/tutorials/first-mvc-app/start-mvc?view=aspnetcore-3.1&tabs=visual-studio This uses SQL Server Express LocalDB, not full …
Tag: SQL Server
Nov 17 2011
Get SQL Server Version/Edition Information
Just connect to the database in which you are interested, open a new query window, and enter the following query:
|
1 2 3 4 5 |
[sourcecode language="sql"] SELECT SERVERPROPERTY('ProductVersion') as 'Product Version', SERVERPROPERTY('ProductLevel') as 'Product Level', SERVERPROPERTY('Edition') as 'Edition' [/sourcecode] |
For me, this produced the following:
|
1 2 |
Product Version Product Level Edition 10.50.1600.1 RTM Enterprise Edition (64-bit) |
Sep 27 2010
Enable SQL Server Management Studio (SSMS) to Overwrite Table Designs
By default, SQL Server Management Studio (SSMS) will not let you save changes to the designs of your tables. When you attempt to do so, it wants you to drop and re-create the table. You will typically see a dialog similar to the following: However, SSMS will actually let you perform such a change without …