Blog
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