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 […]
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 […]
CHN SQL Azure 17th -19th
Just finished an action packed MSBI training in HYD and now on a quick break before heading to Chennai for SQL Azure training. Can’t wait to meet and […]
Why I Train
It is always rewarding to hear back from those who have attended my trainings. Recently I have been getting a lot of emails and face to face meetings […]
SQL INJECTION using Dynamic SQL and How to fix it
At a training recently I was explaining how to do as well as prevent SQL injection and figured I should make a blog about it since very few […]
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 […]
MUMBAI 18th Aug to 20th Aug
Training DBAs in Mumbai on MS SQL Server 2012 HA. Visiting the city after a short while hope to do more sightseeing this time around.