SQL tools overview - SSDT,SSMS, VSC and Azure data studio

 https://docs.microsoft.com/en-us/sql/tools/overview-sql-tools?view=sql-server-ver15

Visual Studio Code is the official SQL Server extension that supports connections to SQL Server and rich editing experience for T-SQL in Visual Studio Code. Write T-SQL scripts in a light-weight editor.

SSDT - A modern development tool for building SQL Server relational databases, Azure SQL databases, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.

SSMS Manage a SQL Server instance or database with full GUI support. Access, configure, manage, administer, and develop all components of SQL Server, Azure SQL Database, and Azure Synapse Analytics. Provides a single comprehensive utility that combines a broad group of graphical tools with a number of rich script editors to provide access to SQL for developers and database administrators of all skill levels.

Azure data studio A light-weight editor that can run on-demand SQL queries, view and save results as text, JSON, or Excel. Edit data, organize your favorite database connections, and browse database objects in a familiar object browsing experience.

roast vs toast

 roast  vs toast

Toast is used to mean to make something warm and crisp

Roast is to cook food such as meat or vegetables in an oven

learnersdictionary.com

 

SQL Server Data Tools (SSDT)

 https://docs.microsoft.com/en-us/sql/ssdt/project-oriented-offline-database-development?view=sql-server-ver15

Using SSDT, you can create an offline database project and implement schema changes by adding, modifying or deleting the definitions of objects (represented by scripts) in the project, without a connection to a server instance.

 

Azure SQL Database firewall

 

Azure SQL Database firewall

https://docs.microsoft.com/en-us/azure/security/fundamentals/infrastructure-sql#azure-sql-database-firewall

What is the difference between different categories of Ethernet cables? (CAT5 / CAT5e / CAT6 / CAT6a)

 https://www.startech.com/en-nz/faq/network-cables-ethernet-categories

Category	Typical Application	Maximum frequency	Maximum length for application
CAT5	10/100 Mbps Ethernet	100 Mhz	100 meters for 100BASE-T
CAT5e	10/100/Gigabit Ethernet	100 MHz	100 meters for 1000BASE-T
CAT6	Gigabit Ethernet	250 MHz	100 meters for 1000BASE-T
CAT6a	10-Gigabit Ethernet	500 MHz	100 meters for 10GBASE-T

Office 365 E3 vs Microsoft 365 E3

 https://www.microsoft.com/en-us/licensing/product-licensing/microsoft-365-enterprise?activetab=m365-enterprise:primaryr5

Microsoft 365 Enterprise includes Office 365 Enterprise, Windows 10 Enterprise, and Enterprise Mobility + Security and is offered in two plans - Microsoft 365 E3 and Microsoft 365 E5

太清澈的水是没有鱼的，太精明的人是没有智慧的。

 太清澈的水是没有鱼的，太精明的人是没有智慧的。

水至清则无鱼，人至察则无徒

班固的《汉书.东方朔传》

'tide you over' or 'tie you over'?

 it seems both ok

tide me over is more formal

Fortisip Vs Ensure Plus

 https://www.nutritionlunatic.com/fortisip-vs-ensure-plus/

quotes

I would likely pick Fortisip as long as I could afford it. While Ensure Plus does have more nutrients than Fortisip, its high sugar content and the inclusion of two genetically modified ingredients simply can’t be overlooked.

However, I’d like to point out that both drinks can be a good option

Batch processing

 https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/batch-processing

• Batch processing. The high-volume nature of big data often means that solutions must process data files using long-running batch jobs to filter, aggregate, and otherwise prepare the data for analysis. Usually these jobs involve reading source files, processing them, and writing the output to new files.

remove a greyed-out app in windows 10 using powershell

Microsoft  Your phone app became greyed out

we could not remove it traditionally

Get-AppxPackage | Select Name, PackageFullName

Remove-AppxPackage Microsoft.YourPhone_1.21084.67.0_x64__8wekyb3d8bbwe

Microsoft.YourPhone_1.21072.161.0_x64__8wekyb3d8bbwe

Remove-AppxPackage Microsoft.YourPhone_1.21072.161.0_x64__8wekyb3d8bbwe

Star schema overview

 https://docs.microsoft.com/en-us/power-bi/guidance/star-schema

Star schema is a mature modeling approach widely adopted by relational data warehouses. It requires modelers to classify their model tables as either dimension or fact.

Dimension tables describe business entities—the things you model. Entities can include products, people, places, and concepts including time itself. The most consistent table you'll find in a star schema is a date dimension table. A dimension table contains a key column (or columns) that acts as a unique identifier, and descriptive columns.

Fact tables store observations or events, and can be sales orders, stock balances, exchange rates, temperatures,

 

JSON object; JSON arrays

JSON object literals are surrounded by curly braces {}.

avaScript uses square brackets [ ] on either end of its array type

 https://www.w3schools.com/js/js_json_objects.asp

https://www.w3schools.com/js/js_json_arrays.asp

https://www.digitalocean.com/community/tutorials/an-introduction-to-json

descriptive, diagnostic, predictive, prescriptive

 

FORTRAN programming

 The first FORTRAN program ran today in 1954. Invented by IBM, FORTRAN was designed to simplify the highly complex programming process with simple algebra-like expressions when writing software.

--- steal from manning publisher

change fritz box dns server

 Configuring a DNS server

    Click "Internet" in the FRITZ!

    Click "Account Information" in the "Internet" menu.

    Click on the "DNS Server" tab. ...

    If you want to configure other DNSv4 servers: ...

    If you want to configure other DNSv6 servers:

I’m still here and living one day at a time

 I’m still here and living one day at a time

Are you sure you want to upgrade UAP-AC-LR from 5.43.38.12731 to 5.43.43.12741?

 Are you sure you want to upgrade UAP-AC-LR from 5.43.38.12731 to 5.43.43.12741?

yes

Connections to your Azure Database for MySQL server communicate over port 3306

 Connections to your Azure Database for MySQL server communicate over port 3306. When you try to connect from within a corporate network, outbound traffic over port 3306 might not be allowed by your network's firewall. If so, you can't connect to your server unless your IT department opens port 3306.

Connections to your Azure Database for PostgreSQL server communicate over port 5432

 Connections to your Azure Database for PostgreSQL server communicate over port 5432

Connections to your Azure Database for PostgreSQL server communicate over port 5432. When you try to connect from within a corporate network, outbound traffic over port 5432 might not be allowed by your network's firewall. If so, you can't connect to your server unless your IT department opens port 5432.

az extension add --name azure-cli-iot-ext is old version, use the newest version of the Azure IoT extension, called azure-iot

 https://docs.microsoft.com/en-us/azure/iot-hub/iot-hub-device-management-iot-extension-azure-cli-2-0

 the newest version of the Azure IoT extension, called azure-iot. The legacy version is called azure-cli-iot-ext.You should only have one version installed at a time. You can use the command az extension list to validate the currently installed extensions.

Use az extension remove --name azure-cli-iot-ext to remove the legacy version of the extension.

Use az extension add --name azure-iot to add the new version of the extension.

To see what extensions you have installed, use az extension list.

securecd.sys did not allow old cd games to function after some 2015 W7 SP2 ( or convenience pack) or newer w8, w8.1 , w10 and sure w11

 securecd.sys  did not allow old cd games to function after some 2015 W7 SP2 ( or convenience pack) or newer w8, w8.1 , w10 and sure w11 

I had to reverse the W7 SP2 to play old games

clone a 500GB (317GB in use) to a HP 500GB SSD -- using a free commercial version of Macrium Reflect

 5.38 hours

usb 2 enclosure used for the HP SSD sata disc

free edition of Macrium Reflect

straight cloned the disk to the ssd in the usb enclosure

then swap the discs

all good

login seems faster without a domain controller available

other bits not sure yet

WHAT’S THE DIFFERENCE BETWEEN USB-C, THUNDERBOLT 3, THUNDERBOLT 4, AND USB4?

 https://eshop.macsales.com/blog/74922-difference-usb-c-thunderbolt-usb4/

USB-C is a connection type.  USB-C is not Thunderbolt 3, Thunderbolt 4, or USB-4. It is only the connection that those technologies use