Monday Morning SQL Break – June 1, 2015
It’s Monday and time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow...
2015-06-01
2,301 reads
StrateSQL
Tuesday Morning SQL Break – May 26, 2015
It’s Tuesday (Monday was a holiday for me this week) and time for this week’s weekly blog and twitter round-up for...
2015-05-26
540 reads
Monday Morning SQL Break – May 18, 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-05-18
512 reads
Monday Morning SQL Break – May 11, 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-05-11
713 reads
May 2015 – SQL Server Monthly Maintenance Checklist
image source
It’s time for a monthly reminder to review you SQL Server environment. Hopefully over the last few months of...
2015-05-06
652 reads
Book Review: The Checklist Manifesto: How to Get Things Right
Earlier this year, my buddy Dan recommended that I read The Checklist Manifesto: How to Get Things Right. The recommendation...
2015-05-05
519 reads
Monday Morning SQL Break – May 4, 2015
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you don’t already, follow me on...
2015-05-04
729 reads
Monday Morning SQL Break – April 27, 2015
It’s been a while since I’ve posted a blog post. After the new year, I had been trying to decide...
2015-04-27
604 reads
Reblog: December 26 to January 1
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2015-01-02
631 reads
Reblog: December 19 to December 25
Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...
2014-12-26
596 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;