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 […]
administration / MSSQL / TSQL
sys.dm_exec_describe_first_result_set()
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 […]
sys.dm_db_log_space_usage
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. […]
sys.dm_server_memory_dumps
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 […]
sys.dm_os_windows_info
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 […]
sys.Dm_db_database_page_allocations()
This new DMV is basically a modified version of the DBCC IND command that is used to display the page allocations for a specific database object like a […]
Business Intelligence on a Phone Bill
I often tell my trainees that BI can be done on pretty much anything. A common example of this is the Phone Bill or the Bank statement. Your […]
Why BI professionals should believe in Aliens
I am pretty serious about this one, not because I believe in UFOs or any other extra-terrestrial theory but because as a DBA who implements Business Intelligence solutions […]
Row level permissions in SQL Server
We all know that SQL allows object level permissions down till the table, some of even know that it allows permissions at the column level too. But recently […]
Metrics vs Mass appeal? What companies probably don’t yet understand.
I wanted to ask a question today instead of blogging about a topic. To be honest I don’t know the answer to this question and that is why […]