Gather Always On Configuration using a DMV query
If you were like me, you would know your AG configuration by heart. However, what if you get busy with...
2018-04-26
353 reads
If you were like me, you would know your AG configuration by heart. However, what if you get busy with...
2018-04-26
353 reads
-- Health and status of WSFC cluster. These two queries work only if the WSFC has quorumSELECT*FROMsys.dm_hadr_clusterSELECT*FROMsys.dm_hadr_cluster_members
-- Health of the AGsSELECT...
2018-04-26
15,359 reads
SELECT * FROM sys.master_files AS f
CROSS APPLY sys.dm_os_volume_stats(f.database_id, f.file_id) v;
2018-04-23
318 reads
WMI has been around for a while and it has grown significantly over the years. With Microsoft's focus on powershell,...
2018-04-20
11,399 reads
USE master
exec sp_MSforeachdb '
use [?]
print ''?''
print cast(databasepropertyex(''?'', ''Updateability'') as varchar(200))
if databasepropertyex(''?'', ''Updateability'') = ''READ_WRITE ''
dbcc shrinkfile(2,1)
'
2018-04-20
302 reads
What SQL command do you use to pull and filter data from a table ?
SELECT [Column List] FROM [Table Name]...
2018-04-20
413 reads
2018-04-20
For one of my clients, I needed to know and document not only database names, size and locations but also...
2018-04-19
549 reads
When you restore a database, it will also restore all permissions along with it. But what if you are restoring...
2018-04-19
10,729 reads
I was working for a client on their very critical and heavily used database. The application was an E-commerce website...
2018-04-19
3,710 reads
Want to learn SQL and get some real practice this December? Check out the...
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
By Steve Jones
This is my last week of the year working (I guess I come back...
Mobile game development has become a cornerstone of the entertainment industry, transforming creative ideas...
Mobile app development has become a cornerstone of modern business strategies, enabling companies to...
I have listed the event names present in my system_health extended event report. Based...
Which of these indexes is superseded by another?
See possible answers