SQL Server 2017 sys.dm_os_enumerate_fixed_drives
In SQL Server 2017, you can use the new DMV sys.dm_os_enumerate_fixed_drives to identify free disk space. The DMV is replacement...
2017-05-15
1,194 reads
In SQL Server 2017, you can use the new DMV sys.dm_os_enumerate_fixed_drives to identify free disk space. The DMV is replacement...
2017-05-15
1,194 reads
In the last two blogs, we went through Configure Distribution Database and Publication Creation. If you haven’t read them, I...
2017-05-10
2,441 reads
In the previous blog, we discussed how to Configure Distribution Database. Once you setup your Distribution database successfully, you can...
2017-05-09
1,997 reads
As a DBA, you get alerts many times regarding the database file space issue. To address the issue, you may...
2017-04-21
942 reads
I’m very pleased and delighted to share that I have been awarded Microsoft Most Valuable Professional (MVP) award 2017. This...
2017-04-14
429 reads
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
713 reads
If you are dealing with a SQL Server which got a lot of memory, you may encounter the out of...
2017-02-20
1,261 reads
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
444 reads
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
297 reads
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
13,580 reads
By Steve Jones
Today’s coping tip is to decide to lift people up rather than put them...
Tempdb is always a topic for me whether it’s in my sessions or blogs...
If you don’t have the backups of the certificate and private key from the...
Hi, I have just moved a DB from an old HP laptop, to a...
We’ve been running 400-instance clusters of t3.medium on an on-demand basis during the work...
I'm trying to develop a script that connects to SQL pulls in a list...