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
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
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
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
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 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 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 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
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
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
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
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
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
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