In this series of blog posts the focus is going to be on the MS SQL Server 2014 Cloud Backups feature. Most companies will be easily able to […]
administration / Azure / Database / MSSQL
administration / Azure / Database / MSSQL
SQL 2014 Cloud Backups Part 3
You should see the screen below Make sure you set the Access as Private to ensure that only those with the proper permissions have access. Once created you […]
It’s gorGEOus what you can do with this data type
Had some spare time on my hand today and created the company logo in the MS SQL Server Geometry datatypes. The Geography and Geometry datatypes are one the […]
Proof that MS SQL Server is the better relational database
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 […]
Game Theory and Databases
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 […]