Blog: May 2013

SQL 2012 Roles, Permissions, and Schemas

Excerpt by Don Kiely

The relationship of roles, permissions, and schemas is an important security concept in SQL Server.

This course excerpt was originally posted May 31, 2013 from the online courseware SQL Server 2012, Part 5 of 9: Security Basics by Don Kiely

SQL Server


User-Defined Server Roles in SQL Server 2012

Excerpt by Don Kiely

A long awaited security feature in SQL Server 2012 has been user-defined server roles.

This course excerpt was originally posted May 30, 2013 from the online courseware SQL Server 2012, Part 5 of 9: Security Basics by Don Kiely

SQL Server


Contained Databases in SQL Server 2012

Excerpt by Don Kiely

Contained databases is an interesting new part of SQL Server 2012. This isn't directly a security feature as such, but it implements a new authentication feature and so has a security element.

This course excerpt was originally posted May 29, 2013 from the online courseware SQL Server 2012, Part 5 of 9: Security Basics by Don Kiely

SQL Server


Understanding Logins with SQL Server

Excerpt by Don Kiely

SQL Server logins are not part of Windows-they are saved in and managed by SQL Server.

This course excerpt was originally posted May 28, 2013 from the online courseware SQL Server 2012, Part 5 of 9: Security Basics by Don Kiely

SQL Server


Windows Logins via Transact-SQL

Excerpt by Don Kiely

Transact-SQL provides full support for creating logins by using the CREATE LOGIN statement.

This course excerpt was originally posted May 23, 2013 from the online courseware SQL Server 2012, Part 5 of 9: Security Basics by Don Kiely

SQL Server


SQL Server Security: The Threats

Excerpt by Don Kiely

Relational databases are used in an amazing variety of applications with connections from a dizzying array of clients, ranging from handheld devices to mainframe Web service applications.

This course excerpt was originally posted May 21, 2013 from the online courseware SQL Server 2012, Part 5 of 9: Security Basics by Don Kiely

SQL Server


SQL Server 2012: Using Snapshot Isolation

Excerpt by Don Kiely

As discussed in our previous article, concurrency that is based solely on locking can cause blocking and deadlocking problems.

This course excerpt was originally posted May 17, 2013 from the online courseware SQL Server 2012, Part 9 of 9: T-SQL Working with Data by Don Kiely

SQL Server


SQL Server 2012: Blocking and Deadlocks

Excerpt by Don Kiely

When you modify data in SQL Server, it is important to understand how isolation levels and locking can affect performance and concurrency.

This course excerpt was originally posted May 16, 2013 from the online courseware SQL Server 2012, Part 9 of 9: T-SQL Working with Data by Don Kiely

SQL Server


Updating Large Value Types with UPDATE .WRITE

Excerpt by Don Kiely

SQL Server provides an UPDATE .WRITE Transact-SQL statement to perform partial updates on columns that are defined as varchar(max), nvarchar(max), or varbinary(max).

This course excerpt was originally posted May 10, 2013 from the online courseware SQL Server 2012, Part 9 of 9: T-SQL Working with Data by Don Kiely

SQL Server


Get Ahead with Visual Studio

By Martin Schaeferle

Being able to use a foreign language well, is not only useful in your personal life, it is also incredibly attractive to employers. Foreign languages are not just those that are spoken every day around the world, however.

This blog entry was originally posted May 09, 2013 by Martin Schaeferle

C#Visual Studio


SQL Server 2012: Creating a New Table with SELECT INTO in T-SQL

Excerpt by Don Kiely

The SQL standard draws a distinction between Data Manipulation Language (DML) and Data Definition Language (DDL).

This course excerpt was originally posted May 07, 2013 from the online courseware SQL Server 2012, Part 9 of 9: T-SQL Working with Data by Don Kiely

SQL Server


Collaborating with SharePoint

By Martin Schaeferle

Let's say you're looking to beef up your resume. So you take a SharePoint tutorial.

This blog entry was originally posted May 06, 2013 by Martin Schaeferle

SharePoint


T-SQL Fundamentals: Outer Joins

Excerpt by Don Kiely

One of the fundamental concepts of relational databases is the normalization of data into tables, or sets, of similar data. Different data elements are grouped into separate tables.

This course excerpt was originally posted May 02, 2013 from the online courseware SQL Server 2012, Part 8 of 9: T-SQL Select, Where, and Clauses by Don Kiely

SQL Server


Using SharePoint to Gain a Competitive Edge

By Martin Schaeferle

For years, software manufacturers have been extolling the virtues of "collaboration." Yet more often than not, this goal was a pipe dream.

This blog entry was originally posted May 01, 2013 by Martin Schaeferle

SharePoint