Microsoft Data Platform – MVP 2017!!!
I’m very pleased and delighted to share that I have been awarded Microsoft Most Valuable Professional (MVP) award 2017. This...
2017-04-14
431 reads
SQL Geek
Read Statistics Histogram using DMV
DMV: sys.dm_db_stats_histogram (object_id, stats_id)
For a long time, the DBCC SHOW_STATISTICS command was the only way to get information about statistics....
2017-02-22
930 reads
Out of memory error because of the very low virtual address space – Error 701 – Trace Flag 8075
If you are dealing with a SQL Server which got a lot of memory, you may encounter the out of...
2017-02-20
1,271 reads
After migrating SQL Server from 2005 to higher version, the waits type PAGELATCH_UP increased
Recently, I experienced an interesting issue where I found SQL Server wait type PageLatch_UP went up drastically after migration. Let’s...
2017-02-06
521 reads
SQL Server Service Information
DMV: sys.dm_server_services
Microsoft SQL Server 2008 R2 SP1 and SQL Server 2012 has a new set of DMVs. One of them...
2017-01-11
360 reads
Disk Space Monitoring using SQL Server DMV
DMV : sys.dm_os_volume_stats
Being a SQL Server database administrator, you may often receive alerts or asked by Senior DBAs to check, if...
2017-01-09
17,389 reads
New String Function – TRIM – in SQL Server vNext
As SQL developer, you must have often come across a scenario where you need to remove the empty spaces at...
2017-01-06
2,062 reads
When was SQL Server installed?
In this blog post. Let us learn about how to retrieve date and time when the SQL Server was installed. To retrieve...
2017-01-04
13,164 reads
Identifying Blocking Chain in SQL Server
HAPPY NEW YEAR 2017!!
I hope you all had a good Christmas and New Year. I always try to review my...
2017-01-01
10,850 reads
Configure Internal and Private Networking for Hyper-V Virtual Machines
In the previous tutorial, we went through how to setup “External Network” to access the internet on Hyper-v client machine....
2016-12-25
2,771 reads
Blogs
DevUp 2025 Recap
By DataOnWheels
Had an incredible time at DevUp in St. Louis this weekend! This conference gets...
How AI is Shaping Sustainable Textile Solutions
By Chris Yates
The textile world is undergoing a transformation, one where creativity meets computation, and tradition...
Microsoft Exchange Hybrid Deployment Vulnerability – Shared Service Principal
By Brian Kelley
On August 6, 2025, Microsoft announced a vulnerability with hybrid deployments because of a...
Forums
MongoDB and NodeJS in action
Comments posted to this topic are about the item MongoDB and NodeJS in action
azure vm has to be rebooted more often than we'd like
Hi we're noticing this 2022 server gets into a funk now and then. Specifically,...
why do my advanced i/o column lengths on city keep changing
hi , every time i go back to an ssis pkg that is under...
Question of the Day
Data recovery from an Index
Is it possible to recover data from a non-clustered index on the firstname and lastname columns in case of corruption?