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 […]
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 […]
A new video on DB mirroring
Well it’s not new exactly it was created many years back and I somehow never uploaded it. Yesterday a former client came back asking about DB mirroring and […]
Configure Email Subscriptions in SSRS
In this blog we are going to look at how to configure Email subscriptions in SSRS. Subscriptions like its names suggests is a way for the user to […]