A follow up to my primer on SQL Server security, with a short quiz and a video on three key ideas: granting, denying and revoking permissions.
SQL SERVER – Introduction to Discovering XML Data Type Methods – A Primer
The XML data type has five methods in SQL Server 2008. This primer from Joes 2 Pros Volume 5 introduces the XML data type methods, starting with query().
SQL SERVER – Introduction to SQL Error Actions – A Primer
Many think an error of severity 11 or higher stops the rest of the batch. This primer on SQL error actions shows it is true only most of the time.
SQL SERVER – Introduction to Basics of a Query Hint – A Primer
Query hints apply to the whole statement through the OPTION clause. This primer from Joes 2 Pros Volume 3 covers the basics of a query hint.
SQL SERVER – Introduction to Hierarchical Query using a Recursive CTE – A Primer
A primer from Joes 2 Pros Volume 2: what a CTE is, how it compares to a derived table, and how to write a hierarchical query using a recursive CTE.
SQL SERVER – Introduction to SQL Server Security – A Primer
A primer on SQL Server Security terms with a simple story: Tom needs Read access to the Financial Folder. Learn what a securable, principal and permission are.
SQLAuthority News – Uncut and Unedited – Interview of Pinal Dave on Book Authoring
I was very happy when books were published and I got a print copy in my hand. In this blog post we will discuss about Book Authoring.