Day 2 of 31 Days of Disaster Recovery: Protection From Restoring a Backup of a Contained Database
Day 2 of 31 Days of Disaster Recovery: Protection From Restoring a Backup of a Contained Database
31 Days of Disaster...
2013-01-02
1,754 reads
Day 2 of 31 Days of Disaster Recovery: Protection From Restoring a Backup of a Contained Database
31 Days of Disaster...
2013-01-02
1,754 reads
Tempdb Contention That Can’t be Soothed By Adding Files
Tempdb Contention via Idera diagnostic manager
I’ve talked a lot in the past...
2012-12-21
1,454 reads
Cross-database Queries by Contained Users
http://www.necromaticmedia.com/2007/11/containment/
I presented to the Pacific Northwest SQL Server User Group / PASS Chapter (PNWSQL) last night on...
2012-12-14
1,639 reads
Recent Presentation Session Files
Session Files – A Little Behind
I’ve been a little tardy about getting my session files posted, and I’m...
2012-11-15
879 reads
T-SQL Tuesday #36 – SQL Community
T-SQL Tuesday #36 - SQL Community
This blog entry is participating in T-SQL Tuesday #36, hosted this month...
2012-11-13
959 reads
Don’t Be That PASS Summit Guy
PASS Summit 2012 Speaker
The SQL PASS Summit 2012 is just around the corner. Every year...
2012-10-22
1,201 reads
Man Vs Machine
Man Vs Machine
Are you a fan of the television show Man Vs Food starring foodie Adam Richman? In...
2012-08-23
1,070 reads
Why Attending a Monday Pre-con Will Be Awesome
PASS Summit 2012 Speaker
The SQL PASS Summit 2012 is coming up in a...
2012-07-16
1,127 reads
Performing Fast Searches of Query Plans
XML: Fast as a Turtle
I've made blog posts in the past on using the exist()...
2012-07-12
1,282 reads
Is SELECT Identity() … INTO Minimally Logged in Simple Recovery?
Extreme Logging
I was having a discussion with Idera (@idera_software) dev lead Vicky...
2012-06-30
2,198 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;