Monday Morning SQL Break – January 11, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-01-25
518 reads
StrateSQL
2016 Polar Plunge
In just a few weeks… on January 30th, I’m going to be jumping into White Bear Lake in Minnesota. Now...
2016-01-05
407 reads
Monday Morning SQL Break – January 4, 2016
It’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me...
2016-01-04
434 reads
Monday Morning SQL Break – December 21, 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-12-21
446 reads
Monday Morning SQL Break – December 28, 2015
It’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me...
2015-12-18
310 reads
Monday Morning SQL Break – December 14, 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-12-14
414 reads
Monday Morning SQL Break – December 7, 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-12-07
432 reads
Monday Morning SQL Break – November 30, 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-30
825 reads
Tuesday Morning SQL Break – November 24, 2015
It’s Tuesday time for this week’s one day late blog and twitter round-up for last week. If you haven’t already, follow me...
2015-11-24
527 reads
Download Analytic Platform System Tools and Books Online
Photo Credit – Mario KlingemannMicrosoft’s Analytic Platform System (APS) has been a favorite platform of mine over the last few years....
2015-11-20 (first published: 2015-11-17)
1,756 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;