2010-07-20
2,606 reads
2010-07-20
2,606 reads
2010-06-29
3,040 reads
This article explains how to create policies with user defined conditions in MS SQL 2008 using PowerShell scripts
2010-05-03
4,499 reads
This article describes how to Evaluate Policies on Multiple Instances using EPM and PowerShell.
2010-03-29
5,212 reads
2010-01-18
2,498 reads
Keeping track of the space used and free in your database files is something that all experienced DBAs need to do. And something many new DBAs forget. New author Jayakumar Krishnan brings us an easy technique to do this in SQL Server 2008 with Policy Based Management.
2009-12-16
8,487 reads
2009-11-27
2,897 reads
This article describes step by step how to create Service Broker objects and set up a basic conversation between the Initiator and Target from new author Jayakumar Krishnan.
2009-09-29
8,747 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...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Comments posted to this topic are about the item Be Wary of Data
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;