Security Questions: Differences between “Grant” and “With Grant?”

As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work's Training on the T's, I received a large number of questions that there wasn't time to answer.  Instead of just a re-cap of all of the questions, instead I've opted to put together a post per topic.  Hopefully, this will … Continue reading Security Questions: Differences between “Grant” and “With Grant?”

Security Questions: Grant Permissions to All Stored Procedures

As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work's Training on the T's, I received a large number of questions that there wasn't time to answer.  Instead of just a re-cap of all of the questions, instead I've opted to put together a post per topic.  Hopefully, this will … Continue reading Security Questions: Grant Permissions to All Stored Procedures

SQL Server Security Webcast Questions – Series Introduction

Earlier this month, I presented an Introduction to SQL Server Security session for Pragmatic Work's Training on the T's.  A video of the session is available at the Pragmatic Works website.  As a part of that session, I received a couple dozen questions about security that we didn't have a chance to go over during … Continue reading SQL Server Security Webcast Questions – Series Introduction

XQuery for the Non-Expert – Aggregates

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In  the last post, I discussed using functions within XQuery with the Substring() function as part of the XQuery for the Non-Expert blog series.  To continue on that theme, this post is going to take a look into … Continue reading XQuery for the Non-Expert – Aggregates

XQuery for the Non-Expert – @Variable Use

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In a previous post, I discussed the exist() method as part of the XQuery for the Non-Expert blog series.  When working with the exist() method you may not always want to hardcode in the attribute values that you … Continue reading XQuery for the Non-Expert – @Variable Use

XQuery for the Non-Expert – Binary Values

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In the value() method post of my XQuery for the Non-Expert series I discussed how to take element and attributes and return them as column values.  Those methods works all fine and dandy for most data but when … Continue reading XQuery for the Non-Expert – Binary Values

XQuery for the Non-Expert – Substring() Function

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. Within the value() and query() methods it is sometimes desirable to return a portion of a string.  Similar to T-SQL, there is a substring function in XQuery that provides this functionality. In this XQuery for the Non-Expert post … Continue reading XQuery for the Non-Expert – Substring() Function