DBAs – soon to disappear??
Heres a thought
With all the monitoring tools and performance gauging software available on the market these days, will there ever...
2010-05-07
592 reads
Heres a thought
With all the monitoring tools and performance gauging software available on the market these days, will there ever...
2010-05-07
592 reads
Log Shipping Issue (encountered by Abi Chapagai May 7th)
I had set up log shipping between two servers few weeks ago....
2010-05-07
7,599 reads
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-05-06
573 reads
Every week I will scour the internet for useful SQL scripts and post my favorite on here.
This weeks comes from...
2010-04-23
389 reads
On April 21 Microsoft announced SQL Server 2008 R2 has been released to manufacturing.
The downloads on Technet/MSDN on May 3....
2010-04-22
401 reads
Found out this week – that we should be restarting this service at least once a week ! (thus allowing the CPU...
2010-04-20
376 reads
Compiled by Abi Chapagai (April 2010)
Implementation of High Availability depends in the need of the business. Each of the technologies...
2010-04-18
24,340 reads
Introduction
In any distributed environment, database synchronization between two different locations or different servers’ is very essential for mission critical applications....
2010-04-18
2,241 reads
SQL Server 2008 High Availability Solution: Log Shipping
In SQL Server, transaction log provides an ability to recover a database...
2010-03-19
1,694 reads
Should we as DBAs be worried that we will become surplus to requirements if Oracle continues to enhance its capabilities to deliver a self-managing...
2010-02-23
379 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;