Monthly Archives: October 2014

When does a machine become human? When they can Lie…

By | October 31, 2014

Don’t worry I am not talking of androids or cyborgs. I am talking about the classical definition used to determine artificial intelligence. The most widely used benchmark or at least the most well know is The Turing test: is a test of a machine’s ability to exhibit intelligent behavior equivalent to, or indistinguishable from, that of a human.  … Read More »

Proof that MS SQL Server is the better relational database

By | October 27, 2014

I am probably going to start a war with this one but I need to set the record straight. Often in my trainings I have a mix of MS SQL Folks as well as Oracle folk. The training usually takes a detour on which is the better relational database platform. While I have been a… Read More »

Game Theory and Databases

By | October 16, 2014

CASE 1 Two members of a criminal gang are arrested and imprisoned. Each prisoner is in solitary confinement with no means of speaking to or exchanging messages with the other. The police admit they don’t have enough evidence to convict the pair on the principal charge. They plan to sentence both to a year in… Read More »

Cell level encryption

By | October 10, 2014

Encrypting data at the cell level is important in order to protect information within the database. While all users have access to view data not all users are equal. Therefore it makes sense to encrypt data in such a way that only authorized users who have a key to decrypt the data are the only… Read More »

sys.dm_exec_describe_first_result_set()

By | October 10, 2014

This DMV is probably one of the most useful DMVs for developers and Business intelligence users since it describes the data type and other columnar information of the result set. Unlike sp_help which describes a table this particular DMV or DMF actually can be used to dynamically determine the datatypes and other usage options for… Read More »

sys.dm_db_log_space_usage

By | October 10, 2014

Another DMV that is available in SQL server 2012 is the sys.dm_db_log_space_usage DMV, this DMV is useful when trying to decide the current state of the Log file. And if there is any use trying to shrink the database. This DMV could also help the DBA understand if the log file is constantly running out… Read More »

sys.dm_server_memory_dumps

By | October 10, 2014

Memory dumps are a copy of what lies in the RAM during a particular scenario such as a crash or even a manual Dump. Memory dumps are useful when working with any application because it helps identify exactly what was running on a system when the problem occurred. However with certain applications such as sql… Read More »

sys.dm_os_windows_info

By | October 10, 2014

A minor DMV with SQL Server this particular one doesn’t really provide much information about the OS other than the version and service pack level. It is nowhere near the amount of information that could be captured using other means. You can’t even say which edition of the OS its running so I really don’t… Read More »