Author: tabcom

Microsoft SQL Server 2014 Express

https://msdn.microsoft.com/en-us/sqlserver2014express.aspx

Microsoft offers the following Microsoft SQL Server 2014 Express components for download:

• LocalDB (SqlLocalDB)
  • LocalDB is a lightweight version of Express that has all its programmability features, yet runs in user mode and has a fast, zero-configuration installation and short list of pre-requisites. Use this if you need a simple way to create and work with databases from code. It can be bundled with Application and Database Development tools like Visual Studio or embedded with an application that needs local databases.

Benefits

Small installer (20MB+)
Simplified. It does do not require configuration or administration.
Run as a low privileged user.
Simple installation.
Offers the same T-SQL language as SQL Server Express. It supports stored procedures,  geometry and geography data types, triggers, views.
LocalDB uses the same sqlservr.exe as other editions of SQL Server and the same client-side providers.
LocalDB doesn’t create any database services; LocalDB processes are started and stopped automatically when needed.
Unlimited local connections.
It is the default development database for SQL Server Data Tools (SSDT).
You can create instances of LocalDB programmatically using LocalDBCreateInstance or using system.data.localdb.
LocalDB supports named instances.

Limitations

Allows only local connections(!)
Only Named Pipes connections(!)
Limited to use one CPU.
It supports ADO.NET but does not support ADO.
The system databases, SQL Server error logs,  are stored in the AppData folder in the user profile.

• Express (SQLEXPR)
  • Express edition includes the SQL Server database engine only. Best suited to accept remote connections or administer remotely.

• Express with Tools (SQLEXPRWT)
  • This package contains everything needed to install and configure SQL Server as a database server including the full version of SQL Server 2014 Management Studio. Choose either LocalDB or Express depending on your needs above.

• SQL Server Management Studio Express (SQLManagementStudio)
  • This does not contain the database, but only the tools to manage SQL Server instances, including LocalDB, SQL Express, SQL Azure, full version of SQL Server 2014 Management Studio, etc. Use this if you already have the database and only need the management tools.

• Express with Advanced Services (SQLEXPRADV)
  • This package contains all the components of SQL Server Express including the full version of SQL Server 2014 Management Studio. This is a larger download than “with Tools,” as it also includes both Full Text Search and Reporting Services.

Continue reading “Microsoft SQL Server”

Incoming

Type	IMAP
Server name	tablelandscomputers.com
Security	SSL (port 993)
Require sign in?	Yes; username and password

Outgoing

Type	SMTP
Server name	tablelandscomputers.com
Security	SSL (port 465)
Require sign in?	Yes; username and password

POP3 versus IMAP

Simple Mail Transfer Protocol (SMTP) is the protocol used for sending emails.  Post Office Protocol 3 (POP3) and Internet Message Access Protocol (IMAP) are two different protocols (methods) used to access email.  When using POP3 your email program will check with the mail server every 5 minutes or so to see if there is new email.  Your email program will then download all new email from the mail server to the mail program.   When using IMAP however, your email program will leave all email on the mail server and simply provide you with a representation of your mailbox instead.  Of the two, IMAP is the better option – and the recommended option – when you need to check your emails from multiple devices, such as a work laptop, a home computer, or a tablet, smartphone, or other mobile device.  When using IMAP, your email program will present you with the contents of your mailbox without removing data from the mail server in the process.

SSL/TLS vs STARTTLS

We recognize the following protocols and ports:

• IMAP uses port 143, but SSL/TLS encrypted IMAP uses port 993.
• POP uses port 110, but SSL/TLS encrypted POP uses port 995.
• SMTP uses port 25, but SSL/TLS encrypted SMTP uses port 465.

STARTTLS was used to inform email clients still connecting on the ‘plain text’ ports that encrypted communication using SSL/TLS is available on dedicated ports.

The defacto standard these days is to block ports 110, 143, 25, 995 and only allow:

• SSL/TLS encrypted IMAP on port 993.
• SSL/TLS encrypted SMTP on port 465.