Monday Morning SQL Break – November 16, 2015
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-11-16
400 reads
StrateSQL
Monday Morning SQL Break – November 9, 2015
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2015-11-09
311 reads
Monday Morning SQL Break – November 2, 2015
It’s Wednesday and time to revive the Monday summary of last week’s blog activity and links shared on twitter. Hopefully I’ll be...
2015-11-04
423 reads
PASS Summit Session Follow-up: The Plan Cache Whisperer
I’ve wrapped up my session at my first session at this year’s PASS Summit. My session this Thursday was The Plan...
2015-10-29
807 reads
Monday Morning SQL Break – August 3, 2015
It’s (finally) time for Monday’s weekly blog and twitter round-up for last week (it’s even on time). This post is...
2015-08-03
593 reads
Monday Morning SQL Break – July 27, 2015
It’s past time for the Monday blog and twitter round-up for last week, but better late than never (or not)....
2015-08-02
628 reads
Monday Morning SQL Break – June 22, 2015
It’s (actually) Monday and time for this week’s weekly blog and twitter round-up for last week. If you haven’t already,...
2015-06-22
586 reads
PASSMN Presentation Follow-Up: Strategies for SQL Server Index Analysis
This past Tuesday, I got a chance to speak at the Minnesota SQL Server User Group. It was a great...
2015-06-19
517 reads
Thursday Morning SQL Break – June 15, 2015
It’s Thursday and time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-06-18
684 reads
Monday Morning SQL Break – June 8, 2015
It’s time for this week’s weekly blog and twitter round-up for last week, it would be better timed if I...
2015-06-10
594 reads
Blogs
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Trace Flag 1448 – Lessons from a Technical Interview
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)
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Automatically generate tabular model partitions
Hi. I hope someone can give some useful suggestions. My workplace have a suite...
SQLPS and syspolicy_purge_history job
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Question of the Day
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;