21,410 reputation
33573
bio website blogs.msdn.com/b/sql_pfe_blog
location In the Ocean somewhere...
age
visits member for 2 years, 9 months
seen 7 hours ago

SQL Server Premier Field Engineer at Microsoft.

Twitter: @SQLife
Blog: http://blogs.msdn.com/b/sql_pfe_blog/
Email: sqlsalt [at] outlook [dot] com

Disclaimer
The views expressed on my posts on this site are mine alone and do not reflect the views of my company. All posts of mine are provided "AS IS" with no warranties, and confers no rights.

The following disclaimer applies to all code, scripts and demos available on my posts:

This Sample Code is provided for the purpose of illustration only and is not intended to be used in a production environment. THIS SAMPLE CODE AND ANY RELATED INFORMATION ARE PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR PURPOSE. We grant You a nonexclusive, royalty-free right to use and modify the Sample Code and to reproduce and distribute the object code form of the Sample Code, provided that You agree: (i) to not use Our name, logo, or trademarks to market Your software product in which the Sample Code is embedded; (ii) to include a valid copyright notice on Your software product in which the Sample Code is embedded; and (iii) to indemnify, hold harmless, and defend Us and Our suppliers from and against any claims or lawsuits, including attorneys’ fees, that arise or result from the use or distribution of the Sample Code.


Nov
12
answered Using multiple Active Directory accounts to connect to SQL Server
Nov
11
revised Case style of tables and field (Naming Conventions)
added 20 characters in body
Nov
11
answered Case style of tables and field (Naming Conventions)
Nov
2
revised sql server removing service_queues
edited tags
Nov
2
revised How to grant a user UNSAFE ASSEMBLY permission
added 14 characters in body
Nov
2
answered sql server removing service_queues
Nov
2
revised How to grant a user UNSAFE ASSEMBLY permission
added 504 characters in body
Nov
2
answered How to grant a user UNSAFE ASSEMBLY permission
Oct
31
comment Difference between Intel and AMD chips?
+1 Great information, Glenn!
Oct
31
comment Partitions and Indexes, in which cases should be used
+1 Neither is a replacement for the other. Two very different technologies for two very different outcomes.
Oct
24
answered Is it possible to determine what part of a stored procedure is currently executing?
Oct
23
comment Whitelist-based SQL Server schema setup
Are they in the db_owner database role?
Oct
23
comment Security and Performance implications of “View Server State”
I guess I'm missing the mark with this question, I don't see anything in the question that indicates the necessity for the permission.
Oct
23
comment Security and Performance implications of “View Server State”
Why would you want to give it away needlessly to begin with? What are you gaining out of that??
Oct
23
comment Whitelist-based SQL Server schema setup
We need more info about the database principles that you are using. What roles/permissions do these users have?
Oct
23
answered Security and Performance implications of “View Server State”
Oct
23
revised Restricting mail sending from SQL Server 2008
added 2 characters in body
Oct
23
revised SQL Server Schema Security
added 2 characters in body
Oct
17
comment How can I get a copy of the SQL generated by Management Studio?
The long term answer is to become well-versed with T-SQL so you don't rely on GUI.
Oct
15
revised SQL Server Schema Security
added 32 characters in body