How To Audit Data Changes In SQL Server?
Scenario:
I was at a new client, with their previous and only DBA / DEVELOPER/ MASTER OF ALL of 8 years all...
2018-05-10
5,850 reads
Scenario:
I was at a new client, with their previous and only DBA / DEVELOPER/ MASTER OF ALL of 8 years all...
2018-05-10
5,850 reads
You may and should have monitoring in place to monitor state of your servers, services, jobs, critical and not critical...
2018-04-27
692 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
9,463 reads
If you were like me, you would know your AG configuration by heart. However, what if you get busy with...
2018-04-26
345 reads
If you are a DBA, especially Infrastructure DBA, Production DBA or Operations DBA then you don't necessarily always know what...
2018-04-26
376 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
313 reads
2018-04-20
WMI has been around for a while and it has grown significantly over the years. With Microsoft's focus on powershell,...
2018-04-20
9,634 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
291 reads
What SQL command do you use to pull and filter data from a table ?
SELECT [Column List] FROM [Table Name]...
2018-04-20
396 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers