PowerShell 101 for the DBA: Querying Your Servers with PowerShell
In my last blog post, I discussed how to get PowerShell and SQLPS up and running on your machine(s). And...
2009-09-22
1,919 reads
In my last blog post, I discussed how to get PowerShell and SQLPS up and running on your machine(s). And...
2009-09-22
1,919 reads
Many DBAs have heard about the new scripting technology from Microsoft, but have yet to really dive right in. You...
2009-09-15
2,514 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...
Hi. I hope someone can give some useful suggestions. My workplace have a suite...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
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;