2017-02-28 (first published: 2015-06-22)
2,112 reads
2017-02-28 (first published: 2015-06-22)
2,112 reads
2016-12-06 (first published: 2015-07-27)
2,511 reads
2015-08-04 (first published: 2015-07-08)
701 reads
To monitor SQL service and the host server is up and running, if down send e-mail to DBA
2015-07-16 (first published: 2015-06-15)
2,119 reads
PowerShell script to check last full backup, transaction log backup date for SQL Server databases.
2014-09-02 (first published: 2014-08-22)
1,799 reads
I was having a hard time to reading the Windows 2012 R2 Failover cluster log from my live server. That is why I just wrote a simple PowerShell script to get the job done for me.
2014-08-21 (first published: 2014-07-29)
1,729 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Be Wary of Data
Comments posted to this topic are about the item Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate, o_orderkey, o_custkey, o_storekey FROMdbo.orders WHEREo_orderkey = 3877;