Percy Reyes
My thoughts on cryptography and SQL database Engineering
Pages
(Move to ...)
About me
Education & Experience
Academic
Database Engineering
Cryptography
Articles
Talks
▼
Tuesday, 25 July 2017
Testing database connectivity by using a Universal Data Link file
›
After installing a SQL instance, we may need to test the database connectivity from a client host to make sure that everything is working ve...
Thursday, 20 July 2017
Detecting excessive compilation and recompilation issues
›
Undoubtedly, recompilation is a big topic to reckon with, more importantly, in database environments processing data that is changing rapidl...
2 comments:
Friday, 14 July 2017
Ports and Protocols Used by Microsoft SQL Server
›
Naturally, I have been asked many times about ports used by SQL Server services and to be honest sometimes I took me some time to reply beca...
Sunday, 25 June 2017
Getting the full name of SQL Jobs including the steps in execution
›
While monitoring a database server, we may need to know some details about the sessions, connections and requests that migh be causing perf...
Monday, 19 June 2017
Error: could not obtain information about Windows NT group/user
›
Without any doubt, at times there is a need to use extended stored procedures in SQL Server, for instance, the following error may be raised...
Friday, 2 June 2017
sys.dm_exec_requests: total_elapsed_time column might return inconsistent data
›
Developing useful scripts for administration purposes, I have found a bug with respect to data recollected by 'sys.dm_exec_requests'...
‹
›
Home
View web version
