Reputation
34,459
Next tag badge:
456/400 score
79/80 answers
Badges
2 49 106
Newest
 Nice Answer
Impact
~1.3m people reached

Jul
25
comment Multi-threaded inserts vs serial
This is the wrong question to ask. You have a performance problem, analyze it, find the bottleneck and address it. How to analyse SQL Server performance
Jul
24
answered SQL Server : If a query is cancelled, where to get data on it?
Jul
23
comment SQL server database performance issue
How to analyse SQL Server performance
Jul
23
comment FIPS 140-2 Compliance
Strictly speaking does not to be separate 'hardware', it can be a separate VM. But yes, once the OS enables FIPS compliance then all instances on that host will run in compliance mode.
Jul
23
answered FIPS 140-2 Compliance
Jul
22
comment Int comparison very slow in query
how many records meet the criteria posts < comments and how many records meet the criteria posts > 1000?
Jul
22
awarded  Nice Answer
Jul
22
revised How can I alter an existing Primary Key on SQL Azure?
added 75 characters in body
Jul
16
awarded  Nice Answer
Jul
15
comment SQL Server: INSERT in transaction locks the table until transaction finished
SELECT TOP 1 ... can just as well scan the entire table. Only by anbayzing the execution plan and execution stats can one tell if the table was scanned or not. You can easily inspect the lock resource on which the blocking occurs and judge if is a table or a row.
Jul
13
answered SQL Server: INSERT in transaction locks the table until transaction finished
Jul
13
comment SQL Server 2012 and DBM
How to Set Up Standard Edition AlwaysOn Availability Groups in SQL Server 2016
Jul
13
answered SQL Server 2012 and DBM
Jul
11
comment No service broker active on database
Check if you have a duplicate service_broker_guid in sys.databases
Jul
9
answered Adding a local user account into SQL Server
Jul
9
answered SSL to individual database
Jul
1
comment Measure SQL Azure Transaction Rate
with v12 you can try Query Store. Is not going to give to TPM, but will give you execution times.
Jul
1
answered Sending an automated email through a nightly job
Jun
30
comment Cannot Decrypt the encrypted columns from the database backup on local machine
Above SQL uses a master bound key to encrypt data in TestDB database. On backup/restore the key is, obviously, lost, as it stays behind on the old master. Doing such is a Bad Idea. Please read Encrypt a Column of Data. I strongly urge you to not follow posts from forum threads, including this one. Read the product spec and follow the official examples.
Jun
30
comment Cannot Decrypt the encrypted columns from the database backup on local machine
please don't post the code you found on some thread, post what you did. How did you encrypt the data. For sure you did not encrypt the data in master and restore it, did you?