Data Liability
The issue of who owns data, and who is responsible is one that our world hasn't defined well. Steve Jones has a few thoughts on potential issues for data professionals.
2015-09-21
114 reads
Editorial
Whatever happened to Database Table Refactoring?
Phil Factor ponders why most people lost their initial enthusiasm for refactoring databases iteratively, in parallel with the evolutionary design of the rest of the system.
2015-09-21
180 reads
The Counter Offer - Part 2
Today we have a guest editorial from Andy Warren that takes another view of the counter offer from your employer.
2019-04-03 (first published: 2015-09-18)
568 reads
The Counter Offer - Part 1
Today we have a guest editorial from Andy Warren that looks at the challenge of getting a counter offer from your employer.
2019-04-02 (first published: 2015-09-17)
1,308 reads
2015-09-16
306 reads
Who's a Good Developer?
Is there a way to tell who the good developers are? Steve Jones has a few thoughts on why this is an issue.
2015-09-15
297 reads
2015-09-14
136 reads
2019-04-29 (first published: 2015-09-14)
314 reads
2015-09-11
251 reads
2015-09-10
281 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;