Windows 7 includes an ODBC manager that lets you connect from your desktop to a SQL server. You create a data source name (DSN) to save database setup information, so you can open a connection to ...

SQL Server Management Studio should be launched after connecting to a SQL Server instance. As soon as you run SSMS for the first time, the Connect to Server window appears. Object Explorer > Connect > ...

We will now use a similar technique that I covered when I created the SQL server login to create the database user account on the ServerInventory database. But before we do that, let's quickly look at ...

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part ...

And while SQL Server does share heritage with Sybase SQL Server (now called SAP ASE), a Unix database server that Microsoft ported to Windows, that happened a long time ago.