Redmond Magazine

Use the Best Security for SQL Server

The first parameter ('BUCKSOFT\Marjorie') is the name of the SQL Server login you want to grant access to this database. You can supply a second parameter for the Database user name, but if you leave ...
Redmond Magazine

Exploiting SQL Server 2008 Through Code

SQL Server 2008 has a ton of new DBA features, but if you really want to make this thing go, just crank out a little code. SQL Server 2008 is mostly in the domain of system and database administrators ...
Visual Studio Magazine

In the Era of .NET Core, Microsoft Revamps SQL Server Data Access

Microsoft announced a new data access driver for SQL Server that should be the path forward for data developers in the era of .NET Core. As the traditional, Windows-only .NET Framework is basically ...
TechRepublic

Understanding roles in SQL Server security

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 in ...
Ars Technica

SQL server application question

I use a GUI front end to an SQL server database to do my job, and the program that is used to access the database is very old, made by Sybase, and is dated 1997. Sybase Adaptive Server Anywhere 6.0 is ...