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


Sep
4
answered Best value for fill factor in index
Sep
4
revised Secure way to connect: Windows Authentication or SQL Server Authentication and why?
edited title
Sep
4
comment Secure way to connect: Windows Authentication or SQL Server Authentication and why?
While that is a viable consideration for maintenance/troubleshooting, the inconvenience isn't justification to minimize security.
Sep
4
comment SQL Server LocalDB Instance; error restoring backup (MasterDBPath not available)
What is the source SQL Server edition and version of the backup file?
Aug
26
revised Secure way to connect: Windows Authentication or SQL Server Authentication and why?
edited tags
Aug
26
answered Secure way to connect: Windows Authentication or SQL Server Authentication and why?
Aug
24
comment How can i prevent decryption in SQL Server procedures
+1 I wholeheartedly agree with this answer. "My best recommendation if you are worried about IP & copyright is to secure your software with Licensing. You may not be able to prevent someone from reverse engineering your code but you can sue the pants off them if they do." I wish I could +10 that snippet.
Aug
23
revised Unable to alter authorization on an mirroring endpoint to a login with a slash in the name
edited tags
Aug
23
comment Unable to alter authorization on an mirroring endpoint to a login with a slash in the name
@JamesJiao No problem, glad to help.
Aug
22
answered Unable to alter authorization on an mirroring endpoint to a login with a slash in the name
Aug
21
revised Listing the existing SQL Server Logins and Users
edited tags
Aug
21
answered Listing the existing SQL Server Logins and Users
Aug
21
revised Listing the existing SQL Server Logins and Users
added 4 characters in body
Aug
20
revised SQL Server 2008 transaction log full
edited tags
Aug
20
comment SQL Server 2008 transaction log full
The checkpoint process can only reuse the log (in simple recovery mode) to the point of the oldest active transaction. It sounds like your bulk operation is potentially one gigantic transaction.
Aug
19
comment Two SQL Server with one TCP port
You'd really have to jump through a lot of hoops to even have this configuration mishap, as you can only install one default instance. You'd have to play around with static ports for the other instances. I see what you mean, though.
Aug
19
comment SUM and JOIN SELF
Why are you trying to denormalize the data?
Aug
19
revised SUM and JOIN SELF
added 38 characters in body; edited tags
Aug
19
comment Two SQL Server with one TCP port
"The first instance you start binds itself to listen on your_ip:1433". Your explanation is a bit wrong, or maybe I'm just misunderstanding. It has nothing to do with the sequential order of instance startup, but moreso default (TCP 1433) vs. a named instance (UDP 1434 for the port allocation service).
Aug
17
awarded  Nice Answer